Home > Certifications, SQL Server 2016 > SQL Server 2016 Certification Path

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

  1. August 15, 2017 at 5:49 pm

    So we only pass 2 exam instead of 3 in SQL Server 2012, to have the MCSA?

  2. January 3, 2018 at 1:52 pm

    Good day,

    I currently have MCSA 2008 and would like to achieve the MCSE for SQL. How do I go about this?

  3. February 22, 2018 at 5:19 pm

    Is it possible to attend 70-764 and 70-765, without 70-761 and 70-762?

  4. Suneel Ratnakar
    March 9, 2018 at 8:25 pm

    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.

    • March 9, 2018 at 8:35 pm

      Yes, that’s why they are grouped together in set of 2 🙂

  5. Shivendra Kumar
    March 21, 2018 at 9:36 am

    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.

    • March 21, 2018 at 10:10 am

      yes, you will get MCSA certification in “SQL Server Database Development” after passing these 2 exams !

  6. Bhaumik
    April 8, 2018 at 10:58 pm

    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?

  7. Ravi
    May 11, 2018 at 6:41 pm

    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 ?

    • May 12, 2018 at 10:02 am

      Thanks you liked this. You can go with the path as mentioned above, no pre-req.

      • Ravi
        May 15, 2018 at 6:32 pm

        Thank you 🙂

  8. Naveen Srivastava
    June 1, 2018 at 3:06 pm

    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.

  9. prashant
    July 3, 2018 at 5:46 pm

    after taking the certification of 70-761 only will I get a job as I am fresher an IT GRADUATE

  10. fabiola
    September 25, 2018 at 4:20 pm

    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

    • September 25, 2018 at 5:41 pm

      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.

  11. icarus82
    October 31, 2018 at 2:04 pm

    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,

    • October 31, 2018 at 3:28 pm

      Hi icarus82, I would suggest you to move to 2016 specific certifications i.e. 70-761/762 exams.

      • pedrodar
        October 31, 2018 at 3:50 pm

        Thank you

  12. Donna Best
    November 26, 2018 at 9:43 pm

    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.


  13. palash
    June 22, 2020 at 1:27 pm

    hi manoj,
    i already achieved 70-764 and 765 certification, do i only need 70-464 or 465 to get MCSE ?

  1. No trackbacks yet.

Leave a Reply to Suneel Ratnakar Cancel 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 )

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: