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.

StepTitleOptional trainingRequired examCertification earned
1 Querying Data with Transact-SQL Take course 20761 Take exam 761 (in development) MCSA: SQL 2016 Database 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.

StepTitleOptional trainingRequired examCertification earned
1 Administering a SQL Database Infrastructure Take course 20764 Take exam 764 (in development) MCSA: SQL 2016 Database Administration
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.

StepTitleOptional trainingRequired examCertification earned
1 Implementing an SQL Data Warehouse Take course 20767 Take exam 767 (in development) MCSA: SQL 2016 Business Intelligence 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)