MCSA SQL 2016 Changes

[Magmadragoon]

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 https://www.microsoft.com/en-us/lear...ification.aspx

[Slowhand]

That is excellent information. This thread has been made sticky.

[DatabaseHead]

Almost want to hold out for the last one, that's the one I am the most interested in. Thanks for the post OP.

[nachodba]

I might abandon my in progress MCSE Data Platform and go for the MCSA database development.

[OctalDump]

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.

[DatabaseHead]

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

[adam9870]

What is end date of 70-462 exam?

[nachodba]

The SQL 2012/14 exams won't go away within the next year. The upcoming retirements are available here -
https://www.microsoft.com/en-us/lear...ion-exams.aspx

[adam9870]

Thanks for you answer.
I plan try 70-462 in September.

[RHONEDOG]

I've been patiently waiting to see if they are going to do a 2016 MCSE track, but so far, nothing published.

[arkiboys]

Hello,
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?
Thanksl

[nachodba]

Murach's SQL Server 2016 for Developers is a great book to use.

https://www.amazon.com/Murachs-SQL-S.../dp/1890774960