- Module 1: This module is designed to empower administrators with the knowledge and skills needed to plan and implement robust security measures for Azure SQL Database and Azure SQL Managed Instance, ensuring data protection and regulatory compliance.
By the end of this module, participants will be able to:
- Implement security for Azure SQL Database and Managed Instance to safeguard sensitive data.
- Use Microsoft Enterprise Identity for database authentication and conduct database auditing for compliance.
- Utilize Microsoft Purview for data governance and classification to protect sensitive information.
- Apply dynamic masking and Transparent Database Encryption, and recommend Always Encrypted for client-side data protection.
Overview
Syllabus
- Module 1: Module 1: Plan and implement security for Azure SQL Database and Azure SQL Managed Instance
- Introduction
- Enable database authentication by using Microsoft Entra ID
- Enable and monitor database audit
- Identify use cases for the Microsoft Purview governance portal
- Implement data classification of sensitive information by using the Microsoft Purview governance portal
- Plan and implement dynamic mask
- Implement transparent data encryption​
- Recommend when to use Azure SQL Database Always Encrypted
- Knowledge check
- Summary