Practitioner Level
10 Hands-on labs

Azure Database Administrator Associate

By Landon Fowler
By Steven Moran

Use this course to prepare for the DP-300: Administering Relational Databases on Microsoft Azure exam.

See Pricing
19.1 hours
  • 82 Lessons
  • 10 Hands-On Labs
  • 1 Practice Exam

About the course

This course prepares students who are already familiar with core Azure services and Azure and SQL database skills used by Azure Database Administrators.

An Azure Database Administrator is responsible for the management, availability, security, performance monitoring, and optimization of modern relational database solutions. They also assist Azure Data Engineers in managing operational aspects of a data platform solution. Azure Database Administrators are familiar with:

  • Deploying SQL database solutions within Azure
  • Azure SQL Server, database, and query architecture
  • Basic usage of Transact-SQL for administrative tasks
  • Securing Azure SQL resources and data
  • Interconnecting Azure SQL resources with other Azure services
  • Monitoring and optimizing Azure SQL Database performance
  • Maintaining business continuity for Azure SQL resources
  • Processes for migrating on-premises SQL Server databases to Azure
  • Other options for managing relational data in Azure

This course also prepares exam candidates to pass the DP-300: Administering Relational Databases on Microsoft Azure exam to attain the Azure Database Administrator Associate certification. Candidates for the exam are presumed to be database administrators and data management specialists that manage on-premises and cloud relational databases built on top of Microsoft SQL Server and Microsoft Azure data services.

Lab Highlights

