MCSA SQL 2016

Demonstrate your essential skills as a database professional, for both on-premises and cloud-based databases. (New to IT? Learn about MTA certification for new entrants.)

Earning an MCSA: SQL 2016 Database Development certification validates your skills in building and implementing databases across organisations, and will qualify you for a position as a database developer.

Step	Title	Optional training	Required exam	Certification earned
1	Querying Data with Transact-SQL	Take course 20761	Take exam 761 (in development)
2	Developing SQL Databases	Take course 20762	Take exam 762

Earning an MCSA: SQL 2016 Database Administration certification validates your skills with database installation, maintenance, configuration, and provisioning tasks, and will qualify you for a position as a database administrator or infrastructure specialist.

Step	Title	Optional training	Required exam	Certification earned
1	Administering a SQL Database Infrastructure	Take course 20764	Take exam 764 (in development)
2	Provisioning SQL Databases	Take course 20765	Take exam 765

Earning an MCSA: SQL 2016 Business Intelligence Development certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes. This certification will qualify you for a position as a BI developer.

Step	Title	Optional training	Required exam	Certification earned
1	Implementing an SQL Data Warehouse	Take course 20767	Take exam 767 (in development)
2	Developing SQL Data Models	Take course 20768	Take exam 768

New options to earn your MCSE certification are coming in Summer 2016.

View as Grid List

Sort by

Display per page

Course: Administering a SQL Database Infrastructure (20764 part of MCSA SQL 2016 DA)

20764

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.

£1,950.00 (GBP) £1,790.00 (GBP)

Course: Developing SQL Data Models (20768 part of MCSA SQL 2016 BI)

20768

This three-day instructor-led course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS.

£1,950.00 (GBP) £995.00 (GBP)

Course: Developing SQL Databases (20762 part of MCSA SQL 2016)

20762

This four-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

£1,950.00 (GBP) £1,290.00 (GBP)

Course: Implementing a SQL Data Warehouse (20767 part of MCSA SQL 2016 BI)

20767

This 5-day instructor led 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® 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

£1,950.00 (GBP) £1,790.00 (GBP)

Course: Provisioning SQL Databases (20765 part of MCSA SQL 2016 DA)

20765

This five day course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

£1,950.00 (GBP)

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)