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, explains 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 enhance the quality of your work. This course provides knowledge for working with the SSAS, SSISDB catalogue, SSRS and other features. If you are a DBA or a generalist interested in SQL, you will greatly benefit by completing this course.
Exploring SQL Server 2016: Intermediate
  • Duration

    3-4 Hours
  • Students

  • Accreditation


Share This Course And
Earn Money  

Become an Affiliate Member





View course modules


Microsoft SQL Server is a relational database management system developed by Microsoft. It is highly flexible and can run on laptops and even a high-powered cloud server. Since the release of the SQL server 1.0, the SQL server has kept evolving. While its core function is the relational database management systems, the SQL server has become far more than that. Exploring SQL server 2016 intermediate course has been specially prepared to take you through various new features and enhancements to the data platform. These include delivery breakthrough performance, advanced and richer security, integrated reporting and analytics capabilities in the SQL server 2016. Understanding these features and manipulating each to suit your desired outcomes is essential. This course will introduce you to row-level security and its functionalities. You will learn how to filter and block the data access and the restrictions of the row-level security. Analyze the dynamic masking function and illustrate how to define data masking within the structure of a table to protect data from unauthorized access.

The course will teach you to integrate the R-script into SQL server and management studio and the syntax for inputs and outputs in the R- language. Investigate the stretch database and work with Microsoft Azure to create a virtual machine in the cloud. This course defines master data management (MDM) and explains the master data services (MDS) in detail. 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 embedding 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) covered in this course. You will learn about the key performance indicators (KPI) and the workflow for creating KPI’s.

Furthermore, this course explores bi-directional filtering and display folders, 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? The 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, the package can fail after deploying a package in the SQL server 2016. By completing this course, we will show you how to revert to the previous deployment in the catalog. Explore how to protect sensitive data using Always Encrypted and configure the Always Encrypted for individual database columns containing the sensitive data to be encrypted. The learning content in this course is fundamental for any student, researcher, analyst, IT business developer or anyone with interest in creating programs in SQL Server 2016. So, register for this course and start your learning.

Start Course Now