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

Microsoft SQL Server Certification Training — Standard Path

ONLC Training Centers, a Microsoft Gold Partner, has the Microsoft authorized classes that will help you prepare for SQL Server MCSA and SQL Server MCSE certification.

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

New to IT and/or databases? Start by learning the fundamentals of technology with Microsoft Technology Associate (MTA) certifications.

Below are the standard training paths for SQL Server 2012/2014 certification.


Microsoft Certified Solutions Associate (MCSA) SQL Server 2012 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.

NOTE: No MCSA: SQL Server 2014 credential will be offered by Microsoft. MCSA: SQL Server 2012 is the prerequisite for both the MCSE Data Platform and MCSE Business Intelligence certifications. You can earn MCSA SQL Server 2012 by passing three exams.


MCSA: SQL Server Certification Path

(Click course title for outline & dates)
STEP 1   STEP 2   STEP 3  
Microsoft Certified Solutions Associate | MCSA

Course 20461: Querying SQL Server

  Course 20462: Administering SQL Server Databases   Choose one Elective listed below

Exam 461
Exam 462
1 Elective Exam
SQL Server 2012


Effective September 15, 2014, Microsoft introduced options for the MCSA SQL Server 2012 third exam. Select one (1) from the following list:

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

Course 20411: Administering Windows Server 2012 | Exam 411

Course 20412: Configuring Advanced Windows Server 2012 Services | Exam 412

Course 20483: Programming in C# | Exam 483


CONTINUE WITH MCSE (Data Platform OR Business Intelligence)...

Microsoft Certified Solutions Engineer (MCSE) certification demonstrates your indispensable expertise to build enterprise-scale data solutions on-premises or in the cloud. There are two SQL Server 2012 MCSE credentials: Data Platform, Business Intelligence. For either track you will need to first earn the MCSA SQL Server 2012 certification (above) then pass the two exams for the designated MCSE track.

MCSE: Data Platform Certification Path
MCSE Data Platform certification validates your ability to administer high-availability solutions on the SQL Server 2012 platform. Candidates who earn MCSE certification for SQL Server 2012 will be required to recertify every three years.

(Click course title for outline & dates)

MCSA SQL Server Certification

  Course 20464: Developing SQL Server Databases
  Course 20465: Designing Database Solutions for SQL Server  
Microsoft Certified Solutions Expert | MCSE
(See MCSA above)
Exam 464
Exam 465
Data Platform


MCSE: Business Intelligence Certification Path
MCSE Business Intelligence certification is your gateway to the skills and techniques to design, build and deploy solutions that deliver more data to more people across the organization. Candidates who earn MCSE certification for SQL Server 2012 will be required to recertify every three years.

(Click course title for outline & dates)

MCSA SQL Server Certification

  Course 20466: Implementing Data Models and Reports with SQL Server


Course 20467: Designing Business Intelligence Solutions with SQL Server

Microsoft Certified Solutions Expert | MCSE
(See MCSA table above)
Exam 466
Exam 467
Business Intelligence



Click the title of the classes marked with the green flag () to see specific locations and dates of Ready to Run classes.  Click the title of the classes marked with the yellow flag () to see specific locations and dates of Early Notice classes.

Class Information
Click Title for Dates & Outlines Days Fee
SQL Server Querying
Skills Update
55144: SQL Server 2014 Performance Tuning and Optimization 3 $1795    
Development & Design
Business Information, Reporting and Data Warehousing
55005: Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012 Express and SQL 2012 2 $1195    
55119: SQL Server 2012 Reporting Services 3 $1795

SQL Server 2008 & 2005
ONLC also provides authorized training for earlier versions of Microsoft SQL Server. See SQL Server 2008 and SQL Server 2005.

Top of page Top of page



SQL Server 2014 Certification News

Per Microsoft, SQL Server 2014 certifications will only be offered at the MCSE level. The new product features focus on performance tuning and high availability and are best suited for the MCSE level. As a result, the following updates are planned:

  • The MCSA: SQL Server 2012 credential and associated exams (461/462/463) will remain in market without any alterations. No MCSA: SQL Server 2014 credential will be offered.

  • As of April 2014, the MCSE: Data Platform (464/465) and MCSE: Business Intelligence (466/467) exams were appropriately updated with SQL Server 2014 topics. The exam numbers remained the same.

Retirement of SQL Server 2008 & 2005 Exams
Microsoft certification exams for SQL Server 2005 were retired on June 30, 2011. The upgrade exams from version 2005 to version 2008 were retired in 2012. Some SQL Server 2008 certifications have already been retired with the remaining SQL Server 2008 exams retiring July 31, 2016.

MCSE Recertification Requirement
Candidates who earn any of the MCSE certifications for SQL Server will be required to recertify every three years.



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 hands-on training at ONLC! The 15-day Pass can be used for most public Microsoft 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 accepts Microsoft Software Assurance Training Vouchers (SATV) on Microsoft-approved courses. Note, Microsoft has removed Azure from SATV use and the entire program is being discontinued in June 2020. Learn more and view approved classes.


ONLC Training Centers is a Microsoft Gold Learning PartnerAuthorized Microsoft Classes at ONLC Training Centers
ONLC is a Microsoft Learning Partner. Instructor-led Microsoft technical classes use authorized materials and are taught by a Microsoft Certified Trainer (MCT).



Top of page Top of page


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