mcse_datamanagementandanalyticsMicrosoft continues to expand out their certification program to better fit the newly emerging “cloud-based” world of IT. As a result, the existing Microsoft Azure exams as well as new exams being published are being integrated into the broad spectrum of Microsoft certifications; such as the MCSE. The MCSE: Data Management and Analytics certification has recently been introduced as part of a new redesign and restructuring of the MCSE certifications. This article explains some of the details around how you can go about earning the new MCSE: Data Management and Analytics certification.

On the path to earning the MCSE: Data Management and Analytics an MCSA certification will first be earned.

The MCSA Foundation

On the path to earning the MCSE: Data Management and Analytics certification an MCSA certification will first be earned. It’s really good to have a milestone along the way, instead of having to take a tone of exams before claiming any single certification title / credential. Additionally, instead of just a single MCSA choice to earn, there are actually multiple tracks to choose from based on your unique combination of expertise and interests.

Here’s the list of the MCSA certification tracks, along with the exams you’ll need to pass to achieve each of them:

As you can see the MCSA foundations mostly require 2 exams to be passed; these are the newer MCSA’s. The older MCSA for SQL Server 2012/2014 requires 3 exams to be passed to earn. All these MCSA’s fill provide a solid foundation of SQL Server in the specific track that you choose.

MCSE: Data Management and Analytics

Once a qualifying MCSA certification (as listed above) has been earned, the next path to the MCSE: Data Management and Analytics certification is to pass only 1 more exam. Also, best of all, you get to choose which exam you would like to take from a list of elective exams.

Here’s the list of elective exams to choose from to build on top of the MCSA foundation when achieving the MCSE: Data Management and Analytics certification:

Even if you choose to focus on SQL Server 2012/2014 or SQL Server 2016 with the MCSA you earned, it’s up to you if you want to mix some Azure / Cloud expertise into  your certification for the MCSE, Or, you can still with SQL Server for your choice elective exam as well.

Once a qualifying MCSA certification (as listed above) is earned, the next path is to pass 1 more exam to earn the full MCSE: Data Management and Analytics certification!

Happy studying!

Updated May 27, 2017: Microsoft announced a renaming of a few of the MCSA certifications and the addition of more elective exams for the MCSE: Data Management and Analytics certification.

Updated Apr 13, 2017: Added info about MCSA Data Science certification.

Posted by Chris Pietschmann

Chris is a Microsoft MVP and has 15+ years of experience building enterprise systems both in the cloud and on-premises. He is also a Microsoft Certified (MCSD) Azure Solutions Architect. He has a passion for technology and sharing what he learns with others to help enable them to learn faster and be more productive.

4 Comments

  1. Hassan Manasfi March 8, 2017 at 6:40 am

    Can 70-764 be substituted for 70-464 as an elective for the MCSE: Data Management and Analytics certification?

    Reply

    1. Exam 70-764 will count towards the MCSA: SQL 2016 Database Administrator certification that is one of the starting tracks on your way to the MCSE. Once you have this MCSA, then you need to take an additional elective exam to earn the MCSE: Data Management and Analytics. This elective could be the 70-464 exam among a few others.

      Reply

  2. Hassan Manasfi March 9, 2017 at 12:01 am

    Thank you Chris for your reply. I might have mis-phrased my question. After earning the MCSA: SQL 2016 BI Development can I take 70-764 instead of 70-464 to earn the MCSE.

    Reply

    1. Hassan Manasfi March 9, 2017 at 1:13 am

      Sorry I meant 70-762. My mistake.

      Reply

Leave a Reply