Azure Database Administrator Associate (DP-300) Cert Prep: 2 Azure Data Optimization and Automation

Focused View

Adam Wilbert

1:48:43

0 View

[1] Introduction

[1] Optimize and automate Azure databases.mp4

00:48

[2] What you should know.mp4

00:59

[2] 1. Monitoring Azure Resources

[1] Review VM performance with Azure Monitor.mp4

04:37

[2] Connect to a VM with Remote Desktop.mp4

05:22

[3] Create an automated alert.mp4

06:12

[4] Collect performance data with Azure Intelligent Insights.mp4

06:53

[3] 2. Optimizing Azure Performance

[1] Storage configurations for Azure Virtual Machines.mp4

06:22

[2] Resizing a virtual machine.mp4

03:40

[3] Allocate resources with Resource Governor.mp4

03:40

[4] 3. Optimizing SQL Server Performance

[1] Database-level performance options.mp4

05:15

[2] Intelligent query processing.mp4

04:55

[3] Rebuild and reorganize indexes.mp4

03:55

[4] Maintain up-to-date statistics.mp4

02:41

[5] 4. Optimizing Query Performance

[1] Estimated and actual query plans.mp4

03:15

[2] Reading a query plan.mp4

05:59

[3] Retrieve performance data from the Query Store.mp4

05:33

[4] Leverage dynamic management views.mp4

05:34

[5] Wait statistics, locks, and blocks.mp4

04:56

[6] Automatic index tuning.mp4

03:48

[6] 5. Automate Tasks with SQL Server Agent

[1] Create an automated maintenance plan.mp4

05:31

[2] Automate notifications and alerts.mp4

04:07

[3] Monitor queries with extended events.mp4

04:43

[7] 6. Automate Resource Deployment

[1] Azure Resource Manager templates.mp4

02:26

[2] Create a template.mp4

03:35

[3] Deploy a template.mp4

03:14

[8] Conclusion

[1] Next steps.mp4

00:43

Description

Passing the Microsoft DP-300 certification exam allows job seekers to demonstrate proficiency with next-gen, cloud-based database technologies, and in this Azure Database Administrator Associate (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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Microsoft Azure

Adam Wilbert

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.