Alison's New App is now available on iOS and Android! Download Now

Exploring SQL Server 2016: Intermediate

This Free Online Course on SSAS, SSRS, Always Encrypted and Other Improved Features in the SQL Server 2016.

Publisher: Workforce Academy Partnership
The SQL server 2016 is different from working with the initial versions of the SQL server. The 2016 version has improved features such as data masking, always encrypted, row-level security and others, created to improve the quality of work. This course provides knowledge for working with the SSAS, SSISDB catalogue, SSRS and other features. If you are a DBA or a generalist with an interest in SQL, then, you will need to complete this course.
Exploring SQL Server 2016: Intermediate
  • Duration

    3-4 Hours
  • Students

  • Accreditation






View course modules


Microsoft SQL server is a relational database management system developed by Microsoft. It is highly flexible and can be run on a laptop and even a high-powered cloud server. Since the release of the SQL server 1.0, SQL server keeps evolving. While its core function is the relational database management systems, SQL server has become much more than that. This free online course on Exploring SQL server 2016 intermediate has been specially prepared to take you through a variety of new features and enhancements to the data platform. Also, on delivery breakthrough performance, advanced and richer security, integrated reporting and analytics capabilities in the SQL server 2016. It is important to understand these features and how to manipulate each to suit your desired outcomes. In this course, you will be introduced to the row level security and its functionalities. You will learn how to filter and block the data access as well as the restrictions of the row level security. This course analyzes the dynamic masking function and illustrates how to define data masking within the structure of a table to protect data from unauthorized access.

If you want to learn how to integrate the R-script into SQL server and management studio as well as the syntax for inputs and outputs in the R- language you should complete this course. You will also learn about the stretch database and how to work with Microsoft Azure to create a virtual machine in the cloud. This course defines the master data management (MDM) and explains in detail the master data services (MDS). It covers the installation process of the MDS in excel, how it works and how to develop the MDS. You will also learn about the requirements for using the MDS, and the problems the MDS addresses. Creating report designs starts with being able to embed things in a web application. To successfully design easy to read reports, you will need a detailed knowledge of the improvements in the SQL server 2016 reporting services (SSRS) which has been covered in this course. You will learn about the key performance indicators (KPI) and the workflow for creating KPI’s.

Furthermore, this course analyzes the bi- directional filtering and display folders as well as heap fragmentation and memory location under the SQL server analysis service (SSAS). Did you know that it is possible to find and display the name of a column in which an error occurred? This course explores the SSISDB catalog and how to debug errors in the SQL server. It illustrates the creation of a catalog, its configuration and how to deploy packages and projects in the SQL server 2016. However, after deployment of a package in the SQL server 2016, the package can fail. Completing this course will show you how to revert to the previous deployment in the catalog. You will learn how to protect sensitive data using always encrypted and how to configure the always encrypted for individual database columns containing the sensitive data to be encrypted. The Learning content in this course is crucial and will be of great interest to students, researchers, analysts, IT business developers and anyone with an interest in creating programs in SQL Server 2016. So, register for this course and start your learning.

Start Course Now