MCSA

Microsoft Certified Solutions Associate (MCSA) certification validates mastery of the core technical skills required to build a sustainable career. Earning an MCSA certification while in school enables students to develop a professional competency in a classroom setting. Pursuing an MCSA certification is recommended for those with access to hands-on practical experience and a foundation of core knowledge about information technology. An MCSA certification is required in order to become an MCSE.
Source from Official Microsoft certification web site  
The skills for your professional career
Prove your mastery of the primary set of Windows Server 2012 skills required to reduce IT costs and deliver more business value.
Step
Title
Optional training
Required exam
1
Installing and Configuring Windows Server 2012
410
410
2
Administering Windows Server 2012
411
411
3
Configuring Advanced Windows Server 2012 Services
412
412
Step
Exam title
Optional training
Required exam
1
Windows Server 2008 Active Directory, Configuring
6425
6426
640
2
Windows Server 2008 Network Infrastructure, Configuring
6421
642
3
Windows Server 2008, Server Administrator
6433
646
Step
Exam title
Optional training
Required exam
1
Configuring Windows 8.1
687
687
2
Supporting Windows 8.1
688
688
Step
Exam title
Optional training
Required exam
1
Windows 7, Configuring
6292
680
2
Windows 7, Enterprise Desktop Support Technician
6293
685
Step
Exam title
Optional training
Required exam
1
Querying Microsoft SQL Server 2012
461
461
2
Administering Microsoft SQL Server 2012 Databases
462
462
3
Implementing a Data Warehouse with Microsoft SQL Server 2012
463
463
Step
Exam title
Optional training
Required exam
1
Querying Microsoft SQL Server 2012
461
461
2
Administering Microsoft SQL Server 2012 Databases
462
462
3
Implementing a Data Warehouse with Microsoft SQL Server 2012
463
463
Step
Exam title
Optional training
Required exam
1
Managing Office 365 Identities and Requirements
346
346
2
Enabling Office 365 Services
346
347