MCSE Data Platform

Earning an MCSE: Data Platform certification will qualify you for jobs such as database analyst and database designer.

StepTitleOptional trainingRequired examCertification earned
1 Querying Microsoft SQL Server 2012/2014 Take course 20461 Take exam 461 MCSE: Data Platform Solutions Expert
2 Administering Microsoft SQL Server 2012/2014 Databases Take course 20462 Take exam 462
3

Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

After successfully completing steps 1–3, you'll earn an MCSA: SQL Server 2012/2014 certification.

Take course 20463 Take exam 463
4 Developing Microsoft SQL Server Databases Take course 20464 Take exam 464
5 Designing Database Solutions for SQL Server Take course 20465 Take exam 465

This MCSE certification requires you to show continued ability to perform in your chosen solution area by completing a recertification exam every three years.

View as Grid List
Sort by
Display per page

Course: Querying Microsoft SQL Server (20761 part of MCSA SQL 2016)

20761
The main purpose of this 3 day instructor led course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals. The course will very likely be well attended by SQL power users who aren’t necessarily database-focused; namely, report writers, business analysts and client application developers.
£1,950.00 (GBP) £995.00 (GBP)

Course: Administering Microsoft SQL Server Databases (20462)

20462
This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.
£1,850.00 (GBP)

Course: Querying Microsoft SQL Server® 2014 (20461) part of MCSA SQL Server 2012 / 2014

20461
This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare people for the exam "70-461: Writing Queries Using Microsoft® SQL Server® 2014 Transact-SQL." This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.
£1,690.00 (GBP)

Course: Implementing a Data Warehouse with Microsoft SQL Server (20463)

20463
This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
£1,850.00 (GBP)

Course: Developing Microsoft SQL Server Databases (20464)

20464
This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.
£1,950.00 (GBP)

Course: Designing a Data Solution with Microsoft SQL Server (20465)

20465
The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.
£1,950.00 (GBP)