Administering Relational Databases on Microsoft Azure (DP-300) Cert Prep: 1 The Azure Data Platform

Learn the skills to help you pass the first two components of the Microsoft DP-300 certification exam.

Introduction

• Prepare for the DP-300 certification
• What you should know

1. Azure's Database Offerings

• An introduction to the Azure data platform
• Virtual machines for SQL Server
• Azure SQL Database
• MySQL
• MariaDB
• PostgreSQL

2. Create a SQL Server Virtual Machine

• SQL Server on Azure VM
• SQL Server high availability and disaster recovery
• Deploying a SQL Server VM from the Azure Marketplace
• Connect to the SQL Server instance
• Migrating a database to a SQL Server VM

3. The Azure Database Platform as a Service (PaaS)

• Azure SQL Database PaaS
• Backups, replication, and failover groups
• Deploy Azure SQL Database
• Connect to Azure SQL Database
• Add a database to an elastic pool
• What is a SQL Server Managed Instance?
• Set up SQL Data Sync for Azure

4. Authentication and Authorization

• Understanding Azure Active Directory
• Principals and securables
• Permissions and roles
• Configure an Azure Active Directory admin
• Control access with firewall rules
• Add user accounts to a database

5. Data Security

• Protect data at rest with Transparent Data Encryption (TDE)
• Dynamic data masking
• Encrypt data in transit
• Configure Transport Layer Security (TLS)
• Microsoft Defender for SQL

6. Compliance Controls

• Classifying sensitive data
• Enabling and viewing data classifications
• Manage data with Microsoft Purview
• Create tamper-evident databases with Ledger

Conclusion

• Next steps