Azure Sql Database Service

Azure SQL Database service

What you'll learn

Learn how to manage Azure SQL database service

Learn how to work with SQL databases

Learn how to secure your SQL databases

Learn how to create, update, delete SQL database and manage with other Azure resources

Requirements

This course is for beginners, Azure cloud administrators, students who want to learn SQL in Azure and IT lovers

Description

This course is intended for beginners, Azure cloud administrators, Az-305 exam preparers, and all Azure or IT enthusiasts. In this course you will learn to create, deploy and work with Azure SQL service, all through many demos, exercises and examples. Also, in the other lessons, apart from the demo, you will have the opportunity to learn a lot. Before each demo, there are lessons in which all the concepts are explained or tried to be explained in detail, in order to make it easier to understand everything that is mentioned in the examples shown in the demos and videos. SQL Database enables you to easily define and scale performance within two different purchasing models: a vCore-based purchasing model and a DTU-based purchasing model. SQL Database is a fully managed service that has built-in high availability, backups, and other common maintenance operations. Microsoft handles all patching and updating of the SQL and operating system code. You don't have to manage the underlying infrastructure.  There are also additional lessons that will help you better learn and understand working with the Azure SQL database service and other Azure resources. This is of fundamental importance if you want to continue your journey towards Azure certifications, but the understanding itself is enough towards your complete mastery of this service.

Overview

Section 1: Introduction - instructor, the course structure and the Azure platform

Lecture 1 About me

Lecture 2 Introduction

Lecture 3 What is Azure?

Lecture 4 Azure certifications and exam

Lecture 5 How to create Azure free account?

Lecture 6 Tour'd'Azure

Lecture 7 Azure free services

Section 2: Azure SQL database service

Lecture 8 What is the Azure SQL database service?

Lecture 9 What is Iaas, Paas and Saas?

Lecture 10 Why choose Azure SQL service in Azure?

Lecture 11 Azure SQL database deployment types

Lecture 12 Azure Iaas vs Paas offering

Lecture 13 Iaas vs Managed Instance

Lecture 14 SQL server Paas deployment options

Lecture 15 SQL server on Azure VM

Lecture 16 SQL server in Azure VM - demo

Lecture 17 Azure SQL single database

Lecture 18 Purchasing models and service tiers

Lecture 19 Azure database vs Azure Data Warehouse

Lecture 20 Azure Elastic pool option

Lecture 21 Azure Elastic pool - demo

Lecture 22 Azure Managed Instance

Lecture 23 Difference between MI on-premise and Azure MI

Lecture 24 Migration options for Managed Instance

Lecture 25 Service tiers for Managed Instance

Lecture 26 Azure Managed Instance - demo

Lecture 27 Azure MI management operations

Lecture 28 Azure SQL database security options

Lecture 29 Encryption - data in rest, motion and in use

Lecture 30 Dynamic data masking

Lecture 31 Dynamic data masking - demo

Lecture 32 Always encrypted options

Lecture 33 Always encrypted options - demo

Lecture 34 High availability and disaster recovery options

Lecture 35 RTO vs RPO

Lecture 36 Azure SQL database - HA and DR options

Lecture 37 Azure SQL database - backup and restore

Lecture 38 Azure SQL database - point-in-time-restore

Lecture 39 Azure SQL database - long-term-retention

Lecture 40 Azure SQL database - geo-restore from backup

Lecture 41 Azure SQL database - restore deleted DB

Lecture 42 Azure SQL database - scaling

Lecture 43 Azure SQL database - scaling demo

Lecture 44 Monitoring Azure SQL database from Azure portal

Lecture 45 Inteligent monitoring and automatic tunning

Lecture 46 Query performance insinght

Lecture 47 Geo-replications and failover groups

Lecture 48 Compatibility and integration

Section 3: Additional lectures - Azure SQL database

Lecture 49 Explaining and installing SSMS and ADS

Lecture 50 Azure Data Studio and MySQL - demo

Lecture 51 SQL server on Azure VM - backup - demo

Lecture 52 Azure SQL database vs Powershell, Azure CLI, Bicep and Terraform

Lecture 53 How to install and create a MySQL table on Linux VM?

Lecture 54 Database migration with ADS

Lecture 55 Closing the chapter

Azure beginners, Azure cloud administrators, Azure and IT lovers