Complete Microsoft Azure SQL Server Database Administration

Name: Complete Microsoft Azure SQL Server Database Administration
Rating: 4.2 (23 reviews)

Mastering Database Management and Security with Azure SQL Server

Created byEmar Morrison, Adrianna Parchment

Last updated 1/2025

English

What you'll learn

Students will learn how to create and manage databases in Azure dents and individuals who are interested in learning about databases and SQL as a career path
Students will learn how to migrate data from on-premises databases to Azure SQL Database, including best practices and considerations for the migration process.
Students will learn how to monitor and troubleshoot Azure SQL Database
Students will learn how to scale and configure high availability solutions in Azure SQL Database, including how to set up geo-replication and failover groups.

Course content

12 sections • 51 lectures • 5h 2m total length

Introduction1:11

What is Azure zone & regions?4:36
Azure SQL deployment options6:19
This lecture will provide an in-depth overview of the Azure SQL deployment options, specifically the Azure SQL Managed Instance, Azure SQL Database and SQL Server on Azure VM, in order to help you make informed decisions on the appropriate deployment options for your business needs.
Purchasing models, service tiers, and hardware choices5:50
Getting Started with Azure Free Tier4:18
Azure is a cloud computing platform that provides a wide range of services for businesses and individuals. One of the most appealing features of Azure is the Azure Free Tier, which offers a number of services and resources that are free for a limited period of time.
In this lecture, we will explore the Azure Free Tier and the benefits it provides to users. We will cover the different services and resources that are available, including virtual machines, storage and databases.
Additionally, we will discuss the steps needed to set up an Azure Free Tier account.
Management interfaces: Azure Portal3:30
In this lecture, we will explore the Azure Portal, which is the primary management interface for Azure services.

Introduction0:18
Deploying Azure SQL Databases12:09
Exploring SQL Server Management Studio6:47
In this lecture, we will explore SQL Server Management Studio (SSMS), which is a comprehensive management tool for SQL Server databases.
Exploring Azure Data Studio5:49
In this lecture, we will explore Azure Data Studio, which is a cross-platform, lightweight management tool for SQL Server and Azure SQL databases.
Deploying SQL Server Managed Instance2:24
Deploy SQL Server on Azure VM5:20
Setting Up Your Environment

Introduction1:04
Authentication with Azure Active Directory (Microsoft Entra ID)9:57
Microsoft Entra ID is the new name for Azure Active Directory.
Configure and Create AAD Users (Microsoft Entra ID)8:14
Securables and Database Roles5:24
Managing Security with Firewall Rules3:11
Granting Permissions on Securables9:46
Azure Server Roles4:34
Authorize Access to Azure SQL Database with Azure Active Directory

Monitoring Using Azure Portal8:09
Intelligent Performance6:30
Database Console Commands for SQL Server2:20
Azure Site Recovery4:31
Monitoring with Dynamic Management Views (DMVs)3:31
DMVs are virtual tables that expose server state information in a structured manner, allowing database administrators to monitor and troubleshoot SQL Server instances. The lecture will cover the structure and usage of DMVs, and how they can be leveraged to gain insight into server health, performance, and resource utilization.
Introduction to Azure SQL Query Store8:05
Performance Tuning with Indexes19:34
Monitoring and Resolving Blocking8:05
Blocking

Requirements

Knowledge of database objects would be great but not required.

Description

The Microsoft Certified: Azure Database Administrator Associate course is designed for individuals who want to gain expertise in managing and maintaining cloud-based databases using Microsoft Azure. This course provides a comprehensive understanding of database management in Azure and prepares students for the Azure Database Administrator Associate certification exam.

The course covers the following topics:

Introduction to Azure Databases: This section provides an overview of Azure databases and their benefits. Students will learn about different types of databases available in Azure, such as Azure SQL Database, Azure Database for MySQL, and Azure Database for PostgreSQL.
Designing and Implementing Azure Databases: This section covers the design and implementation of Azure databases. Students will learn how to create and configure databases, implement security measures, and optimize database performance.
Monitoring and Optimizing Azure Databases: This section covers techniques for monitoring and optimizing Azure databases. Students will learn how to use Azure Monitor to track database performance, implement backup and recovery strategies, and manage database growth.
Managing and Maintaining Azure Databases: This section covers the day-to-day management and maintenance of Azure databases. Students will learn how to manage database users and permissions, troubleshoot common issues, and implement disaster recovery measures.

Upon completion of the course, students will have a thorough understanding of managing and maintaining Azure databases and be prepared to take the Microsoft Certified: Azure Database Administrator Associate certification exam. This certification validates the student's skills in implementing and managing databases in Azure and demonstrates their expertise in cloud-based database administration.

Who this course is for:

SQL Server DBA
Aspiring DBAs
Microsoft DP300 students
Cloud Engineers

Complete Microsoft Azure SQL Server Database Administration

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Getting Started with Azure SQL5 lectures • 25min

Deploy and configure servers, instances, and databases for Azure SQL6 lectures • 33min

Configure database authentication and authorization7 lectures • 42min

Implement compliance controls for sensitive data5 lectures • 34min

Protect data in-transit and at rest and in-transit4 lectures • 23min

Deploy highly available solutions by using Azure SQL4 lectures • 25min

Migrating to Azure5 lectures • 32min

Performance & Monitoring with Azure SQL8 lectures • 1hr 1min

Automation & Maintenance3 lectures • 13min

Requirements

Description

Who this course is for: