How Can I Become Certified in Microsoft SQL Server?
Earning a Microsoft SQL Server certification is a great way to advance your career and generate new opportunites.
SQL Server remains the foundation of most enterprise data-centric applications on the Microsoft platform. Whether you
you are developing for an Azure cloud-based application or are the database administrator for an on-premises installation, you can build and
prove your skills with a Microsoft SQL Server certification.
Role-based Certification Opportunity
Level:
Associate
Job Role:
Database Administrator
The Azure Database Administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on Microsoft Azure data services and Microsoft SQL Server. The Azure Database Administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.
Prerequisites
- No prerequisites for this certification
Step 1 Take These Courses
Step 2 Take This Exam
- Exam DP-300: Administering Relational Databases on Microsoft Azure (beta)
Step 3 Earn This Certification
- Microsoft Certified: Azure Database Administrator Associate
Traditional MCSA/MCSE Certification Options
The certifications below will continue to be available through January 31, 2021.
This certification demonstrates your skills with database installation, maintenance, configuration, and provisioning tasks.
Prerequisites
- No prerequisites for this certification
Step 1 Take These Courses
Step 2 Take These Exams
- Exam 70-764: Administering a SQL Database Infrastructure
- Exam 70-765: Provisioning SQL Databases
Step 3 Earn This Certification
- MCSA: SQL 2016 Database Administration
This certification demonstrates your skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments.
Prerequisites
- No prerequisites for this certification
Step 1 Take These Courses
Step 2 Take These Exams
- Exam 70-461: Querying Microsoft SQL Server 2012/2014
- Exam 70-462: Administering Microsoft SQL Server 2012/2014 Databases
- Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
Step 3 Earn This Certification
- MCSA: SQL Server 2012/2014
This certification demonstrates your skills as a database professional, for both on-premises and cloud-based databases.
Prerequisites
- No prerequisites for this certification
Step 1 Take These Courses
Step 2 Take These Exams
- Exam 70-761: Querying Data with Transact-SQL
- Exam 70-762: Developing SQL Databases
Step 3 Earn This Certification
- MCSA: SQL 2016 Database Development
This 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.
Prerequisites
- No prerequisites for this certification
Step 1 Take These Courses
Step 2 Take These Exams
- Exam 70-767: Implementing a Data Warehouse using SQL
- Exam 70-768: Developing SQL Data Models
Step 3 Earn These Certifications
- MCSA: SQL 2016 BI Development
Demonstrate your broad skill sets in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data - both on-premises and in cloud environments.
Prerequisites
- To earn the MCSE: Data Management and Analytics certification, first complete a relevant MCSA certification (see above)
Step 1 Take relevant preparatory course(s)
Step 2 Pass ONE of the following additional elective exams
- 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
Step 3 Earn These Certifications
- MCSE: Data Management and Analytics