SQL Server

MCSE: Data Management and Analytics

Microsoft Certified Solutions Expert

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.

MCSE Data Management and Analytics

Key technologies

  • SQL Server

What is involved

Earning an MCSE: Data Management and Analytics certification qualifies you for such jobs as database analyst, database designer, and business intelligence analyst.

STEP 1 - SKILLS

Earn your MCSA in SQL Server 2012/2014, or SQL 2016 Database Administration, Database Development, BI Development, Machine Learning, BI Reporting or Data Engineering with Azure.

STEP 2 - EXAMS

Pass 1 required exam. Be sure to explore the exam prep resources.

STEP 3 - CERTIFICATION

Earn your MCSE: Data Management and Analytics certification.

STEP 4 - CONTINUING EDUCATION

Explore other certifications to broaden and advance skills.

Certification Exams and prep resources

MCSA SQL Server 2012-2014MCSA: SQL Server 2012/2014
Demonstrate your essential skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments.

MCSA SQL 2016 Database AdminMCSA: SQL 2016 Database Administration
Demonstrate your essential skills as a database professional for both on-premises and cloud-based databases.

MCSA SQL 2016 Database DevMCSA: SQL 2016 Database Development
Demonstrate your essential skills as a database professional for both on-premises and cloud-based databases.

MCSA SQL 2016 BI DevelopmentMCSA: SQL 2016 BI Development
Demonstrate your essential skills as a database professional for both on-premises and cloud-based databases.

MCSA Machine LearningMCSA: Machine Learning
This certification demonstrates your expertise in operationalizing Microsoft Azure machine learning and Big Data with R Server and SQL R Services.

MCSA BI ReportingMCSA: BI Reporting
This certification demonstrates your expertise in analyzing data with both Power BI and Excel.

MCSA Data Engineering with AzureMCSA: Data Engineering with Azure
This certification demonstrates your expertise in engineering data with HD Insight and Cloud Services.

70-473

Exam 70-473

Designing and Implementing Cloud Data Platform Solutions

This exam is for candidates who are interested in validating their skills in designing and implementing Microsoft data platform solutions. Candidates for this exam will have relevant work experience in on-premises and cloud-based platform solutions.
Candidates should know the features and capabilities of the Microsoft data platform to be able to identify tradeoffs and to make decisions for designing public and hybrid cloud solutions. Candidates who take this exam are expected to be able to define the appropriate infrastructure and platform solutions to meet the required functional, operational, and deployment requirements through the solution lifecycle.

70-475

Exam 70-475/Course 552241 and 552242

Designing and Implementing Big Data Analytics Solutions

This certification exam is targeted towards data management professionals, data architects, data scientists, and data developers who design big data analytics solutions on Microsoft Azure. Candidates for this exam will have relevant work experience in big data analytics solutions.

70-464

Exam 70-464/Course 20464

Developing Microsoft SQL Server 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.

70-465

Exam 70-465/Course 20465

Designing Database Solutions for Microsoft SQL Server

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.

70-466

Exam 70-466/Course 20466

Implementing Data Models and Reports with Microsoft SQL Server

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.

70-467

Exam 70-467/Course 20467

Designing Business Intelligence Solutions with Microsoft SQL Server

This exam is intended for business intelligence (BI) architects, who are responsible for the overall design of a BI infrastructure and how it relates to other data systems in use.

70-762

Exam 70-762/Course 20762

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.

70-767

Exam 70-767/Course 20767

Implementing a Data Warehouse using SQL

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

Exam 70-768/Course 20768

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.

70-773

Exam 70-773/Course 20773

Analyzing Big Data with Microsoft R

Candidates for this exam are data scientists or analysts who process and analyze data sets larger than memory using R. Candidates should have experience with R, familiarity with data structures, familiarity with basic programming concepts (such as control flow and scope), and familiarity with writing and debugging R functions.

70-774

Exam 70-774/Course 20774

Perform Cloud Data Science with Azure Machine Learning

Candidates for this exam are data scientists or analysts who use Azure cloud services to build and deploy intelligent solutions. Candidates have a good understanding of Azure data services and machine learning and are familiar with common data science processes such as filtering and transforming data sets, model estimation, and model evaluation. Candidates for this exam should have experience publishing effective APIs for knowledge intelligence.

70-775

Exam 70-775/Course 20775

Perform Data Engineering on Microsoft Azure HDInsight

This certification exam is targeted towards data engineers, data architects, data scientists, and data developers who implement big data engineering workflows on HDInsight. Candidates for this exam should have relevant work experience in big data analytics solutions. Candidates should also be familiar with the features and capabilities of batch data processing, real-time processing, and interactive processing. Candidates who take this exam are expected to be able to apply the Microsoft cloud ecosystem to design and implement big data engineering workflows and to use open source technologies for strategic value-add.

70-777

Exam 70-777/Course 20777

Implementing Microsoft Azure Cosmos DB Solutions

Candidates for this exam are developers and architects who leverage Azure Cosmos DB. Candidates should understand fundamental concepts of partitioning, replication, and resource governance for building and configuring scalable applications that are agnostic of a Cosmos DB API. Candidates should also have basic working knowledge of the Cosmos DB SQL API.

Candidates for this exam design, build, and troubleshoot Cosmos DB solutions that meet business and technical requirements.

MCSE Data Management and AnalyticsMCSE: Data Management and Analytics

The globally recognized standard for IT professionals

Completed this certification?