Certifications & exams > SQL Server certifications > MCSA: SQL 2016
The skills for your professional career
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.
| Step | Title | Optional training | Required exam | Certification earned |
|---|---|---|---|---|
| 1 | Querying Data with Transact-SQL | Take course 761 | Take exam 761 |  |
| 2 | Developing SQL Databases | Take course 762 | Take 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.
| Step | Title | Optional training | Required exam | Certification earned |
|---|---|---|---|---|
| 1 | Administering a SQL Database Infrastructure | Take course 764 | Take exam 764 |  |
| 2 | Provisioning SQL Databases | Take course 765 | Take 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.
| Step | Title | Optional training | Required exam | Certification earned |
|---|---|---|---|---|
| 1 | Implementing a SQL Data Warehouse | Take course 767 | Take exam 767 |  |
| 2 | Developing SQL Data Models | Take course 768 | Take 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.
Step Title Optional training Required exam Certification earned 1 Developing SQL Databases Take course 762 Take exam 762 - 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.
Step Title Optional training Required exam Certification earned 1 Provisioning SQL Databases Take course 765 Take exam 765 - 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.
Step Title Optional training Required exam Certification earned 1 Developing SQL Data Models Take course 768 Take exam 768
