Azure Database Administrator Associate (DP-300) Cert Prep: 2 Azure Data Optimization and Automation
1h 49mIntermediate2021-11-03
Authors
Adam Wilbert
Data Visualization Expert
Course details
Passing the Microsoft DP-300 certification exam allows job seekers to demonstrate proficiency with next-gen, cloud-based database technologies, and in this Administering Relational Databases on Microsoft Azure (DP-300) Cert Prep series of courses, Adam Wilbert takes you through the key aspects of the exam that you need to know. This second course in the series covers the Azure database platform, including SQL Server virtual machines, hosted Azure SQL Databases, and other open-source databases that are available on the service. This course focuses on monitoring and automating Azure and SQL Server resources. Even if you don’t plan on taking the exam, studying these aspects is still a great way to gain the knowledge and proficiency needed to modernize your organization's database resources.
Skills covered
SQL ServerDatabase AdministrationDatabase ManagementAzureNetwork AdministrationCloud PlatformsCert PrepNetwork and System AdministrationCloud ComputingMicrosoft
Concepts
0. Introduction
- 01 - Optimize and automate Azure databases
- 02 - What you should know
1. Monitoring Azure Resources
- 03 - Review VM performance with Azure Monitor
- 04 - Connect to a VM with Remote Desktop
- 05 - Create an automated alert
- 06 - Collect performance data with Azure Intelligent Insights
2. Optimizing Azure Performance
- 07 - Storage configurations for Azure Virtual Machines
- 08 - Resizing a virtual machine
- 09 - Allocate resources with Resource Governor
3. Optimizing SQL Server Performance
- 10 - Database-level performance options
- 11 - Intelligent query processing
- 12 - Rebuild and reorganize indexes
- 13 - Maintain up-to-date statistics
4. Optimizing Query Performance
- 14 - Estimated and actual query plans
- 15 - Reading a query plan
- 16 - Retrieve performance data from the Query Store
- 17 - Leverage dynamic management views
- 18 - Wait statistics, locks, and blocks
- 19 - Automatic index tuning
5. Automate Tasks with SQL Server Agent
- 20 - Create an automated maintenance plan
- 21 - Automate notifications and alerts
- 22 - Monitor queries with extended events
6. Automate Resource Deployment
- 23 - Azure Resource Manager templates
- 24 - Create a template
- 25 - Deploy a template
Conclusion
- 26 - Next steps