Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Administering Relational Databases on Microsoft Azure (DP-300) Cert Prep: 2 Azure Data Optimization and Automation

via LinkedIn Learning

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
1. Monitoring Azure Resources
  • Review VM performance with Azure Monitor
  • Connect to a VM with Remote Desktop
  • Create an automated alert
  • Collect performance data with Azure Intelligent Insights
2. Optimizing Azure Performance
  • Storage configurations for Azure Virtual Machines
  • Resizing a virtual machine
  • Allocate resources with Resource Governor
3. Optimizing SQL Server Performance
  • Database-level performance options
  • Intelligent query processing
  • Rebuild and reorganize indexes
  • Maintain up-to-date statistics
4. Optimizing Query Performance
  • 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
5. Automate Tasks with SQL Server Agent
  • Create an automated maintenance plan
  • Automate notifications and alerts
  • Monitor queries with extended events
6. Automate Resource Deployment
  • Azure Resource Manager templates
  • Create a template
  • Deploy a template
  • Automate with Bicep, PowerShell, and the Azure CLI
Conclusion
  • Next steps

Taught by

Adam Wilbert

Reviews

4.7 rating at LinkedIn Learning based on 96 ratings

Start your review of Administering Relational Databases on Microsoft Azure (DP-300) Cert Prep: 2 Azure Data Optimization and Automation

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.