Welcome to ONLC Training Centers
Welcome to ONLC Training Centers
Microsoft SQL Server certification classes at ONLC Training Centers

Microsoft SQL Server Certification Training Classes


 

You can prepare for Microsoft SQL Server certification as a MCSA and MCSE at ONLC Training Centers—a Microsoft Gold Learning Partner.

Click for ONLC's FREE Microsoft Exam Voucher offer!
click for details

SQL Server is the foundation of Microsoft’s comprehensive data platform. Earning a SQL Server certification demonstrates your essential skills as a database professional, for both on-premises and cloud-based databases.

Exams you pass and certifications you earn become part of your official transcript, which you can allow potential employers to access directly.

A Microsoft Certification is an industry standard which is recognized worldwide and which can help open doors to potential job opportunities.

Attend live, hands-on, instructor-led classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from the convenience of your home/office PC via our Remote Classroom Instruction (RCI™) technology.

Many SQL Server titles are also available in the MOC On-Demand format—Microsoft's official self-study option. Both training formats are available from ONLC.

 


 

SQL Server Certifications

MCSA SQL Server 2016 Database Development

 

MCSA SQL Server 2016 Database Development

Earning MCSA: SQL 2016 Database Development certification validates your skills in building and implementing databases across organizations, and will qualify you for a position as a database developer.

To achieve this certification you must pass the designated exams. You can help prepare for the exams by attending the courses listed.

(Click course title for outline & dates)

STEP 1

20761: Querying Data with Transact-SQL | Exam 70-761

STEP 2

20762: Developing SQL Databases | Exam 70-762

 

Successfully passing the above exams will earn an individual MCSA SQL Server 2016 Database Development certification.

(Individuals who currently hold an MCSA: SQL Server 2012/2014 certification can upgrade to this 2016 certification by passing exam 70-762.)

 

MCSA SQL Server 2016 Database Administration

MCSA SQL Server 2016 Database Administration

Earning MCSA: SQL 2016 Database Administration certification validates your skills with database installation, maintenance, configuration, and provisioning tasks, and will qualify you for a position as a database administrator or infrastructure specialist.

To achieve this certification you must pass the designated exams. You can help prepare for the exams by attending the courses listed.

(Click course title for outline & dates)

STEP 1

20764: Administering a SQL Database Infrastructure | Exam 70-764

STEP 2

20765: Provisioning SQL Databases | Exam 70-765

 

Successfully passing the above exams will earn an individual MCSA SQL Server 2016 Database Administration certification.

(If you currently hold a MCSA: SQL Server 2012/2014 certification you can upgrade to this 2016 certification by passing exam 70-765.)

 

 

MCSA SQL Server 2016 Database Development

MCSA SQL Server 2016 Business Intelligence Development

Earning an MCSA: SQL 2016 Business Intelligence Development certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes. This certification will qualify you for a position as a BI developer.

To achieve this certification you must pass the designated exams. You can help prepare for the exams by attending the courses listed.

(Click course title for outline & dates)

STEP 1

20767: Implementing a SQL Data Warehouse | Exam 70-767

STEP 2

20768: Developing SQL Data Models | Exam 70-768

Successfully passing the above exams will earn an individual MCSA SQL Server 2016 Database Administration certification.

(Individuals who currently hold an MCSA: SQL Server 2012/2014 certification can upgrade to this 2016 certification by passing exam 70-768.)

 


 

Microsoft Certified Solutions Expert MCSE Data Mgmt & Analytics

MCSE: Data Management & Analytics (SQL Server 2016)

The Microsoft Certified Solutions Expert (MCSE): Data Management & Analytics certification validates that you have demonstrated your broad skill sets in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data—both on-premises and in cloud environments.

Earning an MCSE: Data Management and Analytics certification qualifies you for such jobs as database analyst, database designer, and business intelligence analyst.

To achieve this certification you must pass the designated exams. You can help prepare for the exams by attending the courses listed.

(Click course title for outline & dates)

STEP 1

Earn one (1) of the following Microsoft Certified Solutions Associate (MCSA) certifications -- details for each above:

MCSA: SQL 2016 Database Administration

MCSA: SQL 2016 Database Development

MCSA: SQL 2016 Business Intelligence Development

MCSA: SQL Server 2012/2014

STEP 2

Pass one (1) of the following elective exams:

20464: Developing Microsoft SQL Server Databases | Exam 70-464

20465: Designing Database Solutions for Microsoft SQL Server | Exam 70-465

20466: Implementing Data Models and Reports with Microsoft SQL Server | Exam 70-466

20467: Designing Business Intelligence Solutions with Microsoft SQL Server | Exam 70-467

20473: Designing and Implementing Cloud Data Platform Solutions | Exam 70-473
This course may not yet be available

20475: Designing and Implementing Big Data Analytics Solutions | Exam 70-475
This course may not yet be available

 

Successfully earning a MCSA SQL Server 2016 or 2012/2014 plus passing one of the above exams will earn an individual MCSE Data Mgmt & Analytics.

