MEAPSA

Plan and implement security for Azure SQL Database and Azure SQL Managed Instance

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.

Administrator

Security Engineer

Azure

SQL Database

SQL Managed Instance

Module Objectives

By the end of this module, participants will be able to:

Implement security for Azure SQL 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.

Units

Introduction min
Enable database authentication by using Microsoft Entra ID min
Enable and monitor database audit min
Identify use cases for the Microsoft Purview governance portal min
Implement data classification of sensitive information by using the Microsoft Purview governance portal min
Plan and implement dynamic mask min
Implement transparent data encryption min
Recommend when to use Azure SQL Database Always Encrypted min
Knowledge check min
Summary min

Prerequisites

None