Microsoft SQL Server Training Syracuse, NY

Attend Online or Onsite

 Course Descriptions  Class Schedules  Group Training  Student Reviews

Certstaffix® Training offers Microsoft SQL Server training in Syracuse. Our SQL Server classes in Syracuse are available in several different training formats. We have multiple attendance methods which allow you to choose the most convenient way for you to learn Microsoft SQL Server in Syracuse. Attend Microsoft SQL Server classes at home, work, or our locations. If we have self-paced eLearning, you can attend it from home or work on your own schedule.

 Instructor-led Courses:

Syracuse, NY Microsoft SQL Server Training Classes

Course Title	Length	Location
Administering Microsoft SQL Server 2012/14/16 Databases (70-462)	5 day(s)	Syracuse, NY (Online or Onsite)	Course Details ➥
Implementing a Data Warehouse with Microsoft SQL Server 2012/14/16 (70-463)	5 day(s)	Syracuse, NY (Online or Onsite)	Course Details ➥
Microsoft SQL Server 2012/14/16 Reporting Services (SSRS)	5 day(s)	Syracuse, NY (Online or Onsite)	Course Details ➥
Querying Microsoft SQL Server 2012/14/16 (70-461)	5 day(s)	Syracuse, NY (Online or Onsite)	Course Details ➥
MySQL Workbench: Data Modeling & Development	4 day(s)	Syracuse, NY (Online or Onsite)	Course Details ➥
SQL Querying - Advanced	1 day(s)	Syracuse, NY (Online or Onsite)	Course Details ➥
SQL Querying - Basic	2 day(s)	Syracuse, NY (Online or Onsite)	Course Details ➥

 Self-Paced eLearning:

Course Title	Length
eLearning Bundle - Microsoft SQL Server	6 course(s)	Details ➥
eLearning Bundle - SQL Querying	1 course(s)	Details ➥

› NY Registration Note: We only accept students into our classes whose tuition is being paid by an employer or sponsoring organization. Self-paying individuals cannot enroll. ‹

Syracuse, NY Microsoft SQL Server Course Descriptions

 Instructor-led Courses: Live Online:  From Your Location or Ours OR Group Onsite:  At Your Organization
Administering Microsoft SQL Server 2012/14/16 Databases (70-462)  Length: 5 day(s)  Public Class Price: $2925/person (USD)  Group Class Price: Request Quote This course is intended for Database Professionals who perform installation, maintenance, and configuration tasks as their primary areas of responsibility. They will often set up database systems and are responsible for making sure those systems operate efficiently. They also make sure that the data they store is backed up regularly, stored effectively, and that the data is secure from unauthorized access. This course will be taught using 2012 software, however, 2014 and 2016 can attend due to similarities. Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact Prometric, Pearson Vue or the corresponding testing provider to take a certification exam. View Course Details ➥
Implementing a Data Warehouse with Microsoft SQL Server 2012/14/16 (70-463)  Length: 5 day(s)  Public Class Price: $-/person (USD)  Group Class Price: Request Quote The primary audience for this course is Extract Transform Load (ETL) and Data Warehouse Developers. They are most likely to focus on hands-on work creating business intelligence (BI) solutions including data cleansing, ETL, and Data Warehouse implementation. This course will be taught using 2012 software, however, 2014 and 2016 can attend due to similarities. Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact Prometric, Pearson Vue or the corresponding testing provider to take a certification exam. View Course Details ➥
Microsoft SQL Server 2012/14/16 Reporting Services (SSRS)  Length: 5 day(s)  Public Class Price: $2925/person (USD)  Group Class Price: Request Quote This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to: Plan for, install, configure, and customize SQL Server 2012 Reporting Services; Retrieve data with SELECT queries; Generate reports from the Report Wizard and from scratch; Enhance your reports with charts, images, gauges, and maps; Add value to reports through summarizing, totaling, and interactivity; Build reusable report templates; Embed Visual Basic, .NET functions and subreports into your reports; Enable end-user access to reports via the Report Server and its Report Manager web interface; Integrate SSRS reports with your own websites and custom applications This course is taught with 2012 software, however, 2014 and 2016 users can attend due to the similarities. Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact Prometric, Pearson Vue or the corresponding testing provider to take a certification exam. View Course Details ➥
Querying Microsoft SQL Server 2012/14/16 (70-461)  Length: 5 day(s)  Public Class Price: $2925/person (USD)  Group Class Price: Request Quote This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are seeking to prove their skills and knowledge in writing queries. This course will be taught using 2012 software, however, 2014 and 2016 can attend due to similarities. Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact Prometric, Pearson Vue or the corresponding testing provider to take a certification exam. View Course Details ➥
MySQL Workbench: Data Modeling & Development  Length: 4 day(s)  Public Class Price: $2280/person (USD)  Group Class Price: Request Quote MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The course covers the interface and explains how to accomplish each step by illustrating best practices visually. Clear examples, instructions, and explanations reveal, in a single volume, the art of database modeling. Complete coverage Installation and Configuration; Creating and Managing Connections; Data Modeling Concepts; Creating an ERD; Defining the Physical Schemata; Creating and Managing Tables; Creating and Managing Relationships; Creating and Managing Views; Creating and Managing Routines; Creating and Managing Routine Groups; Creating and Managing User & Groups; Creating and Managing SQL Scripts; Generating SQL Scripts; Forward Engineering a Data Model; Synchronize a Model with a Database; Reverse Engineering a Database; Managing Differences in the Data Catalog; Creating and Managing Model Notes; Editing Table Data; Editing Generated Scripts; Creating New Instances; Managing Import and Export; Managing Security; Managing Server Instances View Course Details ➥
SQL Querying - Advanced  Length: 1 day(s)  Public Class Price: $495/person (USD)  Group Class Price: Request Quote In this course you will compose Advanced SQL queries to retrieve desired information from a database. You will build on derived tables and common expressions, group and summarize data, explore advanced where clauses and finally write advanced queries. This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle or MySQL will benefit by attending. The courseware and lab environment provided will be Microsoft SQL Server. View Course Details ➥
SQL Querying - Basic  Length: 2 day(s)  Public Class Price: $990/person (USD)  Group Class Price: Request Quote In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses. This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle or MySQL will benefit by attending. The courseware and lab environment provided will be Microsoft SQL Server. View Course Details ➥

 Instructor-led Courses:

Live Online:  From Your Location or Ours

Group Onsite:  At Your Organization

Administering Microsoft SQL Server 2012/14/16 Databases (70-462)

 Length: 5 day(s)  Public Class Price: $2925/person (USD)  Group Class Price: Request Quote

This course is intended for Database Professionals who perform installation, maintenance, and configuration tasks as their primary areas of responsibility. They will often set up database systems and are responsible for making sure those systems operate efficiently. They also make sure that the data they store is backed up regularly, stored effectively, and that the data is secure from unauthorized access.

This course will be taught using 2012 software, however, 2014 and 2016 can attend due to similarities.

Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact Prometric, Pearson Vue or the corresponding testing provider to take a certification exam.

View Course Details ➥

Implementing a Data Warehouse with Microsoft SQL Server 2012/14/16 (70-463)

 Length: 5 day(s)  Public Class Price: $-/person (USD)  Group Class Price: Request Quote

The primary audience for this course is Extract Transform Load (ETL) and Data Warehouse Developers. They are most likely to focus on hands-on work creating business intelligence (BI) solutions including data cleansing, ETL, and Data Warehouse implementation.

This course will be taught using 2012 software, however, 2014 and 2016 can attend due to similarities.

View Course Details ➥

Microsoft SQL Server 2012/14/16 Reporting Services (SSRS)

 Length: 5 day(s)  Public Class Price: $2925/person (USD)  Group Class Price: Request Quote

This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role.

In this course you will learn to: Plan for, install, configure, and customize SQL Server 2012 Reporting Services; Retrieve data with SELECT queries; Generate reports from the Report Wizard and from scratch; Enhance your reports with charts, images, gauges, and maps; Add value to reports through summarizing, totaling, and interactivity; Build reusable report templates; Embed Visual Basic, .NET functions and subreports into your reports; Enable end-user access to reports via the Report Server and its Report Manager web interface; Integrate SSRS reports with your own websites and custom applications

This course is taught with 2012 software, however, 2014 and 2016 users can attend due to the similarities.

View Course Details ➥

Querying Microsoft SQL Server 2012/14/16 (70-461)

 Length: 5 day(s)  Public Class Price: $2925/person (USD)  Group Class Price: Request Quote

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are seeking to prove their skills and knowledge in writing queries.

This course will be taught using 2012 software, however, 2014 and 2016 can attend due to similarities.

View Course Details ➥

MySQL Workbench: Data Modeling & Development

 Length: 4 day(s)  Public Class Price: $2280/person (USD)  Group Class Price: Request Quote

MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The course covers the interface and explains how to accomplish each step by illustrating best practices visually.

Clear examples, instructions, and explanations reveal, in a single volume, the art of database modeling.

Complete coverage

Installation and Configuration; Creating and Managing Connections; Data Modeling Concepts; Creating an ERD; Defining the Physical Schemata; Creating and Managing Tables; Creating and Managing Relationships; Creating and Managing Views; Creating and Managing Routines; Creating and Managing Routine Groups; Creating and Managing User & Groups; Creating and Managing SQL Scripts; Generating SQL Scripts; Forward Engineering a Data Model; Synchronize a Model with a Database; Reverse Engineering a Database; Managing Differences in the Data Catalog; Creating and Managing Model Notes; Editing Table Data; Editing Generated Scripts; Creating New Instances; Managing Import and Export; Managing Security; Managing Server Instances