This MCSE certification can be re-earned every calendar year by passing an additional elective exam.

 


 

MCSA / MCSE SQL Server 2012 / 2014 Certifications

 

MCSA: SQL Server 2012 / 2014

The Microsoft Certified Solutions Associate (MCSA) SQL Server 2012 / 2014 certification validates that you have acquired the essential skills and knowledge to develop, run, and maintain the next wave of advanced database and information solutions.

Earning an MCSA: SQL Server certification could qualify you for a position as a database developer or database analyst.

This is the prerequisite for both the MCSE Data Platform and MCSE Business Intelligence certifications below.

To achieve this certification you must pass the designated exams. You can help prepare for the exams by attending the courses listed.

(Click course title for outline & dates)

STEP 1

20461: Querying SQL Server | Exam 70-461

STEP 2

20462: Administering SQL Server Databases | Exam 70-462

STEP 3

20463: Implementing a Data Warehouse with SQL Server | Exam 70-463*

You may substitute any of the following for exam 70-463:

MCSE: Data Platform (2012/2014)

MCSE SQL Server Database Platform

MCSE Data Platform certification validates your ability to administer high-availability solutions on the SQL Server 2012 platform.

To achieve this certification you must pass the designated exams. You can help prepare for the exams by attending the courses listed.

(Click course title for outline & dates)

STEP 1

20461: Querying SQL Server | Exam 70-461

STEP 2

20462: Administering SQL Server Databases | Exam 70-462

STEP 3

20463: Implementing a Data Warehouse with SQL Server | Exam 70-463

NOTE: After passing the exams for steps 1–3, you'll earn an MCSA: SQL Server 2012/2014 certification.

STEP 4

20464: Developing Microsoft SQL Server 2014 Databases | Exam 70-464

STEP 5

20465: Designing Database Solutions for SQL Server | Exam 70-465

 

This MCSE certification requires you to show continued ability to perform in your chosen solution area by completing a recertification exam every three years.

MCSE: Business Intelligence (2012/2014)

MCSE SQL Server Business Intelligence

Prove that you have the skills and techniques needed to design, build, and deploy SQL Server business intelligence (BI) solutions that deliver more data to more people across the organization. Earning an MCSE: Business Intelligence certification will qualify you for a position as a BI and reporting engineer.

To achieve this certification you must pass the designated exams. You can help prepare for the exams by attending the courses listed.

(Click course title for outline & dates)

STEP 1

20461: Querying SQL Server | Exam 70-461

STEP 2

20462: Administering SQL Server Databases | Exam 70-462

STEP 3

20463: Implementing a Data Warehouse with SQL Server | Exam 70-463

NOTE: After passing the exams for steps 1–3, you'll earn an MCSA: SQL Server 2012/2014 certification.

STEP 4

20466: Implementing Data Models and Reports with Microsoft SQL Server | Exam 70-466

STEP 5

20467: Designing Business Intelligence Solutions with Microsoft SQL Server | Exam 70-467

 

This MCSE certification requires you to show continued ability to perform in your chosen solution area by completing a recertification exam every three years

 


 

 

SQL SERVER CLASSES

ONLC offers many SQL Server classes and versions in addition to those associated with the above SQL Server certifications.

To view all of the SQL Server classes at ONLC click the button...

 

See All SQL Server Classes

 

 


 

NEWS & OFFERS

 

Save on technical training with our 15-Day Saver plan.

Save on Technical Training
For just $6,995 an individual can take up to fifteen (15) technical days of live, instructor-led hands-on training at ONLC! The 15-day Pass can be used for many public technical classes. Find out more

 

Save on technical training for your entire company with our CEA Tech Saver

Save on Company-wide Technical Training
Our Corporate Education Account (CEA) Tech Saver can give an entire company a set discount on technical classes for a full year. The greater your purchase the higher your discount. Find out more

 

 

Microsoft Software Assurance vouchers accepted hereMicrosoft Software Assurance Vouchers Accepted Here
ONLC gladly accepts Microsoft Software Assurance (SA) Vouchers on approved classes. These vouchers can be redeemed for any official Microsoft instructor-led training course that was created for the IT professional or developer audience. Learn more and view approved classes.

 

 

MOC On-Demand: Microsoft's Official Self-study option

MOC On-Demand
Many Microsoft technical level courses are offered as MOC On-Demand—Microsoft's self-study format. MOC On-Demand is most appropriate for seasoned IT professionals. For details about MOC On-Demand and ONLC's optional value-adds see MOC On-Demand.

 

 

Online Proctored Exam


Online Proctored Exams

Technical-level Microsoft (MCP) and Microsoft Technology Associate (MTA) exams are available as Online Proctored (OP) so you can take an exam in the comfort of your home or office. The OP exam delivery system has very specific technical, system, environment, and testing protocol requirements. Learn more at Online Proctored Exams.

 

Top of page Top of page

 


Questions?

To learn more about ONLC's classes or in the event of questions contact our Education Advisors at:

1.800.288.8221

ONLC TRAINING CENTERS
800-288-8221
www.onlc.com