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)
32 Comments. Leave new
Definitely helpful.
Thanks for sharing information.
~ IM.
very helpful
Thanks.. it is very helpful.
very useful for certification works .Thank you for your information.
Thanks a lot..This is really useful
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,
Jagdish
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.
Thanks
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
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.