Quick enquiry


Is this a business enquiry?

Member of Uk Armed Forces?

Enquire Now

MCSE data management and analytics

Please note that Microsoft have retired this exam. Please speak to our consultants to understand the new Microsoft role based exams


This certification enables you to 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. The MCSE: Data Management and Analytics prove that you have what it takes to plan database environments and leverage business intelligence to improve decision making by validating your skills in managing and maintaining enterprise databases, resulting in high levels of data availability.

OverviewWhat you'll learnWhat's included

Your quick course guide

Certification: MCSE Data Management and Analytics

Study time: 20-30 hours

Vendor: Microsoft

Provider: Skillsoft

Student support: StudentCare™ and expert mentors

Prerequisites: MCSA SQL Server 2012/2014MCSA SQL 2016 Database AdministrationMCSA SQL 2016 Database Development, MCSA SQL 2016 BI Development, MCSA Machine Learning, MCSA BI Reporting or MCSA Data Engineering with Azure

Assessment: 1 x 120 minute exam, 40-60 questions, pass any one exam

Resources: Internet access and email

Ideal for: Database analyst, database designer and business intelligence architect

Included in your modules

Design and implement database solutions for Microsoft SQL Server and Microsoft Azure SQL Database
Design and Implement Security
Design for high availability, disaster recovery, and scalability
Monitor and manage database implementations in Azure
Design big data batch processing and interactive solutions
Design big data real-time processing solutions
Operationalise end-to-end cloud analytics solutions
Read and Explore Big Data
Process Big Data
Process Predictive Models with ScaleR
Use R Server in Different Environments
Prepare Data for Analysis in Azure Machine Learning
Export from Azure Machine Learning
Develop Machine Learning Models
Operationalise and Manage Azure Machine Learning Services
Use Other Services for Machine Learning
Design and implement database objects
Implement programmability objects
Manage database concurrency
Optimise database objects and SQL infrastructure
Sql Server 2016 Database Objects
Sql Server 2016 Indexes And Views
Columnstore Indexes
Programmability Objects
Triggers And Functions
Transactions And Isolation Levels
Managing Database Concurrency
Optimise Sql Database Objects And Infrastructure

Get certified the Learning People way

Professional development that works around you

World's #1 eLearning portal
Global community of peers
Expert mentors
Test prep
Hands-on interactive Practice Labs
Unlimited access
Training mapped to Microsoft exam curriculum
Award winning training used globally by leading corporate clients

Salary Indicator

Salary Projection

Average salary after completing

Average Salary
Junior Database Administrator
Average Salary
You can earn
Average Salary
Database Programmer
Source: Adzuna


You can earn an average of £71,650.00 a year

Technology is the fastest evolving sector, with jobs increasing at 2.6 times the rate of the rest of the economy

Are you ready to get your hands on the tech world?

Get in touch

Validate your experience

Validate your skills in managing and maintaining enterprise databases to ensure high levels of data availability

Meet demand

Prove you have what it takes to plan database environments and leverage business intelligence to improve devision making

Great Earnings

With an average salary of £40,000+ MCSE certified professionals enjoy lucrative and rewarding careers

Why learn with us?

We'll get you career ready and help place you into the industry
Learn from home 24/7
Award winning digital education
Global community of over 40,000 students
Industry leading tuition with 1:1 personal tutor access
Unrivalled 360 Career Services and StudentCare™
Access virtual seminars and live classrooms
We only partner with the biggest accreditors in the world
Gain invaluable industry experience
Exclusive student benefits; Alumni community, TOTUM, industry events and lots more
Change career, start fresh or simply advance in your current role

Our training is trusted by

Accredited by and partnered with