Microsoft SQL Server 2016: Encryption

Database Administrators, database professionals

Prerequisite
None

Expected Duration
98 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.