• Online, Self-Paced
Course 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.

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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.