SQL Server 2016 Certification Path
Microsoft has made few changes to its Certification path for the new version of SQL Server i.e. SQL Server 2016.
And with this post I’m trying to collate and put all exams and certifications in concise and clear manner. Would be happy to accept any comments, changes and suggestions !!!
–> The MCSA i.e. “Microsoft Certified Solution Associate” level now contains the new “MCSA: SQL Server 2016” certification, and this replaces the older “MCSA: SQL Server 2012/14” one.
–> And the top MCSE i.e. “Microsoft Certified Solutions Expert” level now contains the new “MCSE: Data Management and Analytics” certification. This also replaces the following 2 existing certifications (but retains the underlying exams to earn this MCSE level, which I’ve explained below):
– MCSE: Data Platform
– MCSE: Business Intelligence
–> Here are the details of exams at both the levels.
Level 1. “MCSA: SQL Server 2016”: Now to earn this level you need to give either of the following certifications:
1. MCSA: SQL 2016 Database Development certification
– Exam [70-761], Querying Data with Transact-SQL [check details here]
– Exam [70-762], Developing SQL Databases
2. MCSA: SQL 2016 Database Administration certification
– Exam [70-764], Administering a SQL Database Infrastructure
– Exam [70-765], Provisioning SQL Databases
3. MCSA: SQL 2016 Business Intelligence Development certification
– Exam [70-767], Implementing an SQL Data Warehouse
– Exam [70-768], Developing SQL Data Models
Level 2. “MCSE: Data Management and Analytics”: Now to earn this level you need to first get an MCSA on either of the above 3 certifications, or “MCSA: Data Science”. Then need to pass anyone of the below exam:
– Exam [70-473], Designing and Implementing Cloud Data Platform Solutions
– Exam [70-475], Designing and Implementing Big Data Analytics Solutions
– Exam [70-464], Developing Microsoft SQL Server Databases
– Exam [70-465], Designing Database Solutions for Microsoft SQL Server
– Exam [70-466], Implementing Data Models and Reports with Microsoft SQL Server
– Exam [70-467], Designing Business Intelligence Solutions with Microsoft SQL Server
Leave a Reply to Manoj Pandey Cancel reply
Current Visitors
StatCounter …since April 2012
Leisure blog: Creek & Trails
- An error has occurred; the feed is probably down. Try again later.
SQL with Manoj 
So we only pass 2 exam instead of 3 in SQL Server 2012, to have the MCSA?
Good day,
I currently have MCSA 2008 and would like to achieve the MCSE for SQL. How do I go about this?
Is it possible to attend 70-764 and 70-765, without 70-761 and 70-762?
yes, you can 🙂
If I have completed these 2 below exams, then can I get the MCSA: SQL Server 2016 certification?
MCSA: SQL 2016 Database Administration certification
– Exam [70-764], Administering a SQL Database Infrastructure
– Exam [70-765], Provisioning SQL Databases
Could you please explain little bit on this.
Yes, that’s why they are grouped together in set of 2 🙂
Hi.. My name is Shivendra kumar. I am a mca student(2018 batch). If i complete 70-761 and 70-762 exam than i get SQL 2016 Database Development certification ???? For any fresher ,It is helpfull to get a job in sql because currently i have tried so many times but no one ready to take a fresher in database or sql profile.. Every one needs experience min 1-2 years.
yes, you will get MCSA certification in “SQL Server Database Development” after passing these 2 exams !
I haven’t give any exam before.
I want to apply for 70-761.
Would it be helpful for me being MCP to get job or it is worth only when I get MCSA certificate?
Hello Manoj .. Nice to see a very descriptive SQL certification path Thank you . I doing certification for very first time is this path will still be appropriate to me or do I need to do any pre-requisite ?
Thanks you liked this. You can go with the path as mentioned above, no pre-req.
Thank you 🙂
I have cleared my 4 Exams and awarded as MCSE -Data management and Analytics.
(70-461,462,463,464) Now I want to get same certification in sql server 2016 . Which / How many papers i suppose to clear. Please answer.
after taking the certification of 70-761 only will I get a job as I am fresher an IT GRADUATE
bonjour , je m’appelle fabiola; svp quelquun pourrait m’envoyer un site ou un lien qui me permettrait de faire une formation en ligne afin d’obtenir la certification mcsa sql 2016
Bonjour Fabiola, vous pouvez visiter les liens mentionnés ci-dessus avec les codes d’examen pour plus de détails sur le cours et plus d’informations.
Hello Mr. Pandey,
Thank you for this article.
Early 2017 I started my path for the MCSA: SQL Server 2012/14 by passing exam 700-461. I would like to know if you recommend I start over on the path for SQL Server 2016 and “forget” my 70-461 exam or should I stick to my 2012/2014 path and study for 700-462?
I have tried reaching Microsoft for official advice from them but haven’t been able to find the right contact.
Thanks in advance for your opinion on this.
Best regards,
Pedro
Hi icarus82, I would suggest you to move to 2016 specific certifications i.e. 70-761/762 exams.
Thank you
Hi Manoj – I hope I’m not asking you to repeat yourself.
I’m an Oracle DBA and a backup to our SQL Server Admin. I want an MCSE certification with a focus on database admin and design.
I see that the 70-765 and 70-765 exams with earn a SQL Server 2016 DBA MCSA. Do I have to take those two classes formally in order to take the exams?
Can I learn from the Training Guides and practice exams and then take the 70-765 and 70-764 exams?
After that, do I only need 70-464 OR 70-465 to get an MCSE?
Thanks so much for your time.
Donna
hi manoj,
i already achieved 70-764 and 765 certification, do i only need 70-464 or 465 to get MCSE ?