+ Reply to Thread
Results 1 to 12 of 12
  1. Senior Member
    Join Date
    Jul 2013
    Location
    Philadelphia, PA
    Posts
    158

    Certifications
    Comptia Project+, VCA-DCV, Comptia A+, CCENT
    #1

    Default MCSA SQL 2016 Changes

    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
    Reply With Quote Quote  

  2. SS -->
  3. Questionably Benevolent Moderator Slowhand's Avatar
    Join Date
    Oct 2005
    Location
    Bay Area, CA
    Posts
    5,073
    Blog Entries
    1

    Certifications
    A+, Linux+, Server+, Security+, MCSA 2003, MCSA 2008, MCSA 2012, CCNA(expired), ITIL Foundation v3 (2011), VCP5-DCV, VCA-Cloud, VCA-DCV, VCA-WM
    #2
    That is excellent information. This thread has been made sticky.

    -------------------------------------------------------
    ITHumidor.net - "Futuaris nisi irrisus ridebis"
    -------------------------------------------------------

    Free Microsoft Training: Microsoft Virtual Academy
    Free PowerShell Resources: Top 50 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.
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #3
    Almost want to hold out for the last one, that's the one I am the most interested in. Thanks for the post OP.
    Reply With Quote Quote  

  5. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #4
    I might abandon my in progress MCSE Data Platform and go for the MCSA database development.
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

  6. Woohoo! It's over 1000!
    Join Date
    Aug 2015
    Location
    Australia
    Posts
    1,680

    Certifications
    RHCSA, Linux+, ACSA, ACTC, ACSP, MCSA:7, MCTS, ITIL F, Prince2 Pract, AgilePM Practioner, VCP-DCV, Storage+, CCNA R+S, CCNA Sec, Security+, CEH, CASP
    #5
    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.
    Reply With Quote Quote  

  7. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #6
    @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.
    Reply With Quote Quote  

  8. Junior Member
    Join Date
    Jul 2016
    Posts
    26

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462
    #7
    What is end date of 70-462 exam?
    Reply With Quote Quote  

  9. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #8
    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
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

  10. Junior Member
    Join Date
    Jul 2016
    Posts
    26

    Certifications
    Microsoft: 70-620, 70-642, 70-640, 70-462
    #9
    Thanks for you answer.
    I plan try 70-462 in September.
    Reply With Quote Quote  

  11. Junior Member RHONEDOG's Avatar
    Join Date
    Oct 2016
    Posts
    24

    Certifications
    A+,MCP (70-461 & 70-462)
    #10
    I've been patiently waiting to see if they are going to do a 2016 MCSE track, but so far, nothing published.
    Reply With Quote Quote  

  12. Junior Member Registered Member
    Join Date
    Nov 2016
    Posts
    2
    #11

    Default exam material for 2016

    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
    Reply With Quote Quote  

  13. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #12
    Murach's SQL Server 2016 for Developers is a great book to use.

    https://www.amazon.com/Murachs-SQL-S.../dp/1890774960
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks