In this module, you will be introduced to working with some of the new features of SQL server 2016. It explores row-level security, dynamic masking and always encryption. You will learn about the version of replication, how to work with Microsoft Azure, as well as how to create virtual machines in the cloud.

In this module, you will be introduced to working with the SSISDB catalogue in SQL server 2016. You will learn how to create a catalogue, set up the catalogue environment and deploy packages and projects. This module covers the new database roles in SSISDB, the data source v3 and v4 protocol and other expanded features on the SQL server 2016.

This module explores the features of the analysis services (SSAS) and reporting services (SSRS) in SQL server 2016. It analyzes the Tabular model scripting language and the DBBC command. You will also learn about the DAX function.

In this module, you will be taken through the installation process for the R- studio for the R- language. This module explores the improvements of the master data services ( MDS) in SQL server 2016.