MCSA    Microsoft Certified Solutions Associate
MCSD    Microsoft Certified Solutions Developer
MCSE    Microsoft Certified Solutions Expert

MCDBA   Microsoft Certified Database Administrator
MCITP   Microsoft Certified IT Professional
MCPD    Microsoft Certified Professional Developer
MCSA    Microsoft Certified Systems Administrator
MCSE    Microsoft Certified Systems Engineer
MCTS    Microsoft Certified Technology Specialist

MOS     Microsoft Office Specialist

MS      Microsoft Specialist

1. Product-aligned Certifications

1.1. MTA

Microsoft Technology Associate

1.2. MCSA

Microsoft Certified Solutions Associate

  • BI Reporting

    • 70-778 Analyzing and Visualizing Data with Power BI

    • 70-779 Analyzing and Visualizing Data with Microsoft Excel

  • Cloud Platform Retired in late 2018

  • Data Engineering with Azure Retired in summer 2019

  • Dynamics 365 Retired in summer 2019

  • Linux on Azure Retired in late 2018

  • Machine Learning Retired in summer 2019

  • Microsoft Dynamics 365 Retired

    • MB2-715 Microsoft Dynamics 365 customer engagement Online Deployment Retired

    • MB2-716 Microsoft Dynamics 365 Customization and Configuration Retired on 2019-12-31

  • Microsoft Dynamics 365 for Operations Retired on 2019-12-31

    • 70-764 Administering a SQL Database Infrastructure

    • 70-765 Provisioning SQL Databases

    • MB6-894 Development, Extensions and Deployment for Microsoft Dynamics 365 for Finance and Operations Retired on 2019-12-31

  • Office 365 Retired in summer 2019

    • 70-346 Managing Office 365 Identities and Requirements Retired on 2019-03-31

    • 70-347 Enabling Office 365 Services Retired on 2019-03-31

  • SQL 2016 BI Development

    • 70-767 Implementing a Data Warehouse using SQL

    • 70-768 Developing SQL Data Models

  • SQL 2016 Database Administration

    • 70-764 Administering a SQL Database Infrastructure

    • 70-765 Provisioning SQL Databases

  • SQL 2016 Database Development

    • 70-761 Querying Data with Transact-SQL

    • 70-762 Developing SQL Databases

  • SQL Server 2012/2014

    • 70-461 Querying Microsoft SQL Server 2012/2014

    • 70-462 Administering Microsoft SQL Server 2012/2014 Databases

    • 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

  • Universal Windows Platform

  • Web Applications

    • 70-480 Programming in HTML5 with JavaScript and CSS3

    • 70-483 Programming in C#

    • 70-486 Developing ASP.NET MVC Web Applications

  • Windows 10 Retired in summer 2019

    • 70-697 Configuring Windows Devices Retired

    • 70-698 Installing and Configuring Windows 10 Retired

  • Windows Server 2012

  • Windows Server 2016

1.3. MCSD

Microsoft Certified Solutions Developer

  • App Builder

    • 70-357 Developing Mobile Apps

    • 70-486 Developing ASP.NET MVC Web Applications

    • 70-487 Developing Microsoft Azure and Web Services

1.4. MCSE

