Learn the skills to help you pass the first two components of the Microsoft DP-300 certification exam.
Overview
Syllabus
Introduction
- Prepare for the DP-300 certification
- What you should know
- An introduction to the Azure data platform
- Virtual machines for SQL Server
- Azure SQL Database
- MySQL
- MariaDB
- PostgreSQL
- 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
- 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
- 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
- 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
- Classifying sensitive data
- Enabling and viewing data classifications
- Manage data with Microsoft Purview
- Create tamper-evident databases with Ledger
- Next steps
Taught by
Adam Wilbert