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
Hi Pinal !
there is a spelling mistake in “Microsoft Colud-build Certifications”.. i think it should be “Cloud” .
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
Thanks for information,i am planning to attempt 70-461 paper , can any one share 70-461 preparation material.
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.
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
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
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.
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
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.. :)
It’s already available at official site
https://www.microsoft.com/en-us/learning/mcsa-sql-certification.aspx
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