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 of SQL Server

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 4 tracks to choose from based on your unique combination of expertise and interests.

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

  • MCSA: SQL Server 2012/2014
    • 70-461: Querying Microsoft SQL Server 2012/2014
    • 70-462: Administering Microsoft SQL Server 2012/2014 Databases
    • 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
  • MCSA: SQL 2016 Database Administration
    • 70-764: Administering a SQL Database infrastructure
    • 70-765: Provisioning SQL Databases
  • MCSA: SQL 2016 Database Development
    • 70-761: Querying Data with Transact-SQL
    • 70-762: Developing SQL Databases
  • MCSA: SQL 2016 Business Intelligence Development
    • 70-767: Implementing a SQL Data Warehouse
    • 70-768: Developing SQL Data Models

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!

4 thoughts on “MCSE: Data Management and Analytics Certification

    • 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.

      Like

  1. 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.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s