Microsoft is best known for its Windows operating systems and Office software. But the company has a much broader product portfolio that includes online services (Bing, MSN, advertising), gaming (Xbox 360), hardware (tablets, PCs, keyboards and mice) and more. The company also has a sizable certification program that turns out qualified administrators and technicians to support its system and application products.
Achieving IT certifications through the Microsoft Certification Program shows a person’s competence in a specific IT role, and it can result in all kinds of work-related and personal benefits. For example, studies show that IT certifications increase the chances of landing a job (or getting a promotion), and over 80 percent of hiring managers report IT certifications are medium to high priority in hiring decisions.
Currently, the Microsoft Certification Program is divided into seven main categories:
Certifications within the Microsoft Certification Program include the following credentials:
After you pass your first qualifying Microsoft certification exam, you are deemed a Microsoft Certified Professional (MCP). MCP status provides access to a benefits and exams dashboard, with certificates and transcripts, downloadable certification logos, promotional offers and lots more. You also get the MCP designation on your Microsoft transcript. It’s important to understand that only the MCSA, MCSD and MCSE qualify as MCP certifications. Neither MTA nor MOS certifications qualify for MCP status, and none of those exams are prerequisites for MCSA, MCSE or MCSD certifications.
In addition to the certifications outlined above, Microsoft offers its MCT: Microsoft Certified Trainer and MCE: Microsoft Certified Educator credentials to those interested in teaching others about Microsoft technologies and products.
Microsoft recently released a new set of role-based certifications focused on Azure and Microsoft 365 developers, administrators, and solution architects.
The Microsoft Cloud certification track includes MTA and MCSA credentials. Within the MTA program, there is one relevant certification: Cloud Fundamentals. To earn the MTA: Cloud Fundamentals credentials, candidates must pass a single exam that validates knowledge and skills using basic Microsoft cloud services. Candidates should have experience using firewalls, network ports, Office 365, network topologies and devices, and Microsoft Intune.
The MCSA Cloud track includes BI Reporting, SQL 2016 BI Development certs, Windows Server 2012, and Windows Server 2016 credentials. The Windows Server certifications require three exams each while BI Reporting and SQL 2016 BI Development require only two exams.
The Microsoft Mobility certification track includes MTA, MCSA and MCSE certifications. The MTA program has just one relevant certification – MTA: Mobility and Device Fundamentals. —The MTA: Mobility and Device Fundamentals certification is earned by passing a single exam that attests to a candidate’s knowledge of mobility and Windows devices. Candidates should possess practical experience with Active Directory, Windows devices, Windows-based networking, network topologies and ports, firewalls, and antimalware products.
MCSA: Windows 10 is the only MCSA Mobility track credential available. Earning the MCSA: Windows 10 requires passing two exams.
The remaining credential in this track is the MCSE: Mobility. This requires earning the MCSA: Windows 10 plus passing one more exam, from a list of two possibilities that deal with Windows desktops and enterprise applications, or administering System Center Configuration Manager and Cloud Services Integration.
Both the MCSA: Mobility and MCSE: Mobility credentials retire on March 31, 2019. If earned prior to the retirement date, the credentials will continue to show as “active” certifications on your transcript. The MCSA: Windows 10 will be replaced by a new role-based credential – the Microsoft Certified: Modern Desktop Administrator Associate. Two exams are required to earn this credential. At present, no announcement has been made regarding whether the Modern Desktop Administrator Associate credential will become a prereq to the MCSE: Mobility. There’s a lot of ongoing ferment in MS certification programs right now. We expect 2019 to see major changes in MS’s cert programs and offerings. Next year’s update should be a big one!
Microsoft’s Data certification track includes the MTA, MCSA and MCSE. (To see the Data track, go to the Microsoft Certification page and click Data from the Category dropdown menu.) The MTA program requires one exam on database fundamentals. There are six certifications in the MCSA Data track– namely, Data Engineering with Azure, Machine Learning, SQL 2016 BI Development, SQL 2016 Database Administration, SQL 2016 Database Development, and SQL Server 2012/2014. All certs require two exams except for SQL Server 2012/2014, which requires three. The Data Engineering with Azure and Machine Learning certifications both retire on June 30, 2019.
The MCSE Data category includes a single certification, the MCSE: Data Management and Analytics.
The prerequisite MCSAs that qualify for MCSE: Data Management and Analytics are SQL Server 2012/2014, SQL 2016 Database Administration, Database Development, BI Development, Machine Learning, BI Reporting, or Data Engineering with Azure. One additional exam from a list of 13 possibilities must be passed to earn this credential. Topics covered include cloud data platform solutions, big data analytics solutions, developing or designing SQL Server databases, implementing data models and reports, designing business intelligence solutions, implementing a data warehouse, developing SQL data models, analyzing big data with Microsoft R, cloud data science with Azure machine learning, data engineering with Azure HDInsight, and implementing with Azure Cosmos DB solutions.
Certifications in the Microsoft Productivity category vary widely, from proving competency in using a single Office product to managing Office 365 services and user login credentials. This track is also fairly large; it includes an MCSA and MCSE certification as well as Microsoft Office Specialist (MOS) offerings.
The MCSA Productivity track includes a single certification – the MCSA: Office 365. Two exams are required to obtain the credential. This credential is targeted to retire on Mach 30, 2019. The MCSE: Productivity certification requires candidates possess either the MCSA Office 365, Windows Server 2012, or Windows Server 2016 credential as a prerequisite. Candidates must also pass one additional exam, from a list of eight possibilities. Topics covered include Exchange Server, SharePoint Server and Skype for Business, for multiple versions of these platforms.
Microsoft offers a MOS Office 2016 certification for each Office application (Word, Excel, PowerPoint, Outlook, Access, and Outlook). Office 2013 credentials are still available, but unless you have a specific reason for achieving them, focus on Office 2016.
The MOS 2016 Expert certification identifies individuals with advanced Office skills and requires candidates to pass two exams. The MOS 2016 Master certification is the pinnacle of the MOS Certification Program and requires successful completion of six exams.
The Microsoft Business Applications certifications include MCSA and MCSE certifications. There are two MCSA options: MCSA: Microsoft Dynamics 365 and MCSA: Microsoft Dynamics 365 for Operations. Each requires passing two exams. The plain vanilla Dynamics 365 certification draws from a list of two exams, both of which are needed to meet its requirements. One exam covers Dynamics 365 customer engagement online deployment, while the other covers Dynamics 365 customization and configuration. The MCSA: Microsoft Dynamics 365 credential retires on April 30, 2019.
The Dynamics 365 for Operations draws from a list of three exams, one of which is required while candidates may choose the topic for the second exam. Topics covered include administering a Microsoft SQL database infrastructure, provisioning SQL databases, and development, extensions and deployment for Microsoft Dynamics 365 for Finance and Operations (required).
The MSCE: Business Applications credential is the sole MCSE item for this certification track. It takes either of the Microsoft Dynamics MCSAs covered in the preceding paragraph as its prerequisite, then requires candidates to pass another exam drawn from a list of eight possibilities. Topics covered include Microsoft Dynamics 365 for Sales, customer service, marketing, distribution and trade, trade, financial management (finance and operations), retail, talent, and field service.
Microsoft offers a single credential focused on core infrastructure – MCSE: Core Infrastructure. The MCSE: Core Infrastructure certification validates a candidate’s knowledge and skills related to data centers, virtualization, systems management, storage, networking and identity management. The credential requires either the MCSA: Windows Server 2016 or MCSA: Windows Server 2012 as a prerequisite. In addition to the MCSA, candidates must pass a single exam from seven topics. Exam topics include designing and implementing Cloud Data Platform solutions, designing and implementing Big Data Analytics solutions, securing Windows Server 2016, implementing software-defined datacenters, designing and implementing server infrastructures, implementing advanced server infrastructures, and configuring and operating a hybrid cloud with Microsoft Azure Stack.
Folks who teach others about Microsoft technologies and products should consider (and are often required to have) the Microsoft Certified Trainer (MCT) certification. The MCT can be obtained by submitting an application to Microsoft that proves that you hold a current Microsoft certification, one year of instruction experience (supporting reference required), plus verifiable instructional skills in the form of an acceptable instructor certification (such as CompTIA CTT+, Microsoft Certified Trainer Instructional Skills Certification (MCT-ISC) or IAMCT Approved Technical Trainer).
To renew, credential holders must possess at least one current Microsoft credential, meet the minimum instruction requirements of teaching at least one class, and maintain a Metrics that Matter quality score of at least seven. (Check the MCT website for a list of qualifying certifications and instructor certifications.)
As an MCT, you have access to the MCP benefits and exams dashboard, prep kits, the MCT community, Microsoft Online Labs and much more.
The Microsoft Certified Educator (MCE) credential is aimed at educators in academia, such as colleges, universities and training facilities. To become an MCE, you must demonstrate technology literacy by passing at least one exam.
The literacy competency is mapped to the UNESCO ITC Competency Framework for Teachers, Technology Literacy and includes education policy, curriculum and assessment, pedagogy, ICT/technology tools, organization and administration, and professional development.
Microsoft offers training to candidates directly, both in the classroom and online. The company’s Microsoft Virtual Academy (MVA) is a great place to start poking around: it offers a huge range of free training courses, many of them at least relevant to various certification topics if not directly focused on such topics.
There’s also a huge aftermarket for Microsoft training, self-study and certification preparation. Pearson operates Microsoft Press on Microsoft’s behalf, where you can find self-study guides for all the popular Microsoft cert exams (and many of the not-so-popular exams as well). Pearson’s IT Certification imprint (online at PearsonITCertification.com) also offers study guides, exam crams (a series I invented), practice tests, video training materials and much more for Microsoft certification candidates. Wiley/Sybex and Osborne/McGraw-Hill also offer certification focused imprints, book series and generally provide good coverage of major cert topics as well, also including most popular Microsoft certifications and related exams. Pearson’s mindhub online store also offers “official” practice tests approved by Microsoft.
There’s a wealth of excellent material available to help candidates prepare. Look to online and peer reviews, study groups and rating sites to separate the wheat from the chaff.