Last Updated on July 28, 2023
This certification has been retired. For currently available options, please refer to the Browse Certifications and Exams page. Any certifications you earn prior to their retirement dates will continue to appear on your transcript in the Certification Dashboard.
This certification validates that you have the skills needed to run a highly efficient and modern data center, identity management, systems management, virtualization, storage, and networking.
To earn the MCSE: Data Management & Analytics certification, complete the following requirements:
- Earn one prerequisite certification:
- Prerequisite Option 1: MCSA: SQL Server 2012/2014
- Prerequisite Option 2: MCSA: SQL 2016 Database Development
- Prerequisite Option 3: MCSA: SQL 2016 Database Administration
- Prerequisite Option 4: MCSA: SQL 2016 BI Development
- Prerequisite Option 5: MCSA: BI Reporting
- And pass one of the 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
Job role: Database Administrator
Prerequisites: 5 certifications
Required exams: 70-46470-46570-466
Important: See detailsGo to Certification Dashboard
Certification details
Complete one prerequisite
PREREQUISITE OPTION 1
MCSA: SQL Server 2012/2014OR
PREREQUISITE OPTION 2
MCSA: SQL 2016 Database DevelopmentOR
PREREQUISITE OPTION 3
MCSA: SQL 2016 Database AdministrationOR
PREREQUISITE OPTION 4
MCSA: SQL 2016 BI DevelopmentOR
PREREQUISITE OPTION 5
MCSA: BI Reporting
Take three exams
CERTIFICATION EXAM
Developing Microsoft SQL Server DatabasesAND
CERTIFICATION EXAM
Designing Database Solutions for Microsoft SQL ServerAND
CERTIFICATION EXAM
Implementing Data Models and Reports with Microsoft SQL Server
Earn the certification
ASSOCIATE CERTIFICATION
MCSE: Data Management and Analytics
Skills measured
- none
Two ways to prepare
Online – FreeInstructor-led – Paid
Learning paths to gain the skills needed to become certified
Certification prerequisites
To become a MCSE: Data Management and Analytics, you must earn at least one of the following: MCSA: SQL Server 2012/2014, MCSA: SQL 2016 Database Development, MCSA: SQL 2016 Database Administration, MCSA: SQL 2016 BI Development, MCSA: BI Reporting certification.
- MCSA: SQL Server 2012/2014Option 1: Prerequisite certificationThis certification demonstrates your skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments.
- MCSA: SQL 2016 Database DevelopmentOption 2: Prerequisite certificationThis certification demonstrates your skills as a database professional, for both on-premises and cloud-based databases.
- MCSA: SQL 2016 Database AdministrationOption 3: Prerequisite certificationThis certification demonstrates your skills with database installation, maintenance, configuration, and provisioning tasks.
- MCSA: SQL 2016 BI DevelopmentOption 4: Prerequisite certificationThis 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.
- MCSA: BI ReportingOption 5: Prerequisite certificationThis certification demonstrates your expertise in analyzing data with both Power BI and Excel.
Certification exams
- Exam 70-464: Developing Microsoft SQL Server DatabasesLanguages: EnglishChinese (Simplified)FrenchGermanJapanesePortuguese (Brazil)Retirement date: 01/31/2021**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.Official practice test for Developing Microsoft SQL Server DatabasesAll objectives of the exam are covered in depth so you’ll be ready for any question on the exam.Save
- Exam 70-465: Designing Database Solutions for Microsoft SQL ServerLanguages: EnglishChinese (Simplified)FrenchGermanJapanesePortuguese (Brazil)Retirement date: 01/31/2021**This exam is intended for database professionals who design and build database solutions in the organization. They are responsible for the creation of plans and designs for database structure, storage, objects, and servers. They create the plan for the environment in which the database solution runs.Save
- Exam 70-466: Implementing Data Models and Reports with Microsoft SQL ServerLanguages: EnglishChinese (Simplified)FrenchGermanJapanesePortuguese (Brazil)Retirement date: 01/31/2021**This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.Save
Certification resources
Training and certification guide
Explore all certifications in a concise training and certifications guide.
Certification poster
Check out an overview of fundamentals, role-based and specialty certifications.
Exam Replay
See two great offers to help boost your odds of success.
Support for certifications
Get help through Microsoft Certification support forums. A forum moderator will respond in one business day, Monday-Friday.
Certification dashboard
Review and manage your scheduled appointments, certificates, and transcripts.
Share your certification badges
Celebrate your accomplishment with your network. Claim your Microsoft Certification badge, and add it to LinkedIn, your résumé, and more.
* Pricing does not reflect any promotional offers or reduced pricing for Microsoft Imagine Academy program members, Microsoft Certified Trainers, and Microsoft Partner Network program members. Pricing is subject to change without notice. Pricing does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam.
** Complete this exam before the retirement date to ensure it is applied toward your certification. After the retirement date, please refer to the related certification for exam requirements.