SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.

SQL Server 2012: New Certifications

As a follow-up to my post SQL Server “Denali”: New Certifications, the seven exams for SQL Server 2012 are:

  • Querying Microsoft SQL Server (70-461) [BI and DBA]
  • Administering a Microsoft SQL Server 2012 Database (70-462) [DBA]
  • Building Data Warehouses with Microsoft SQL Server 2012 (70-463) [BI]
  • Developing a Microsoft SQL Server 2012 Database (70-464) [DBA]
  • Designing Database Solutions for SQL Server 2012 (70-465) [DBA]
  • Implementing Data Models and Reports with Microsoft SQL Server 2012 (70-466) [BI]
  • Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Platform (70-467) [BI]

I have indicated which role (“Business Intelligence” [BI] or “Database Professionals” [DBA]) each exam fits into.  The unanswered question I have is how will this work: Will you be awarded a MCTS for each test, and then a MCITP if you pass the four exams for each role?

New this year is that SQL Server 2012 Professional-level certifications will require recertification every three years.  For more info, check out Sneak Peek: SQL Server 2012 learning products in development.


Posted by Johnson-215153 on 8 November 2011

Hi James,

Just wanted to confirm that, all these Certifications already listed?


Posted by Anonymous on 8 November 2011

Pingback from  Dew Drop – November 8, 2011 | Alvin Ashcraft's Morning Dew

Posted by Iulian on 10 November 2011

Hi James, is there an upgrade path?

Thank you,


Posted by James Serra on 11 November 2011

Hi lulian,

The upgrade path has not been determined yet.  I'll update this post when it is announced.

Posted by asheesh pandey on 12 January 2012

Hi James,

Thanks for your information....

Posted by Dugi on 27 February 2012

Thanks for the info!

Posted by Nader Sharara-390450 on 6 March 2012

Hi James, Microsoft site says that exam (70-463): Building Data Warehouses with Microsoft SQL Server 2012 is required to achieve Data Platform [DBA] professional certificate beside the other four exams


what do you think ??

Leave a Comment

Please register or log in to leave a comment.