Practitioner Level

Managing Azure SQL Database for the SQL Server DBA

By Warner Chaves

This course will teach you how to take advantage of your existing SQL Server skills and learn about the service and consumption models, security configurations, common management tasks, high availability and disaster recovery, and performance monitoring of Azure SQL Database.

See Pricing
5.9 hours
  • 47 Lessons
  • 6 Course Quizzes

About the course

In this course, Managing Azure SQL Database for the SQL Server DBA, you’ll learn how to take advantage of your existing SQL Server skills to build your Azure SQL Database expertise.

First, you’ll explore the different service and consumption models in the service. Next, you’ll discover security, connectivity, high availability, and disaster recovery settings exposed by this cloud database.

You will then learn how to migrate SQL Server databases to Azure SQL Database and vice versa. Finally, you’ll learn how to monitor and alert on the performance of your Azure SQL database.

When you’re finished with this course, you’ll be able to confidently apply your SQL Server experience to building or migrating a database solution to the cloud into Azure SQL Database.

Contact SalesSee Pricing
  • Chapter 1 2 Lessons Introduction 3:34

    Course Introduction

    2:11

    Prerequisites

    1:23
  • Chapter 2 7 Lessons What Is Azure SQL Database? 52:31

    Introduction to What Is Azure SQL Database?

    1:16

    What Is Azure SQL Database?

    5:27

    Service Cost and Value

    8:21

    Getting Started

    5:05

    Demo: Creating an Azure SQL Database

    13:51

    Section Summary

    3:31

    Quiz: Azure SQL Database Fundamentals

    15:00 Quiz
  • Chapter 3 8 Lessons Connecting and Managing Azure SQL Database 59:12

    Introduction

    1:06

    Networking, Firewalls, and Authentication

    10:21

    Demo: Connecting to the Database

    8:22

    Security Features

    7:23

    Differences with SQL Server

    6:00

    Demo: Management Differences

    7:48

    Section Summary

    3:12

    Quiz: Connecting and Managing Azure SQL Database

    15:00 Quiz
  • Chapter 4 8 Lessons Understanding the Service Tiers 57:38

    Introduction

    1:17

    Service Tiers Fundamentals

    5:56

    Core-Based Tiers

    7:06

    Demo: Scaling Up the Service Tier

    7:56

    Azure SQL Database Optional Modes

    8:19

    Demo: Creating a Database Elastic Pool

    7:51

    Section Summary

    4:13

    Quiz: Azure SQL Database Service Tiers

    15:00 Quiz
  • Chapter 5 8 Lessons Recovery in Azure SQL Database 53:31

    Introduction

    1:05

    Backup Capabilities

    6:41

    Performing Restores

    3:23

    Demo: Restoring a Database

    5:25

    High Availability and Disaster Recovery

    10:51

    Demo: Configuring an Auto-Failover Group

    7:41

    Section Summary

    3:25

    Quiz: Recovery in Azure SQL Database

    15:00 Quiz
  • Chapter 6 9 Lessons Migrating to and from Azure SQL Database 54:47

    Introduction

    1:27

    Migration Methodology

    6:08

    Migration Tools

    6:40

    Demo: Migrating with the Microsoft Data Migration Assistant

    6:40

    Demo: Migrating with SQL Server Transactional Replication

    7:34

    Moving Back to SQL Server

    3:00

    Demo: Migrating Back to SQL Server

    5:08

    Section Summary

    3:10

    Quiz: Azure SQL Database Migration

    15:00 Quiz
  • Chapter 7 9 Lessons Monitoring and Tuning Azure SQL Database 1:03:18

    Introduction

    1:38

    Azure Metrics Alerts

    5:38

    Demo: Creating Database Alerts

    12:05

    Performance System Views

    5:12

    Demo: Tracking Performance with System Views

    6:28

    Azure Performance Tools

    4:20

    Demo: Reviewing Performance and Recommendations in the Portal

    9:08

    Section Summary

    3:49

    Quiz: Monitoring and Tuning Azure SQL Database

    15:00 Quiz
  • Chapter 8 2 Lessons Conclusion 7:34

    Course Summary

    6:19

    Conclusion and What’s Next

    1:15

Practice alongside courses in Cloud Playground

What is Cloud Playground? Cloud Playground lets you build skills in real-world AWS, Google Cloud, and Azure environments. Spin up risk-free Sandboxes, Servers and Terminals and follow along with courses, test a new idea or prepare for exams.

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?