MCSA: Office 365

MCSA: SQL 2016

Solutions Associate

The skills for your professional career

Note: The requirements for this certification changed as of September 26, 2016. Browse the replacement certifications here.

This page is being retained for reference purposes only. The information on this page, including statements about upgrade and/or substitution options, is not being updated and may no longer be accurate.

Exams formerly associated with this certification have been included as components of the replacement certification where appropriate.

Demonstrate your essential skills as a database professional, for both on-premises and cloud-based databases. (New to IT? Learn about MTA certification for new entrants.)

Earning an MCSA: SQL 2016 Database Development certification validates your skills in building and implementing databases across organizations, and will qualify you for a position as a database developer.

StepTitleOptional trainingRequired examCertification earned
1Querying Data with Transact-SQLTake course 761Take exam 761MCSA: SQL 2016 Database Development
2Developing SQL DatabasesTake course 762Take exam 762

Earning an MCSA: SQL 2016 Database Administration certification validates your skills with database installation, maintenance, configuration, and provisioning tasks, and will qualify you for a position as a database administrator or infrastructure specialist.

StepTitleOptional trainingRequired examCertification earned
1Administering a SQL Database InfrastructureTake course 764Take exam 764MCSA: SQL 2016 Database Administration
2Provisioning SQL DatabasesTake course 765Take exam 765

Earning an MCSA: SQL 2016 Business Intelligence Development certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes. This certification will qualify you for a position as a BI developer.

StepTitleOptional trainingRequired examCertification earned
1Implementing a SQL Data WarehouseTake course 767Take exam 767MCSA: SQL 2016 Business Intelligence Development
2Developing SQL Data ModelsTake course 768Take exam 768

Next

Earn your MCSE: Data Management and Analytics certification.

How to upgrade to the MCSA: SQL 2016 Database Development certification

You can upgrade the MCSA: SQL Server 2012/2014 certification to the MCSA: SQL 2016 Database Development certification through a single exam.

StepTitleOptional trainingRequired examCertification earned
1Developing SQL DatabasesTake course 762Take exam 762MCSA: SQL 2016 Database Development
How to upgrade to the MCSA: SQL 2016 Database Administration certification

You can upgrade the MCSA: SQL Server 2012/2014 certification to the MCSA: SQL 2016 Database Administration certification through a single exam.

StepTitleOptional trainingRequired examCertification earned
1Provisioning SQL DatabasesTake course 765Take exam 765MCSA: SQL 2016 Database Administration
How to upgrade to the MCSA: SQL 2016 Business Intelligence Development certification

You can upgrade the MCSA: SQL Server 2012/2014 certification to the MCSA: SQL 2016 Business Intelligence Development certification through a single exam.

StepTitleOptional trainingRequired examCertification earned
1Developing SQL Data ModelsTake course 768Take exam 768MCSA: SQL 2016 Business Intelligence Development

Exam Replay

Boost your exam-day confidence.