Overview
Learn the skills to help you pass the Azure and SQL Server components of the Microsoft DP-300 certification exam.
Syllabus
Introduction
- Optimize and automate Azure databases
- What you should know
- Review VM performance with Azure Monitor
- Connect to a VM with Remote Desktop
- Create an automated alert
- Collect performance data with Azure Intelligent Insights
- Storage configurations for Azure Virtual Machines
- Resizing a virtual machine
- Allocate resources with Resource Governor
- Database-level performance options
- Intelligent query processing
- Rebuild and reorganize indexes
- Maintain up-to-date statistics
- Estimated and actual query plans
- Reading a query plan
- Retrieve performance data from the Query Store
- Leverage dynamic management views
- Wait statistics, locks, and blocks
- Automatic index tuning
- Create an automated maintenance plan
- Automate notifications and alerts
- Monitor queries with extended events
- Azure Resource Manager templates
- Create a template
- Deploy a template
- Automate with Bicep, PowerShell, and the Azure CLI
- Next steps
Taught by
Adam Wilbert