View Course Details ➥

SQL Querying - Advanced

 Length: 1 day(s)  Public Class Price: $495/person (USD)  Group Class Price: Request Quote

In this course you will compose Advanced SQL queries to retrieve desired information from a database. You will build on derived tables and common expressions, group and summarize data, explore advanced where clauses and finally write advanced queries.

This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle or MySQL will benefit by attending. The courseware and lab environment provided will be Microsoft SQL Server.

View Course Details ➥

SQL Querying - Basic

 Length: 2 day(s)  Public Class Price: $990/person (USD)  Group Class Price: Request Quote

In this course you will compose basic SQL queries to retrieve desired information from a database. You will explore database concepts, write simple SELECT queries, use built-in functions and expressions, join tables, build subqueries and unions, and finally perform some advanced where clauses.

This course is taught using Microsoft SQL Server, but students using versions of SQL such as Oracle or MySQL will benefit by attending. The courseware and lab environment provided will be Microsoft SQL Server.

View Course Details ➥

 Self-Paced Courses: Prefer a self-paced learning solution to fit your own schedule? Certstaffix® Training offers eLearning courses bundled together: Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off. Lecture utilizing video and recorded screen shots 6 month subscription length
eLearning Bundle - Microsoft SQL Server  Length: 6 Course(s)  Price: $1310/person (USD)  Access Length: 6 Months This eLearning Bundle includes these 6 courses: Exploring SQL Server 2016, SQL Server 2016 Core, Microsoft 70-461: Querying SQL Server 2012, Microsoft 70-462: Administering SQL Server 2012 Databases, Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 and SSRS 2014. Certification exams are administered by third party testing companies. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact testing provider to take a certification exam. View Course Details ➥
eLearning Bundle - SQL Querying  Length: 1 Course(s)  Price: $500/person (USD)  Access Length: 6 Months This training course provides a thorough introduction to SQL and shows you how to generate business reports from your relational database management system (RDBMS). The course begins by providing an overview of the history of SQL, how databases work, and common SQL statements. Then, you'll learn how to work with SQL, from creating reports with simple SELECT statements to writing queries to retrieve data from multiple tables. The course also covers conditional processing with the CASE function and how to insert, update and delete records. This SQL course is applicable for use with all major databases, including Oracle, SQL Server and MySQL. Differences between databases will be pointed out where they exist. View Course Details ➥

 Self-Paced Courses:

Prefer a self-paced learning solution to fit your own schedule? Certstaffix® Training offers eLearning courses bundled together:

Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
Lecture utilizing video and recorded screen shots
6 month subscription length

eLearning Bundle - Microsoft SQL Server

 Length: 6 Course(s)  Price: $1310/person (USD)  Access Length: 6 Months

This eLearning Bundle includes these 6 courses: Exploring SQL Server 2016, SQL Server 2016 Core, Microsoft 70-461: Querying SQL Server 2012, Microsoft 70-462: Administering SQL Server 2012 Databases, Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012 and SSRS 2014.

Certification exams are administered by third party testing companies. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact testing provider to take a certification exam.

View Course Details ➥

eLearning Bundle - SQL Querying

 Length: 1 Course(s)  Price: $500/person (USD)  Access Length: 6 Months

This training course provides a thorough introduction to SQL and shows you how to generate business reports from your relational database management system (RDBMS). The course begins by providing an overview of the history of SQL, how databases work, and common SQL statements. Then, you'll learn how to work with SQL, from creating reports with simple SELECT statements to writing queries to retrieve data from multiple tables. The course also covers conditional processing with the CASE function and how to insert, update and delete records. This SQL course is applicable for use with all major databases, including Oracle, SQL Server and MySQL. Differences between databases will be pointed out where they exist.
View Course Details ➥

Microsoft SQL Server Classes at Home in Syracuse

With the temporary interruption of COVID-19, many of our clients are wondering how they can attend Microsoft SQL Server training in Syracuse from the comfort of their home. We offer live online Microsoft SQL Server training at home and we provide all the software and courseware needed for class. Find out how you can learn Microsoft SQL Server at home during this time from a live instructor.

Syracuse, NY Instructor-led Microsoft SQL Server Classes

Microsoft SQL Server Instructors

Learn Microsoft SQL Server from a live instructor so you can ask questions & interact with peers.

Complete Lab Environment

Access to all software required is provided in a lab environment during public classes.

Hands-on Learning

Learn Microsoft SQL Server hands on in Syracuse live online - learn by actually doing.

Multiple Attendance Options

Live Online From Your Location or Our Computer Labs
Onsite at Your Organization

Our Public Classes Are Taught Live Online: Either at Our Locations or Your Home/Office

Class

Start Date

End Date

Location

Price

Class Format

SQL Querying - Basic
Register ➥

Mon - Nov 2, 2020

Tue - Nov 3, 2020