MEAPSA

Protect data in-transit and at rest

Explore encryption options available within Azure SQL, on-premises SQL Server and Open Source data platforms and Secure Enclaves. Implement database and instance firewalls.

Data Analyst

Database Administrator

Data Engineer

Azure

SQL Server

SQL Database

Module Objectives

After completing this module, you will be able to:

Understand the data encryption options available in the various platforms
Configure encryption for data at rest and in transit
Implement object level encryption
Configure SQL Server to use Azure Key Vault
Understand the difference between database and instance firewalls in Azure SQL Database
Explore Secure Enclaves

Units

Introduction min
Describe the role of firewalls min
Explain encryption at rest min
Describe the role of Azure Key Vault in transparent data encryption min
Explain object encryption and secure enclaves min
Explain dynamic data masking min
Exercise: Configure a server-based firewall rule using the Azure portal min
Knowledge check min
Summary min

Prerequisites

Ability to use tools for running queries against a Microsoft SQL database, either on-premises on cloud-based.
Understanding of why security is a crucial part of database system planning.
Experience creating and configuring resources using the Azure portal.