MCSE Data Platform

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

Step	Title	Optional training	Required exam
1	Querying Microsoft SQL Server 2012/2014	Take course 20461	Take exam 461
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)