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.
Learning Objectives
Configuring Encryption
- start the course
- 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
Configuring Always Encrypted
- 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
Using Encryption Technologies
- 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
Practice: Encrypting in SQL Server 2016
- configure encryption in SQL Server 2016