Prerequisites
- Relational Databases
- Transact-SQL (T-SQL)
- Microsoft SQL Server Administration
- Azure Fundamentals (AZ-900)
- Azure Data Fundamentals (DP-900)
- Cloud Computing Concepts (IaaS & PaaS)
- Azure Resource Management
- T-SQL for Administrative Tasks
- Database Administration Experience
Who Should Enroll
- Database administrators
- SQL Server professionals
- Azure cloud professionals
- Data engineers
- Application developers working with Azure SQL
- Candidates preparing for the DP-300 certification exam
What Will You Learn
- Plan and Implement Data Platform Resources
- Deploy Azure SQL Offerings
- Configure for Scale and Performance
- Plan and Implement Migration
- Implement a Secure Environment
- Configure Authentication and Authorization
- Implement Encryption and Data Protection
- Configure Compliance Controls
- Implement Microsoft Defender for SQL
- Monitor and Optimize Operational Resources
- Monitor Database Performance
- Optimize Resources and Databases
- Optimize Query Performance
- Automate Administrative Tasks
- Automate Deployment Using PowerShell, Azure CLI, and ARM Templates
- Manage Jobs and Alerts
- Plan and Implement High Availability and Disaster Recovery (HA/DR)
- Implement and Configure HA/DR Solutions
- Implement Backup and Restore Strategies