Microsoft SQL Server Training Topeka, KS

Attend Online or Onsite


Microsoft SQL Server Training

Certstaffix® Training offers Microsoft SQL Server training in Topeka. Our SQL Server classes in Topeka 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 Topeka. 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:

Topeka, KS Microsoft SQL Server Training Classes

Self-Paced eLearning:





Microsoft SQL Server Training  Topeka, KS Microsoft SQL Server Course Descriptions

Instructor-led Courses:

Live Online: From Your Location or Ours

OR

Group Onsite: At Your Organization

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 ➥
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 ➥
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 ➥
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 ➥
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 ➥
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 ➥
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



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 ➥
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 Topeka

With the temporary interruption of COVID-19, many of our clients are wondering how they can attend Microsoft SQL Server training in Topeka 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.



Filter By:   |  

Topeka, KS 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 Topeka 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
Administering Microsoft SQL Server 2012/14/16 Databases (70-462)
Register
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.
Mon - Nov 16, 2020 Course Details: Fri - Nov 20, 2020 Certstaffix Training

Your Home/Work, US
Live Online
Remote Instructor
SQL Querying - Basic
Register
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.
Wed - Nov 18, 2020 Course Details: Thu - Nov 19, 2020 Certstaffix Training

Your Home/Work, US
Live Online
Remote Instructor
SQL Querying - Basic
Register
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.
Mon - Nov 30, 2020 Course Details: Tue - Dec 1, 2020 Certstaffix Training

Your Home/Work, US
Live Online
Remote Instructor
Microsoft SQL Server 2012/14/16 Reporting Services (SSRS)
Register
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.
Mon - Dec 7, 2020 Course Details: Fri - Dec 11, 2020 Certstaffix Training

Your Home/Work, US
Live Online
Remote Instructor
Querying Microsoft SQL Server 2012/14/16 (70-461)
Register
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.
Mon - Dec 14, 2020 Course Details: Fri - Dec 18, 2020 Certstaffix Training

Your Home/Work, US
Live Online
Remote Instructor
SQL Querying - Basic
Register
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.
Tue - Dec 15, 2020 Course Details: Wed - Dec 16, 2020 Certstaffix Training

Your Home/Work, US
Live Online
Remote Instructor
SQL Querying - Advanced
Register
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.
Thu - Dec 17, 2020 Course Details: Thu - Dec 17, 2020 Certstaffix Training

Your Home/Work, US
Live Online
Remote Instructor
MySQL Workbench: Data Modeling & Development
Register
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
Mon - Jan 4, 2021 Course Details: Thu - Jan 7, 2021 Certstaffix Training

Your Home/Work, US
Live Online
Remote Instructor
SQL Querying - Basic
Register
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.
Wed - Jan 6, 2021 Course Details: Thu - Jan 7, 2021 Certstaffix Training

Your Home/Work, US
Live Online
Remote Instructor
SQL Querying - Advanced
Register
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.
Fri - Jan 8, 2021 Course Details: Fri - Jan 8, 2021 Certstaffix Training

Your Home/Work, US
Live Online
Remote Instructor

KS 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.

TSQL

Having a regional database management system like Microsoft SQL definitely comes in handy when you want to stay competitive in your field. This program is designed for a business enterprise, and contains the components that you need to manage all of your company's information efficiently. Certstaffix Training offers you a variety of training options once you decide to get Microsoft SQL training.

If you only have a small group of people who need the training, you may want to opt for the public class. This class is led by an instructor and provides you with a hands-on learning experience. This way, you can ask questions and get the answers you need in real time. You may also get the opportunity to work with other students to make the software easier to understand.

If there are several people at your office who need to get Microsoft SQL training, it's a good idea to hire a private instructor. The teacher will come to your office, and customize the material that you learn based on your professional needs. This will ensure that you are familiar with all parts of the program before the end of your training.

For more information on the Microsoft SQL and other professional classes Certstaffix Training is offering, visit www.certstaff.com.



Microsoft Blogs

Microsoft User Groups

Microsoft Online Forums


Microsoft SQL Server Training Microsoft SQL Server Course Reviews by Certstaffix® Training

Researching Microsoft SQL Server training options? Need Microsoft SQL Server reviews to find a quality training provider?


Certstaffix® Training provides Microsoft SQL Server classes. Both the price of Microsoft SQL Server courses and the quality of a training provider are important aspects to be considered when choosing to purchase Microsoft SQL Server training.


Certstaffix® Training collects detailed Microsoft SQL Server class reviews via a formal post-class evaluation in all our training sessions. Below are a sample of abbreviated reviews from real students from our past Microsoft SQL Server courses. If you would like more reviews or ones with even further detail, please contact us and we would be happy to show you the high quality of our training services.


Microsoft SQL Server is a relational database management system (RDBMS) from Microsoft that is designed for the enterprise environment. SQL Server delivers breakthrough mission-critical capabilities with native in-memory performance and operational analytics. Comprehensive security features help protect your data at rest and in motion. Organizations gain more profound insights into their data with capabilities that go beyond business intelligence to perform advanced analytics directly within their database and present rich visualizations for business intelligence on any mobile device or workstation. While we offer a wide selection of classes, Microsoft SQL Server is one of the most popular topics in our catalog and with good reason. Our SQL Server classes are comprehensive, concise, cover everything from SQL Server Basics to Advanced and convenient to give you the utmost flexibility to take the course from anywhere. All classes are delivered by one of our experienced trainers.

From hands-on, instructor-led live online Microsoft SQL Server training for individual employees to private online or on-site group training, we provide the best option for your company. Our online SQL classes are task-based and focus on real-world scenarios and challenges students face in their day to day environments. The online SQL Training that we offer is a great way to quickly build upon the necessary skills within the privacy of your own home or office. If you are looking for local Microsoft SQL Server courses, you can check one of our many computer labs around the United States. Each Microsoft SQL Server course we offer provides the training a person will need to understand and use the program.

Available Microsoft SQL Server Training Courses:



Certstaffix® Class Reviews

Student Average:
4.73 out of 5 from 12 students

4.96 out of 5

Dave Zubal is an excellent teacher.


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

5.00 out of 5


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

4.96 out of 5


- attended our Microsoft SQL Server 2012/14/16 Reporting Services (SSRS) class

4.17 out of 5


- attended our Microsoft SQL Server 2012/14/16 Reporting Services (SSRS) class

4.39 out of 5


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

5.00 out of 5


- attended our Querying Microsoft SQL Server 2012/14 (70-461) class

5.00 out of 5


- attended our Querying Microsoft SQL Server 2012/14 (70-461) class

4.76 out of 5


- attended our Querying Microsoft SQL Server 2012/14 (70-461) class

4.47 out of 5


- attended our Querying Microsoft SQL Server 2012/14 (70-461) class

5.00 out of 5


- attended our Microsoft SQL Server 2012/14 Reporting Services (SSRS) class

5.00 out of 5


- attended our Microsoft SQL Server 2012/14 Reporting Services (SSRS) class

4.06 out of 5


- attended our Microsoft SQL Server 2012/14 Reporting Services (SSRS) class



Please contact us if we do not yet have any reviews, you would like more reviews or you wish to submit a review.


View all Microsoft SQL Server training reviews



Other Courses Available in Topeka, KS:


Microsoft SQL Server Classes in Kansas:

SQL Server training Overland Park, KS       SQL Server training Topeka, KS       SQL Server training Wichita, KS