MCSA SQL 2016 Changes

MagmadragoonMagmadragoon Member Posts: 172 ■■■□□□□□□□
It seems that Microsoft has changed the format of the MCSA for the SQL path for 2016. The SQL 2016 MCSA is now broken into three parts MCSA: SQL 2016 Database Development, MCSA: SQL 2016 Database Administration, and MCSA: SQL 2016 Business Intelligence Development. Each MCSA now only requires two test instead of the three it took to receive the MCSA: SQL Server 2012/2014 certification.

MCSA: SQL Server 2012/2014
1. Querying Microsoft SQL Server 2012/2014 070-461
2. Administering Microsoft SQL Server 2012/2014 Databases 070-462
3. Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 070-463

MCSA: SQL 2016 Database Development
1. Querying Data with Transact-SQL
2. Developing SQL Databases

MCSA: SQL 2016 Database Administration
1. Administering a SQL Database Infrastructure
2. Provisioning SQL Databases

MCSA: SQL 2016 Business Intelligence Development
1. Implementing a SQL Data Warehouse
2. Developing SQL Data Models

More information can be found at


  • SlowhandSlowhand MCSE: Cloud Platform and Infrastructure, MCSA: Windows Server 2003/2012/2016, CCNA Routing & Switchi Bay Area, CaliforniaMod Posts: 5,161 Mod
    That is excellent information. This thread has been made sticky. icon_thumright.gif

    Free Microsoft Training: Microsoft Learn
    Free PowerShell Resources: Top PowerShell Blogs
    Free DevOps/Azure Resources: Visual Studio Dev Essentials

    Let it never be said that I didn't do the very least I could do.
  • DatabaseHeadDatabaseHead Teradata Assc 16, Querying Microsoft SQL Server 2012/2014, CSM Member Posts: 2,632 ■■■■■■■■■□
    Almost want to hold out for the last one, that's the one I am the most interested in. Thanks for the post OP.
  • nachodbanachodba USMember Posts: 201 ■■■□□□□□□□
    I might abandon my in progress MCSE Data Platform and go for the MCSA database development.
    2020 Goals
    work-life balance
  • OctalDumpOctalDump Member Posts: 1,722
    Is the Database Development track just the MCSD renamed? I think there was an MCSD for SQL a while back, before it went all Azure and Universal Platform.

    It does seem to make a lot sense to divide them up, because this is often what happens in practice - someone designing models, someone provisioning servers and administering, and the BI thing is a whole other area.
    2017 Goals - Something Cisco, Something Linux, Agile PM
  • DatabaseHeadDatabaseHead Teradata Assc 16, Querying Microsoft SQL Server 2012/2014, CSM Member Posts: 2,632 ■■■■■■■■■□
    @Octal look no further than here. 65% of my day is building SSAS models and mining structures another 10% is SSIS packages (You just don't have to build as many once you plan correctly) and the other part is 20%-25% writing SQL for whatever, building jobs ad hoc queries etc. With that said administration is not my thing nor do I want it to be so this new track gives me the ability to avoid 462. Just wanted reinforce your thoughts.
  • adam9870adam9870 Member Posts: 53 ■■□□□□□□□□
    What is end date of 70-462 exam?
  • nachodbanachodba USMember Posts: 201 ■■■□□□□□□□
    The SQL 2012/14 exams won't go away within the next year. The upcoming retirements are available here -
    2020 Goals
    work-life balance
  • adam9870adam9870 Member Posts: 53 ■■□□□□□□□□
    Thanks for you answer.
    I plan try 70-462 in September.
  • RHONEDOGRHONEDOG Member Posts: 24 ■□□□□□□□□□
    I've been patiently waiting to see if they are going to do a 2016 MCSE track, but so far, nothing published.
  • arkiboysarkiboys Registered Users Posts: 2 ■□□□□□□□□□
    Regarding: MCSA: SQL 2016 Database Development
    1. I can not find exam materials to study. The only one is provided is for 70-461 which is for 12/14
    Any suggestions where to get study books/materia for this exam pls?
  • nachodbanachodba USMember Posts: 201 ■■■□□□□□□□
    Murach's SQL Server 2016 for Developers is a great book to use.
    2020 Goals
    work-life balance
Sign In or Register to comment.