Certifications

MCSE: Data Management and Analytics

Certification details

Warning

This certification has been retired. For currently available options, please refer to the Browse Certifications and Exams page.

 

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:

Skills measured

  • none

Job role: Database Administrator

Prerequisites: 5 certifications

Required exams: 70-464 70-465 70-466

Go to Learn Profile

Two ways to prepare

Items in this collection

  • Learning paths or modules are not yet available for this certification

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/2014

    This certification demonstrates your skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments.

  • MCSA: SQL 2016 Database Development

    This certification demonstrates your skills as a database professional, for both on-premises and cloud-based databases.

  • MCSA: SQL 2016 Database Administration

    This certification demonstrates your skills with database installation, maintenance, configuration, and provisioning tasks.

  • MCSA: SQL 2016 BI 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.

  • MCSA: BI Reporting

    This certification demonstrates your expertise in analyzing data with both Power BI and Excel.

Certification exams

  • 70-464: Developing Microsoft SQL Server Databases

    Languages: en zh-cn fr de ja pt-br

    Retirement date: **

    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.

    Price based on the country or region in which the exam is proctored.

    for Developing Microsoft SQL Server Databases

    All objectives of the exam are covered in depth so you'll be ready for any question on the exam.

  • 70-465: Designing Database Solutions for Microsoft SQL Server

    Languages: en zh-cn fr de ja pt-br

    Retirement date: **

    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.

    Price based on the country or region in which the exam is proctored.

    for Designing Database Solutions for Microsoft SQL Server

    All objectives of the exam are covered in depth so you'll be ready for any question on the exam.

  • 70-466: Implementing Data Models and Reports with Microsoft SQL Server

    Languages: en zh-cn fr de ja pt-br

    Retirement date: **

    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.

    Price based on the country or region in which the exam is proctored.

    for Implementing Data Models and Reports with Microsoft SQL Server

    All objectives of the exam are covered in depth so you'll be ready for any question on the exam.

Certification resources

Support for Credentials

Get help through Microsoft Credentials support forums. A forum moderator will respond in one business day, Monday-Friday.

Choose your Microsoft Credential

Microsoft Applied Skills or Microsoft Certifications? Choose the path that fits your career goals, desired skillset, and schedule.

Certification poster

Check out an overview of fundamentals, role-based and specialty certifications.

Exam Replay

Boost your odds of success with this great offer.

Your certifications

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 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.