Protect data in-transit and at rest

Intermediate
Data Analyst
Data Engineer
Database Administrator
Azure
Azure SQL Database
SQL Server

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

Learning 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

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