Microsoft Certified Solutions Expert

  • Business Applications Retired on 2019-12-31

    • MB2-716 Microsoft Dynamics 365 Customization and Configuration Retired on 2019-12-31

    • MB2-718 Microsoft Dynamics 365 for Customer Service Retired

    • MB2-719 Microsoft Dynamics 365 for Marketing Retired

    • MB6-895 Financial Management in Microsoft Dynamics 365 for Finance and Operations Retired

    • MB6-896 Distribution and Trade in Microsoft Dynamics 365 for Finance and Operations Retired

    • MB6-897 Microsoft Dynamics 365 for Retail Retired on 2019-12-31

    • MB6-898 Microsoft Dynamics 365 for Talent Retired on 2019-12-31

  • Cloud Platform and Infrastructure Retired in late 2018

  • Core Infrastructure

    • 70-744 Securing Windows Server 2016

    • 70-745 Implementing a Software-Defined Datacenter

    • 70-413 Designing and Implementing a Server Infrastructure

    • 70-414 Implementing an Advanced Server Infrastructure

    • 70-537 Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack Retired on 2019-12-31

  • Data Management and Analytics

    • 70-464 Developing Microsoft SQL Server Databases

    • 70-465 Designing Database Solutions for Microsoft SQL Server

    • 70-466 Implementing Data Models and Reports with Microsoft SQL Server

    • 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server

    • 70-762 Developing SQL Databases

    • 70-767 Implementing a Data Warehouse using SQL

    • 70-768 Developing SQL Data Models

    • 70-777 Implementing Microsoft Azure Cosmos DB Solutions

  • Mobility Retired in summer 2019

    • 70-695 Deploying Windows Desktops and Enterprise Applications Retired

    • 70-703 Administering Microsoft System Center Configuration Manager and Cloud Services Integration Retired on 2019-12-31

  • Productivity

    • 70-345 Designing and Deploying Microsoft Exchange Server 2016

    • 70-339 Managing Microsoft SharePoint Server 2016

    • 70-333 Deploying Enterprise Voice with Skype for Business 2015

    • 70-334 Core Solutions of Microsoft Skype for Business 2015

2. Exams

2.1. Microsoft Windows Server 2012

  • 70-410 Installing and Configuring Windows Server 2012

  • 70-411 Administering Windows Server 2012

  • 70-412 Configuring Advanced Windows Server 2012 Services

  • 70-417 Upgrading Your Skills to MCSA Windows Server 2012

2.2. Microsoft Windows Server 2016

  • 70-740 Installation, Storage, and Compute with Windows Server 2016

  • 70-741 Networking with Windows Server 2016

  • 70-742 Identity with Windows Server 2016

  • 70-743 Upgrading Your Skills to MCSA: Windows Server 2016

  • 70-744 Securing Windows Server 2016

  • 70-745 Implementing a Software-Defined Datacenter

3. Books

Books can be found in the O:\Books\Computers folder.

3.1. Windows Server 2012

  • Microsoft Press - Exam Ref 70-410 - Installing and Configuring Windows Server 2012 R2 [2014]

  • Microsoft Press - Exam Ref 70-411 - Administering Windows Server 2012 R2 [2014]

  • Microsoft Press - Exam Ref 70-412 - Configuring Advanced Windows Server 2012 R2 Services [2014]

  • Microsoft Press - Exam Ref 70-417 - Upgrading Your Skills to MCSA Windows Server 2012 [2012]

  • Microsoft Press - Exam Ref 70-417 - Upgrading Your Skills to MCSA Windows Server 2012 (PrePress) [2012]

  • Pearson Education - Cert Guide - MCSA 70-410 - Installing and Configuring Windows Server 2012 R2 [2015]

  • Pearson Education - Cert Guide - MCSA 70-411 Missing

  • Pearson Education - Cert Guide - MCSA 70-412 Missing

  • Pearson Education - Cert Guide - MCSA 70-417 Missing

  • Sybex - Complete Study Guide - Exam 70-410, 70-411, 70-412, 70-417 - MCSA Windows Server 2012 R2 [2015]

  • Sybex - Study Guide - Exam 70-410 - MCSA Windows Server 2012 R2 Installation and Configuration [2015]

  • Sybex - Study Guide - Exam 70-411 - MCSA Windows Server 2012 R2 Administration [2015]

  • Sybex - Study Guide - Exam 70-412 - MCSA Windows Server 2012 R2 Configuring Advanced Services [2015]

  • Sybex - Study Guide - Exam 70-417 Missing

  • Wiley - Microsoft Official Academic Course - Exam 70-410 - Installing and Configuring Windows Server 2012 [2013]

  • Wiley - Microsoft Official Academic Course - Exam 70-411 - Administering Windows Server 2012 [2013]

  • Wiley - Microsoft Official Academic Course - Exam 70-412 - Configuring Advanced Windows Server 2012 Services [2014]

  • Wiley - Microsoft Official Academic Course - Exam 70-417 Missing

  • Wiley - Microsoft Official Academic Course - Lab Manual - Exam 70-410 - Installing and Configuring Windows Server 2012 [2014]

  • Wiley - Microsoft Official Academic Course - Lab Manual - Exam 70-411 - Administering Windows Server 2012 [2014]

