Complete Microsoft Azure SQL Server Database Administration

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

Mastering Database Management and Security with Azure SQL Server

Created byEmar Morrison, Adrianna Parchment

Last updated 1/2025

English

English [Auto],

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
Explore Azure regions and zones, and how geography and region pairs enable low latency, high availability, and disaster recovery through cross-region replication. Zones provide independently powered data centers for resilience.
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
Explore purchasing models and service tiers for Azure SQL deployments, including DTU and VCore options, and evaluate hardware choices for Azure SQL Database, managed instances, and Azure VMs.
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
Learn to create an Azure Active Directory user on a SQL Server database, enable Azure Active Directory authentication and MFA, and connect as an AD user after granting access.
Securables and Database Roles5:24
Managing Security with Firewall Rules3:11
Learn how to control access to your Azure SQL Database by creating, updating, and deleting firewall rules for specific IP ranges using the portal and T-SQL stored procedures.
Granting Permissions on Securables9:46
Azure Server Roles4:34
Authorize Access to Azure SQL Database with Azure Active Directory

Introduction0:22
Data classification and Discovery8:38
Auditing Azure SQL Databases11:07
Implement Row Level security6:29
Enable row level security in SQL Server to restrict sales order data by the logged-in user, using filter and block predicates with a schema-bound table-valued function and security policy.
Microsoft Defender for Cloud7:05
Explore how Microsoft Defender for Cloud provides cloud security posture management and cloud workload protection across Azure, multi-cloud, and on-premises resources, with continuous analysis, recommendations, and remediation.
Configuring Auditing
Implementing RLS

Backup and restore strategies7:00
Disaster Recovery4:15
Explore disaster recovery for Azure SQL deployments: geo replication to a secondary region, point-in-time restore, and Azure backup for durable retention, with automatic failover for managed instances.
Restore to Point-in-Time and deleted databases7:10
High Availability by service tier6:36
Explore how Azure SQL service tiers and storage models support high availability through automatic failover, replicas, geo-replication, always-on availability groups, and shard-based hyperscale resilience.

Migration using Application Data Tier5:44
Migration using SQL Package7:36
migrate an on-premise database to Azure SQL instance using the SQL package, a cross-platform dotnet tool for export and import via the command line, with validation of the migration.
Migration using Azure Data Studio6:48
Migration using Data Migration Assistant6:24
Azure Migrate4:59
Discover how Azure Migrate simplifies on-premises to Azure SQL migrations, using discovery and assessment, the Data Migration Assistant, and the Database Migration Service to assess compatibility, plan, and minimize downtime.

Monitoring Using Azure Portal8:09
Monitor SQL databases in the Azure portal to track CPU utilization, IO activity, and storage metrics; configure metrics, alerts, and diagnostic settings with the Log Analytics workspace.
Intelligent Performance6:30
Database Console Commands for SQL Server2:20
Explore database console commands (dbcs) across maintenance, miscellaneous, informational, and validation categories to monitor structure, troubleshoot issues, and run dbcc checkdb on Adventureworks for integrity.
Azure Site Recovery4:31
Explore Azure Site Recovery for migrating SQL workloads to Azure, providing continuous replication, near real-time data sync, and rapid failover to a disaster recovery site with minimal downtime.
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
Explore how the query store in SQL Server 2022 captures execution plans and runtime statistics to troubleshoot performance, compare plans, and monitor top resource queries across primary and secondary replicas.
Performance Tuning with Indexes19:34
Monitoring and Resolving Blocking8:05
Blocking

Introduction1:18
Azure Automation Account2:13
Automate routine and complex tasks in Azure by using an Azure Automation Account as a hub to create runbooks, variables, and credentials, schedule workflows, monitor execution, and integrate source control.
Automating Task With Runbooks9:24
Automate Azure SQL tasks with runbooks by building a PowerShell workflow to rebuild indexes nightly, using automation accounts, credentials, variables, and scheduled jobs.

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: