MEAPSA

Protect data in-transit and at rest

Explore encryption options available within Azure SQL, including firewall rules, Always Encrypted, and Transport Layer Security. Understand how SQL Injection works.

Data Analyst

Data Engineer

Database Administrator

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
Implement object level encryption
Understand the difference between database and server firewall rules for Azure SQL Database
Explore Always Encrypted with secure enclaves

Units

Introduction min
Explore Transparent Data Encryption min
Configure server and database firewall rules min
Explain object encryption and secure enclaves min
Enable encrypted connections min
Describe SQL injection min
Understand Azure Key Vault 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 or cloud-based
Understanding of why security is a crucial part of database system planning
Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
Experience creating and configuring resources using the Azure portal