3.2. Windows Server 2016

  • Cengage Learning - Networking - Exam 70-742 - MCSA Guide to Identity with Windows Server 2016 [2018]

  • Microsoft Press - Exam Ref 70-740 - Installation, Storage and Compute with Windows Server 2016 [2017]

  • Microsoft Press - Exam Ref 70-741 - Networking with Windows Server 2016 [2017]

  • Microsoft Press - Exam Ref 70-742 - Identity with Windows Server 2016 [2017]

  • Microsoft Press - Exam Ref 70-743 - Upgrading Your Skills to MCSA - Windows Server 2016 [2017]

  • Microsoft Press - Exam Ref 70-744 - Securing Windows Server 2016 [2017]

  • Microsoft Press - Exam Ref 70-745 - Implementing a Software-Defined Datacenter [2018]

  • Pearson Education - Cert Guide - MCSA 70-740 - Installation, Storage and Compute with Windows Server 2016 [2017] epub

  • Pearson Education - Cert Guide - MCSA 70-741 - Networking with Windows Server 2016 [2017]

  • Pearson Education - Cert Guide - MCSA 70-742 Missing

  • Pearson Education - Cert Guide - MCSA 70-743 Missing

  • Pearson Education - Cert Guide - MCSA 70-744 Missing

  • Pearson Education - Cert Guide - MCSA 70-745 Missing

  • Sybex - Complete Study Guide - Exam 70-740, 70-741, 70-742 - MCSA Windows Server 2016, 2nd Edition [2018]

  • Sybex - Study Guide - Exam 70-740 - MCSA Windows Server 2016 - Installation, Storage, and Compute with Windows Server 2016 [2017]

  • Sybex - Study Guide - Exam 70-741 - MCSA Windows Server 2016 - Networking with Windows Server 2016 [2017] azw3

  • Sybex - Study Guide - Exam 70-742 - MCSA Windows Server 2016 - Identity with Windows Server 2016, 2nd Edition [2018]

  • Sybex - Study Guide - Exam 70-743 - MCSA Windows Server 2016 Missing

  • Sybex - Study Guide - Exam 70-744 - MCSA Windows Server 2016 Missing

  • Sybex - Study Guide - Exam 70-745 - MCSA Windows Server 2016 Missing

4. Online Training

5. New Role-based Certifications

5.1. Fundamentals

  • Microsoft Certified Dynamics 365 Fundamentals

  • Microsoft 365 Certified Fundamentals

  • Microsoft Certified Azure Fundamentals

5.2. Associate

  • Microsoft Certified: Azure Security Engineer Associate

  • Microsoft Certified: Azure Administrator Associate

  • Microsoft Certified: Azure AI Engineer Associate

  • Microsoft Certified: Azure Data Engineer Associate

  • Microsoft Certified: Azure Data Scientist Associate

  • Microsoft Certified: Azure Developer Associate

  • Microsoft Certified: Dynamics 365 for Marketing Functional Consultant Associate

  • Microsoft Certified: Dynamics 365 for Field Service Functional Consultant Associate

  • Microsoft Certified: Dynamics 365 for Finance and Operations, Financials Functional Consultant Associate

  • Microsoft Certified: Dynamics 365 for Finance and Operations, Manufacturing Functional Consultant Associate

  • Microsoft Certified: Dynamics 365 for Finance and Operations, Supply Chain Management Functional Consultant Associate

  • Microsoft Certified: Dynamics 365 for Customer Service Functional Consultant Associate

  • Microsoft Certified: Dynamics 365 for Sales Functional Consultant Associate

  • Microsoft 365 Certified: Messaging Administrator Associate

  • Microsoft 365 Certified: Modern Desktop Administrator Associate

  • Microsoft 365 Certified: Security Administrator Associate

  • Microsoft 365 Certified: Teamwork Administrator Associate

5.3. Expert

  • Microsoft 365 Certified: Enterprise Administrator Expert

  • Microsoft Certified: Azure DevOps Engineer Expert

  • Microsoft Certified: Azure Solutions Architect Expert