Capability Development / Database & DataScience
Administering Microsoft Azure SQL Solutions (DP-300)
This intensive DP-300 program builds job-ready expertise in administering Microsoft Azure SQL solutions across cloud, on-premises, and hybrid data platforms. Participants work through the full administration lifecycle, from deploying IaaS and PaaS SQL solutions to securing, monitoring, automating, migrating, and recovering production workloads. The curriculum blends platform concepts with scenario-based practice covering Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines. Learners leave with the operational discipline and hands-on confidence needed to manage enterprise-grade Azure SQL environments and prepare for the DP-300 certification exam.
Program Overview
This intensive DP-300 program builds job-ready expertise in administering Microsoft Azure SQL solutions across cloud, on-premises, and hybrid data platforms. Participants work through the full administration lifecycle, from deploying IaaS and PaaS SQL solutions to securing, monitoring, automating, migrating, and recovering production workloads. The curriculum blends platform concepts with scenario-based practice covering Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines. Learners leave with the operational discipline and hands-on confidence needed to manage enterprise-grade Azure SQL environments and prepare for the DP-300 certification exam.
Audience Profile
Database administrators moving workloads to Azure; SQL Server DBAs preparing for the DP-300 certification; Cloud infrastructure engineers supporting data platforms; IT professionals responsible for database security and compliance; and Professionals planning database migration and modernization projects.
Course Syllabus
Module 1: SQL Server-Based Databases on Azure
Topics
- Microsoft Intelligent Data Platform roles
- Azure SQL deployment options overview
- SQL Server in an Azure Virtual Machine
- Azure SQL Database for cloud-native applications
- Azure SQL Managed Instance
Module 2: Deploy IaaS Solutions with Azure SQL
Topics
- IaaS options for deploying SQL Server in Azure
- Hybrid deployment scenarios
- Performance and security considerations
- High availability and disaster recovery options
Module 3: Deploy PaaS Solutions with Azure SQL
Topics
- PaaS options for deploying SQL Server in Azure
- Single SQL Database
- SQL Database elastic pools
- SQL Database Hyperscale
- SQL Managed Instance
Module 4: Configure Database Authentication and Authorization
Topics
- Authentication and identity concepts
- Security principals
- Database and object permissions
- Handling authentication and authorization failures
Module 5: Protect Data in Transit and at Rest
Topics
- Transparent Data Encryption
- Object encryption and secure enclaves
- Encrypted connections
- Server and database firewall rules
- SQL injection prevention
- Azure Key Vault integration
Module 6: Implement Compliance Controls for Sensitive Data
Topics
- Data classification
- Server and database auditing
- Microsoft Purview integration
- Dynamic data masking
- Row-level security
- Microsoft Defender for SQL and Ledger
Module 7: Automate Database Deployment
Topics
- Deployment models in Azure
- Azure Resource Manager templates and Bicep
- PowerShell automation
- Azure CLI automation
Module 8: Create and Manage SQL Agent Jobs
Topics
- SQL Agent job management
- SQL Server maintenance plans
- Task status notifications
Module 9: Manage Azure PaaS Tasks Using Automation
Topics
- Elastic Jobs
- Azure Automation
- Automation runbooks
- Database workflows using Logic Apps
- Automated task monitoring
Module 10: Migrate SQL Server Workloads to Azure SQL Database
Topics
- Choosing the right Azure SQL Database feature
- Azure SQL Migration Extension
- BACPAC migration
- Online migration methods
- Moving data to Azure SQL Database
Module 11: Migrate SQL Server Workloads to Azure SQL Managed Instance
Topics
- Evaluating migration scenarios
- Log Replay Service (LRS)
- Managed Instance Link
- Moving data to SQL Managed Instance
Module 12: Performance Monitoring
Topics
- Key performance metrics
- Basic monitoring tools
- Creating simple performance baselines
Module 13: Resource and Database Optimization
Topics
- CPU, memory, and storage impact
- Basic resource sizing
- Database maintenance best practices
Module 14: Query Performance
Topics
- Basic query plans
- Using indexes to improve performance
- Identifying common slow query issues
Module 15: Describe High Availability and Disaster Recovery Strategies
Topics
- Recovery planning concepts: RTO and RPO
- HA/DR options for Azure VMs and PaaS deployments
- HA/DR options for IaaS and hybrid solutions
Module 16: Explore IaaS and PaaS Solutions for High Availability and Disaster Recovery
Topics
- Windows Server failover clusters
- Always On availability groups
- Active geo-replication for Azure SQL Database
- Auto-failover groups for Azure SQL Database and Managed Instance
- Availability monitoring
Module 17: Back up and Restore Databases
Topics
- Backup and restore for SQL Server on Azure Virtual Machines
- Backup and restore for Azure SQL Database and SQL Managed Instance