Exploring SQL Server 2016: Intermediate

Course description

SQL Server 2016 is different from working with the initial versions of SQL Server. The 2016 version has improved features such as data masking, always encrypted data, row-level security and other functions 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 benefit by completing this course.

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 its relational database management system, the SQL server has become far more than that. This ‘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. Understanding these features and using 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. Analyse the dynamic masking function and illustrate how to define ‘data masking’ within the structure of a table to protect data from unauthorised 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 MS 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 (KPIs) and the workflow for creating them.

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 catalogue and how to debug errors in the SQL server. It illustrates the creation of a catalogue, its configuration and how to deploy packages and projects in SQL Server 2016. However, the package can fail after deploying a package in SQL Server 2016. By completing this course, we will show you how to revert to the previous deployment in the catalogue. Explore how to protect sensitive data using the ‘Always Encrypted’ value and configure the ‘Always Encrypted’ value 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.