Automate Maintenance on Azure SQL Databases Establish a Maintenance Plan on SQL Server Manually Implement Database Maintenance Resolve Query Performance Issues Use Extended Events to Identify Performance Problems Perform SQL Database Backup and Recovery in Azure Protect SQL Database Data Manage Access to Azure SQL Data Implement a SQL Server Database on an Azure VM Provision Azure SQL Databases
Contact SalesSee Pricing
  • Chapter 1 5 Lessons Introduction 26:32

    Course Introduction

    2:09

    About the Training Architect - Steven Moran

    1:44

    About the Training Architect - Landon Fowler

    0:52

    DP-300 Exam Overview

    13:20

    Course Overview

    8:27
  • Chapter 2 23 Lessons Deploying Azure SQL Databases 4:29:23

    Introduction to Deploying Azure SQL Systems

    1:33

    Exploring SQL Database Deployment Options in Azure

    5:16

    Exploring Azure SQL Resource Configuration Basics

    14:10

    Examining the DTU Purchasing Model

    9:27

    Examining the vCore Purchasing Model

    9:29

    Examining the Standard/General Purpose Service Tiers

    8:24

    Examining the Premium/Business Critical Service Tiers

    6:00

    Examining the Hyperscale Service Tier

    8:01

    Selecting the “Best” Resource Configuration Options

    17:53

    Provisioning Azure SQL Database Servers

    13:37

    Provisioning Azure SQL Single Databases

    14:37

    Demo: Creating Azure SQL Database Servers and Single Databases using the Azure Portal

    14:18

    Provisioning Azure SQL Elastic Pools

    16:05

    Demo: Creating Elastic Pools using the Azure Portal

    9:02

    Provision Azure SQL Databases

    15:00 Hands-On Lab

    Implementing SQL Server on Azure VMs

    16:11

    Demo: Provisioning SQL Server on Azure VM

    10:39

    Provisioning Azure SQL Managed Instances - Part 1

    9:44

    Provisioning Azure SQL Managed Instances - Part 2

    9:22

    Demo: Provisioning Azure SQL Managed Instance using the Azure Portal

    9:37

    Selecting the “Best” Azure SQL Deployment Option

    7:42

    Implement an SQL Server database on an Azure VM

    30:00 Hands-On Lab

    Automating SQL Deployment with PowerShell and Azure CLI

    13:16
  • Chapter 3 18 Lessons Securing Azure SQL Databases 4:37:21

    Introduction to Securing Azure Resources

    1:33

    Authorizing Management Access to Azure SQL Objects

    5:50

    Controlling Network Access to Azure SQL Databases

    15:38

    Controlling Network Access to SQL Virtual Machines

    4:05

    Controlling Network Access to Azure SQL Managed Instances

    7:55

    Managing Azure SQL Authentication

    14:14

    Authorizing SQL Data Access - Part 1

    9:09

    Authorizing SQL Data Access - Part 2

    11:50

    Managing Access to Azure SQL Data

    1:00:00 Hands-On Lab

    Protecting SQL Data

    15:18

    Integrating with Azure Key Vault

    16:35

    Demo: Integrating Azure SQL with Azure Key Vault - Pt 1

    6:04

    Demo: Integrating Azure SQL with Azure Key Vault - Pt 2

    9:09

    Demo: Enable Column Encryption in SSMS

    7:06

    Examining Azure Defender for SQL

    10:49

    Monitoring Azure SQL Activity

    15:43

    SQL Data Discovery and Classification

    6:23

    Protecting SQL Database Data

    1:00:00 Hands-On Lab
  • Chapter 4 8 Lessons Implementing HA/DR for Azure SQL 1:26:48

    Introduction to Implementing HA/DR for Azure SQL

    0:57

    SQL Virtual Machine Backup and Recovery Options

    8:20

    Azure SQL PaaS Backup and Recovery Options

    5:15

    SQL Server Continuity Solutions - Part 1

    7:34

    SQL Server Continuity Solutions - Part 2

    10:14

    Azure Virtual Machine Continuity Solutions

    13:32

    Azure SQL PaaS Continuity Solutions

    10:56

    Perform SQL Database Backup and Recovery in Azure

    30:00 Hands-On Lab
  • Chapter 5 7 Lessons Migrating to Azure SQL 57:01

    Introduction to Migrating to Azure SQL

    1:52

    Exploring the Azure SQL Migration Process

    11:02

    Exploring SQL Migration Tools & Services

    6:02

    Exploring Azure SQL Migration Methods

    9:39

    Azure SQL Family Migration Considerations

    8:02

    Working with the Azure Database Migration Service - Part 1

    8:55

    Working with the Azure Database Migration Service - Part 2

    11:29
  • Chapter 6 19 Lessons Monitoring and Maintaining Azure SQL Database Performance 4:42:47

    Introduction to Azure SQL Performance

    10:05

    Working with Performance Baselines

    9:40

    Identifying Performance Problems (Part 1)

    7:56

    Identifying Performance Problems (Part 2)

    13:03

    Working with Extended Events

    11:43

    Using Extended Events to Identify Performance Problems

    30:00 Hands-On Lab

    Improving System Performance (Part 1)

    11:56

    Improving System Performance (Part 2)

    5:51

    Examining Azure SQL Scalability Options

    7:44

    Improving Query Performance

    8:24

    Resolve Query Performance Issues

    30:00 Hands-On Lab

    Maintaining Performance

    8:46

    Manually Implementing Database Maintenance

    30:00 Hands-On Lab

    Automating Maintenance

    9:03

    Working with SQL Server Agent

    8:02

    Establishing a Maintenance Plan on SQL Server

    30:00 Hands-On Lab

    Working with Azure Automation

    8:19

    Working with Elastic Jobs

    12:15

    Automating Maintenance on Azure SQL Databases

    30:00 Hands-On Lab
  • Chapter 7 3 Lessons Conclusion 2:26:41

    Final Words

    9:57

    Course Wrap-Up

    1:44

    DP-300 Practice Exam

    2:15:00 Quiz

What are Hands-on Labs

What's the difference between theoretical knowledge and real skills? Practical real-world experience. That's where Hands-on Labs come in! Hands-on Labs are guided, interactive experiences that help you learn and practice real-world scenarios in real cloud environments. Hands-on Labs are seamlessly integrated in courses, so you can learn by doing.

Get Started
Who’s going to be learning?
MyselfMy Organization
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!

Don't have an account?