下面普及一下MCSM的基础知识。
一、认证体系
SQL Server认证体系划分为4个层级：
1. 入门级别： Microsoft 技术专员
MTA：Database Fundamentals
2. 专员级别：
MCSA：SQL Server 2012
3. 专家级别：
MCSE：数据平台
MCSE：商业智能
4. 大师级别：
MCSM：数据平台
二、每个层级的培训科目
1. MTA
Course 364: Database Fundamentals
2. MCSA
Course 10774: Querying Microsoft SQL Server 2012
Course 10775: Administering Microsoft SQL Server 2012 Databases
Course 10777: Implementing a Data Warehouse with Microsoft SQL Server 2012
3A. MCSE:数据平台
Course 10776: Developing Microsoft SQL Server 2012 Databases
Course 20465: Designing Database Solutions for Microsoft SQL Server 2012
3B. MCSE:商业智能
Course 10778: Implementing Data Models and Reports with Microsoft SQL Server 2012
Course 20467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
4. MCSM:数据平台
没有培训课程。依靠自己的工作经验积累相关的知识。
三、每个层级的考试科目
1. MTA
Exam 364: Database Fundamentals
2. MCSA
Exam 461: Querying Microsoft SQL Server 2012
Exam 462: Administering Microsoft SQL Server 2012 Databases
Exam 463: Implementing a Data Warehouse with Microsoft SQL Server 2012
3A. MCSE:数据平台
先决条件：MCSA: SQL Server 2012
Exam 464: Developing Microsoft SQL Server 2012 Databases
Exam 465: Designing Database Solutions for Microsoft SQL Server 2012
3B. MCSE:商业智能
先决条件：MCSA: SQL Server 2012
Exam 466: Implementing Data Models and Reports with Microsoft SQL Server 2012
Exam 467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
4. MCSM:数据平台
Exam 986: MCSM: Data Platform Knowledge
Exam 987: MCSM: Data Platform Lab
