MCSA SQL 2016 Database Development

1. Querying Data with Transact-SQL (20761)

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761. 

2. Developing SQL Database (20762)

This five-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. 

MCSA SQL 2016 Database Administration

1. Administering a SQL Database Infrastructure (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. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

2. Provisioning SQL Databases (20765)

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

MCSA SQL 2016 Business Intelligence Development

1. Implementing a SQL Data Warehouse (20767)

This five-day instructor-led course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. 

2. Developing SQL Data Models (20768)

The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.