SQL SERVER – Microsoft Certification – SQL Server 2012

Microsoft has recently introduced a few changes in how the certification works. I have tried to simplify the same thing over here. The new certification line is called Microsoft cloud-built Certifications. Let us read more about Microsoft Certification.

The mapping of the certifications is here.

Microsoft CertificationsMicrosoft Colud-build Certifications
MCM (Master)MCSM (Solutions Master)
MCITP (IT Professional)
MCPD (Professional Developer)
MCSE (Solutions Expert)
MCSD (Solutions Developer)
MCTS (Technology Specialist)MCSA (Solutions Associate)

Here is the image of a pyramid which quickly explains the hierarchy of the indexes.

SQL SERVER - Microsoft Certification - SQL Server 2012 cert1

Solarwinds

Microsoft Certified Solutions Associate (MCSA)

If you want to get MCSA you will need to pass following three exams.

  • Exam 70-461: Querying Microsoft SQL Server 2012
  • Exam 70-462: Administering Microsoft SQL Server 2012 Databases
  • Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

Microsoft Certified Solutions Expert (MCSE)

There two separate certifications are introduced in MCSE. One should have MCSA certification before they can attempt for MCSE.

1) MCSE: Data Platform

One has to pass following three exams besides having MCSA certification to get MCSE: Data Platform

  • Exam 70-464: Developing Microsoft SQL Server 2012 Databases
  • Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012

2) MCSE: Business Intelligence

One has to pass following three exams besides having MCSA certification to get MCSE: Data Platform

  • Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
  • Exam 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

SQL SERVER - Microsoft Certification - SQL Server 2012 cert2

Microsoft Certified Solutions Master (MCSM)

When I am writing this there is not much changes in this program, but it is quite possible this program is changed based on when you are reading it. You are encouraged to read and validated further details about this program on its official page over here.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, ,
Previous Post
SQLAuthority News – Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments – Part 1
Next Post
SQL SERVER – A Brief Introduction to expressor Studio 3.6

Related Posts

32 Comments. Leave new

  • Rajneesh Rai
    May 6, 2013 7:07 pm

    Hi Pinal !
    there is a spelling mistake in “Microsoft Colud-build Certifications”.. i think it should be “Cloud” .

    Reply
  • Pinal,

    So once the MCSE gets completed, how can be the MCSM be achieved? Do we have any training centers in Hyderabad or Bangalore who can train people, or would you like suggesting any online web based course for getting trained?

    I have checked at the Microsoft website on the MCSM requirements, and it stated that the coaching has to be taken at Redmond with a 10 week class schedule, costing more than $18000. So I was just wondering we have any facility in India to achieve this certification.

    Thanks,
    Vinay

    Reply
  • Ibrahim Khalilulla
    October 17, 2013 12:16 am

    Thanks for information,i am planning to attempt 70-461 paper , can any one share 70-461 preparation material.

    Reply
  • Hello Pinal,

    Your blogs have helped me alot, Thank you for it. I have MCTS 2008 administration and maintenance certification. In order to be MCSE: Data Platform,
    what other certifications should i require. Should i do still do 70-464, as MCTS already cover lot of 70-464 area. Thank you.

    Reply
  • Hi Pinal,

    I am plannig to take all three exams required for MCSA withing next quarter. I am not an expert though I have some experience with SQL Server 2008. Could you suggest reference material for MCSA preparation?
    Please tell me which books should I buy? Is Microsoft Press’ Self Paced Training Kit enough for it or do I need to look into other books as well?

    Thanks in Advance.
    Prasanna Wagh

    Reply
  • Hi Pinal,
    I am planning to take 461/462/263 MCSA SQL Server 2012 before July 2014. Please can you guide me by suggesting some studymaterials/books to prepare for this?

    Thanks in Advance.
    SP

    Reply
    • Hi, Do you get any reply from Pinal about your certificaiton question (Is it possible to give only 70-463 , 70-466 & 70-467 CERTIFICATION exam if yes then please advice the traning tool kits for the same for purchase.).. Please reply.

      Reply
  • HI Pinal Sir,
    Is it possible to give only 70-463 , 70-466 & 70-467 Certification exam if yes then please advice the traning tool kits for the same for purchase.

    Thanks
    Pch

    Reply
  • Bhakthaprahlada
    December 30, 2014 3:18 pm

    Hi Pinal,
    I want to know complete info of MCSA . So could you please throw the complete info, then we will get good idea.
    Like Exam pattern and how to crack? etc.
    Hope I may get replay.. :)

    Reply
  • This post is very helpful & really I am glade see this post. You have provided good information by this post. Thanks again. I have seen few more article in Koenig Solutions & udemy blog, it was also good

    Reply

Leave a Reply

Menu