Microsoft SQL Server 2016: Encryption

Course Overview

Ensuring data security is an important part of administering any database infrastructure, and encryption is one method to help you protect sensitive data. This course will teach you about encryption-related tools and processes used in SQL Server 2016, including cell-level, backup, and connection encryption. In addition, this course covers the Always Encrypted feature, Transparent Data Encryption, and troubleshooting. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Target Audience

Database Administrators, database professionals

Learning Objectives

• describe the encryption features supported in SQL Server 2016
• describe Transparent Data Encryption and the keys used for encrypting and decrypting data
• use Transparent Data Encryption
• describe the features and limitations of Always Encrypted
• use the Always Encrypted Wizard
• configure Always Encrypted using SQL Server Management Studio
• configure Always Encrypted using PowerShell
• describe support and limitations for encryption with Azure SQL Database
• describe the benefits, requirements, restrictions, methods, and recommended practices for backup encryption
• create an encrypted backup
• recognize the purpose of cell-level encryption and how to use Transact-SQL and symmetric encryption to configure it
• enable encrypted connections to a database
• troubleshoot encryption
• configure encryption in SQL Server 2016