Implement data security and compliance with SQL

  • Module
  • 11 Units
Intermediate
Database Administrator
Developer
Data Engineer
SQL Server
Azure SQL Database
Microsoft Fabric

Learn how to protect sensitive data and meet compliance requirements by implementing encryption, masking, access controls, and auditing across Microsoft's SQL platforms.

Learning objectives

By the end of this module, you'll be able to:

  • Design and implement data encryption using Always Encrypted and column-level encryption
  • Configure Dynamic Data Masking to protect sensitive data
  • Implement Row-Level Security to filter data access based on user context
  • Design object-level permissions and implement secure, passwordless database access using Microsoft Entra ID
  • Configure auditing to track database activity
  • Secure model endpoints and API endpoints for modern applications

Prerequisites

  • Experience writing T-SQL queries and developing databases in SQL Server, Azure SQL, or SQL databases in Microsoft Fabric
  • Familiarity with database security concepts such as authentication and authorization
  • Understanding of Microsoft Entra ID basics
  • Access to a SQL Server, Azure SQL Database, or SQL database in Microsoft Fabric for testing
Start