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