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

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

Microsoft Certifications, SQL Certifications, SQL Server
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

  • Imran Mohammed
    April 29, 2012 10:34 am

    Definitely helpful.

    Thanks for sharing information.

    ~ IM.

  • Nirav Gajjar
    May 1, 2012 6:09 pm

    very helpful

  • Thanks.. it is very helpful.

  • Srinivas Rayala
    July 16, 2012 3:03 am

    very useful for certification works .Thank you for your information.

  • Arpita Poojary
    August 4, 2012 10:15 pm

    Thanks a lot..This is really useful

  • Arpita Poojary
    August 5, 2012 9:42 am

    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.

  • 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

  • I want to take exams 70-461, 70-462 and 70-463 what are the study material as to pass these exams?

  • Is there any book which you will recommend for below exams:
    457,458, 459

  • 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

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

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

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

  • Hi if one is having 70-461 paper ?

  • I have 1 yrs of xperience in SSRS can i Direcly give exam of MCSE Business Intelligence

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

  • 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

  • Hi Thank you very much

  • smilingcoast
    April 1, 2013 12:05 am

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

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


Leave a ReplyCancel reply

Exit mobile version