Microsoft 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:
- 70-473: Designing and Implementing Cloud Data Platform Solutions
- 70-475: Designing and Implementing Big Data Analytics Solutions
- 70-464: Developing Microsoft SQL Server Databases
- 70-465: Designing Database Solutions for Microsoft SQL Server
- 70-466: Implementing Data Models and Reports with Microsoft SQL Server
- 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server
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!