SQL SERVER – Microsoft Certification – SQL Server 2012

Microsoft has recently introduced 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.

The mapping of the certifications is here.

Microsoft Certifications Microsoft 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 pyramid which quickly explains the hierarchy of the indexes.

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

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.

Read about Certifications over here.

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

32 thoughts on “SQL SERVER – Microsoft Certification – SQL Server 2012

  1. Dear Sir,

    Can you please help me out to know from where I need to give exam and which books i need to study for certifications. Need to know all about certifications books,cost of the exam and from where I need to give this exam.


  2. I have a question. If a pperson does obtain the MCSA and already has 3+ years experience in working with SQL….what are his/her salary projections? All estimated values of course – South Florida Resident


  3. thanks a lot for your valuable info.want to take $61,462,463 exams for MCSA certification.can you pls provide the info of how to give an attempt.Thanks in Advance


  4. Dear Pinal,

    I am a DBA and your blog is helping me immensely in my work whenever i am stuck. Now I want to do sql server 2012 certification. I am finding it difficult to understand the microsoft certification details. Can you please throw light on which certification is required to become Certified Microsoft Database Administrator.

    Thanks and Regards,


  5. Thank you for the info it is really helpful. Does the Microsoft waive the pre-requisites for the certifications based on the work experience?. My question in particular was If I want write DB Developer (MCSE: Data Platform) certification. Is there any way to waive the MCSA certification related exams.

    Could you please give your suggestion, If I want to write DBA exam later is it helpful to have MS Developer certification now.


  6. Thanks for the valuable information to be shared in a simple and understand manner . i am planning to attempt 70-461 paper , can any one share 70-461 preparation material.


  7. Hello, i am really intersted to take the certification exam which is 70-461, so can you recommend me the book which makes me ready for the exam.


  8. Hi,
    I thank you so much. Your blog is amazing ,and you can’t imagine how much you help me in my work. Most of the solutions of my sql server problems exist in your blog. Thank you very much


  9. Is it possible to take the MCSE without taking MCSA?i work on windows every day i really don’t need a beginners certificate.


  10. Good day people. I currently just joined the I.T industry and now trying to figure out a Microsft certification route for myself. Im now doing the MCSA Server 2012, please advise on what to do next after the MCSA. I just want good certificates which will lead to better job opportunities. Do assist. Thank you.


  11. Pingback: SQL SERVER – Weekly Series – Memory Lane – #027 | SQL Server Journey with SQL Authority

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


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



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


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


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


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


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



  18. 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.. :)


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s