Microsoft Azure Sql Database Administration

Azure SQL Database Administration

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.

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.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Getting Started with Azure SQL

Lecture 2 What is Azure zone & regions?

Lecture 3 Azure SQL deployment options

Lecture 4 Purchasing models, service tiers, and hardware choices

Lecture 5 Getting Started with Azure Free Tier

Lecture 6 Management interfaces: Azure Portal

Section 3: Deploy and configure servers, instances, and databases for Azure SQL

Lecture 7 Introduction

Lecture 8 Deploying Azure SQL Databases

Lecture 9 Exploring SQL Server Management Studio

Lecture 10 Exploring Azure Data Studio

Lecture 11 Deploying SQL Server Managed Instance

Lecture 12 Deploy SQL Server on Azure VM

Section 4: Configure database authentication and authorization

Lecture 13 Introduction

Lecture 14 Authentication with Azure Active Directory

Lecture 15 Configure and Create AAD Users

Lecture 16 Securables and Database Roles

Lecture 17 Managing Security with Firewall Rules

Lecture 18 Granting Permissions on Securables

Section 5: Implement compliance controls for sensitive data

Lecture 19 Introduction

Lecture 20 Data classification and Discovery

Lecture 21 Auditing Azure SQL Databases

Lecture 22 Implement Row Level security

Lecture 23 Microsoft Defender for Cloud

Section 6: Protect data in-transit and at rest and in-transit

Lecture 24 Explore Transparent Data Encryption

Lecture 25 Object encryption and secure enclaves

Lecture 26 Dynamic Data Masking

Lecture 27 Enable encrypted connections

Section 7: Deploy highly available solutions by using Azure SQL

Lecture 28 Backup and restore strategies

Lecture 29 Disaster Recovery

Lecture 30 Restore to Point-in-Time and deleted databases

Lecture 31 High Availability by service tier

Section 8: Migrating to Azure

Lecture 32 Migration using Application Data Tier

Lecture 33 Migration using SQL Package

Lecture 34 Migration using Azure Data Studio

Lecture 35 Migration using Data Migration Assistant

Section 9: Performance & Monitoring with Azure SQL

Lecture 36 Monitoring Using Azure Portal

Lecture 37 Intelligent Performance

Lecture 38 Database Console Commands for SQL Server

Lecture 39 Monitoring with Dynamic Management Views (DMVs)

Lecture 40 Introduction to Azure SQL Query Store

Lecture 41 Performance Tuning with Indexes

Lecture 42 Monitoring and Resolving Blocking

Section 10: Automation & Maintenance

Lecture 43 Introduction

Lecture 44 Azure Automation Account

Lecture 45 Automating Task With Runbooks

Lecture 46 Unsupported Features in Azure SQL

Section 11: Conclusion

Lecture 47 Last Words

SQL Server DBA,Aspiring DBAs,Microsoft DP300 students,Cloud Engineers