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

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

  3. 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 🙂

  4. 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?

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

  7. February 22, 2018 at 5:19 pm

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

  8. 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?

  9. August 15, 2017 at 5:49 pm

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

  1. No trackbacks yet.

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

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

%d bloggers like this: