MCSA: SQL 2016 Certification Path

Essentially there are three types of MCSA SQL certifications:

  • SQL 2016 Database Administration
  • SQL 2016 Business Intelligence Development
  • SQL 2016 Database Development

SQL 2016 Database Administration

For this certification you must complete the following exams:

  • 70-764 Administering a SQL Database Infrastructure:

This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

  • 70-765 Provisioning SQL Databases

This exam is intended for architects, senior developers, infrastructure specialists, and development leads. Candidates have a working knowledge of the various cloud service models and service model architectures, data storage options, and data synchronization techniques. Candidates also have a working knowledge of deployment models, upgrading and migrating databases, and applications and services, in addition to integrating Azure applications with external resources.

The average salary for this certification is $68,141.

SQL 2016 Business Intelligence Development

For this certification you must complete the following exams:

  • 70-767 Implementing a SQL Data Warehouse

This exam is intended for extract, transform, and load (ETL) and data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing, in addition to ETL and data warehouse implementation.

  • 70-768 Developing SQL Data Models

This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multidimensional data models, implementing and maintaining OLAP cubes, and implementing tabular data models.

The average starting salary for this certification is $71,114.

SQL Database Development

For this certification you must complete the following exams:

  • 70-761 Querying Data with Transact-SQL

This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.

  • 70-762 Developing SQL Databases

This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.

The average starting salary for this certification is $69,270.