Azure Sql Database Service
Published 1/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.15 GB | Duration: 5h 58m
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
TurboBit
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!