Microsoft SQL Server 2016: Encryption

Microsoft SQL Server 2016: Encryption

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

Overview/Description
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

Prerequisites
None

Expected Duration (hours)
1.6

Lesson Objectives

Microsoft SQL Server 2016: 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

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

Course Number:
df_sqla_a01_it_enus

Expertise Level
Intermediate