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.

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

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.

Exam 70-475

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.

Exam 70-464/Course 20464D

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.

Exam 70-465/Course 20465D

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.

Exam 70-466/Course 20466D

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.

Exam 70-467/Course 20467D

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.

Exam 70-762/Course 20762B

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.

Exam 70-767/Course 20767B

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.

Exam 70-768/Course 20768B

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.

Exam 70-773/Course 20773A

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.

Exam 70-774/Course 20774A

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.

Exam 70-775/Course 20775A

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.



Related News

MCSA: SQL 2016 Database Development
Microsoft Office Specialist 2016
MCSA: Microsoft Dynamics 365
MCSA: Web Applications
MCSE Productivity Solutions Expert