Implement compliance controls for sensitive data

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

Explore data classification capabilities and degrees of confidentiality. Implement security options to maintain private data safe, including Azure SQL auditing, Microsoft Defender for SQL, row-level security, Dynamic Data Masking and Azure SQL Database Ledger.

Learning objectives

After completing this module, you will be able to:

  • Plan and implement data classification in Azure SQL Database
  • Understand and configure row-level security and dynamic data masking
  • Understand the usage of Microsoft Defender for SQL
  • Explore how Azure SQL Database Ledger works

Prerequisites

  • Ability to write code in the SQL language, particular the Microsoft T-SQL dialect, at a basic level.
  • Experience creating and configuring resources using the Azure portal.