Home > Blogs > SQL Server Exams Get Content Refresh

SQL Server Exams Get Content Refresh

By  Feb 17, 2016

Topics: Browse by Cert, MCSE, Microsoft, MCSA

Interesting item showed up on the Born to Learn blog from Larry Kaye at Microsoft Learning on February 16, 2016, to inform readers that most of the SQL Sever exams will now cover content from both SQL Server 2012 and SQL Server 2014. This should extend the lifetime of current SQL Server certs for a while, as new version is expected to follow in the wake of Windows Server 2016, scheduled for public release sometime in the second half of 2016.


The blog post cited is entitled "Feb 2016 Certification Update -- SQL Server 2014" and it makes specific mention of Microsoft cert exams 70-461 through 70-467. The following table indicates which exams have had changes to coverage and objectives applied, and where to look for more information on those changes:

Microsoft SQL Exams Content Refresh
Exam ID Title Change information
70-461 Querying Microsoft SQL Server 2012 No changes made
70-462 Administering Microsoft SQL Server 2012 Databases Now includes content for SQL Server 2014 and 2012. Changedoc
70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012 Now includes content for SQL Server 2014 and 2012. Changedoc
70-464 Developing Microsoft SQL Server Databases Now includes content for SQL Server 2014 and 2012. Changedoc
70-465 Designing Database Solutions for Microsoft SQL Server Now includes content for SQL Server 2014 and 2012. Changedoc
70-466 Implementing Data Models and Reports with Microsoft SQL Server Now includes content for SQL Server 2014 and 2012. Changedoc
70-467 Designing Business Intelligence Solutions with Microsoft SQL Server Now includes content for SQL Server 2014 and 2012. Changedoc

According the blog post, the MCSA is also being rebranded to MCSA:SQL Server 2012/2014. But I just checked the MCSA home page and it shows no such change. Ditto for the MCSA:SQL Server page itself, though it does point to the SQL Server Certification FAQ to explain updates to SQL-related certifications. Methinks MS still has some work to do to get all these pieces tied up, and pointing in the same direction. The changedocs linked in the preceding table should be your guide to individual exam changes, though, and you'll find the information you need there to help you get ready to pass the new versions of these exams.

All of these changes come by way of getting ready for a new round of exams at the end of 2016 or sometime in 2017. MS is already referencing SQL Server 2016 as a market leader on its SQL Server home page. I'm expecting a whole new set of MS certifications to be introduced for those platforms at around the same time as well.