Azure SQL Server for Beginners part 2 of 2

Name: Azure SQL Server for Beginners part 2 of 2
Rating: 4.6 (417 reviews)

Azure part 2

Created byRaphael Asghar

Last updated 3/2021

English

What you'll learn

This is Azure SQL Server for Beginners part 2 of 2.
The students will learn how to manage Azure SQL database family technology on Azure cloud platform. The Azure SQL database consists of databases, virtual machines, managed instances, and elastic pool databases.
They will learn how to design, configure, manage, navigate, and deploy SQL database in the cloud. This leading technology will make the student who is interested in the SQL dba career path far more attractive to companies and recruiters.
This is a continuation from Azure SQL Server for Beginners part 1 of 2.
In Azure part 2, we continue to learn about Azure SQL database and tackle issue such as security, auditing, geo replication, HA solutions such as always on, diagnostics, monitoring of Azure database, setting up linked servers, and creating elastic jobs and much more

Course content

1 section • 46 lectures • 10h 45m total length

Introduction3:37
SQL SERVER AND DATABASE LEVEL SECURITY PART 117:26
SQL SERVER AND DATABASE LEVEL SECURITY PART 210:39
VIRTUAL NETWORK SQL SECURITY26:19
AD AUTHENTICATION SECURITY9:13
Learn to create Azure Active Directory users and use MFA for secure access to Azure SQL Server, comparing Azure AD logins with traditional SQL authentication.
AZURE LOGINS ROLES AND PERMISSIONS13:43
Learn to create logins and users to access Azure sql server and databases, assign server and database roles (login manager, db manager), and map logins to master and user databases.
AZURE LOGINS ROLES AND USERS26:07
AZURE ACTIVE DIRECTORY LOGIN10:02
TRANSPARENT DATA ENCRYPTION16:42
Discover how transparent data encryption (TDE) protects data at rest in Azure SQL databases and managed instances by encrypting the database and backups with a DEK, master key, and certificate.
TRANSPARENT DATA ENCRYPTION13:44
DATA MASKING14:23
AUDITING19:26
Enable auditing at server and database levels to capture events in audit logs. Analyze logs with preconfigured reports to spot suspicious activity and policy violations.
ALERTS8:30
AZURE SECURITY CENTER16:22
Discover how Azure Security Center provides unified security management for Azure SQL databases, virtual machines, and other resources, with Azure Defender for SQL and actionable recommendations to harden your environment.
SQL LOCKS5:54
SQL DATABASE GEO REPLICATION26:37
SQL DATABASE GROUP GEO REPLICATION24:06
SQL ELASTIC DATABASE WITH GEO REPLICATION12:59
ACTIVE SITE RECOVERY6:54
ACTIVE SITE RECOVERY DEMO33:49
Create a virtual machine and enable replication to a secondary region, then perform test failover and commit recovery points to demonstrate Azure Site Recovery for disaster recovery.
AZURE SQL SERVER ALWAYS ON PART 16:51
AZURE SQL SERVER ALWAYS ON PART 22:47
AZURE SQL SERVER ALWAYS ON PART 310:41
AZURE SQL SERVER ALWAYS ON PART 415:27
Join two SQL Server VMs to the domain, run services as a domain user, enable Always On, configure ports 1433, 5022, 5888, and apply firewall rules.
AZURE SQL SERVER ALWAYS ON PART 56:54
AZURE SQL SERVER ALWAYS ON PART 66:52
Create an Azure SQL Server Always On cluster by validating two nodes with Failover Cluster Manager and configuring the Availability Group, preparing for a future failover test.
AZURE SQL SERVER ALWAYS ON PART 719:56
AZURE MONITORING PART 116:03
Master proactive Azure monitoring for SQL databases and VMs by configuring alerts, dashboards, and diagnostics using DMVs, Log Analytics, and query performance insights.
AZURE MONITORING PART 217:43
AZURE MONITORING GRAPHS7:10
AZURE MONTORING DMVS33:44
Explore monitoring Azure SQL databases and managed instances with dynamic management views. Use resource stats and stress testing to identify CPU, memory, and IO performance issues.
AZURE DATABASE DIAGNOSTIC MONITORING9:16
SETTING UP MONITORING SQL DIAGNOSTIC PART 110:28
Set up Azure SQL Analytics to monitor SQL databases, elastic pools, and managed instances across subscriptions by configuring diagnostic settings, Log Analytics workspace, and resource groups.
SETTING UP MONITORING SQL DIAGNOSTIC PART 222:38
SETTING UP MONITORING SQL DIAGNOSTIC PART 310:57
CREATE ELASTIC JOBS15:14
Learn to create elastic jobs in Azure SQL database and distinguish from elastic pools. Use elastic job agent, target groups, and steps with T-SQL or PowerShell to run across servers.
CREATE ELASCTIC JOB PART 226:16
LINKED SERVERS9:38
Learn to connect on-premises sql server to an azure sql database using linked servers with a 64-bit odbc connection, create an odbc data source, and query azure data.
ELASTIC QUERIES18:44
AD AUTHENTICATION SECURITY SANDBOX3:38
This lecture guides you through a self-directed Azure SQL sandbox to test your ability to follow instructions, configure firewall rules, and implement Active Directory authentication and permissions.
SCENARIO 16:24
SCENARIO 25:19
SCENARIO 3 PART 19:04
SCENARIO 3 PART 215:01
Learn how to migrate on-premises databases to Azure elastic pools using the data migration assistant, configure pricing, and deploy two SQL databases.
SCENARIO 417:32
Migrate on-premises SQL databases to an azure virtual machine with sql server, using a storage account and url backups, while retaining control of the windows operating system.
END OF COURSE WHAT NEXT4:18
Wrap up part two of Azure SQL for beginners by reviewing on-premises setups, Azure IaaS and PaaS options, backups, security, and monitoring. Practice repeatedly to build mastery today.

Requirements

It is highly recommended that the student takes the following prerequisites courses: Learn T-SQL, SQL administration part 1, SQL administration part 2, and SQL administration part 3, as the course assumes the student I well aware of SQL Server administration.

Description

When the student has completed the following course ‘Azure SQL Server for Beginners part 1 of 2’ and has completed the subject matter such what is azure SQL databases, option for selecting the best model to fit your company needs, pricing tiers, resource consumption models, securing your azure database, migrating your database and virtual machines from on premises to azure cloud, migration options, firewall rules, setting up disaster recovery modes, Geo replicating your servers and databases across the globe; we will continue to learn in Azure part 2, such subjects as security, firewall rules, auditing databases, monitoring databases, examining performance metrics of databases, creating HA solution such as always on, creating elastic jobs, and setting up linked servers and much more. The student will get first hand exposure to a technology that is revolutionizing the way the SQL dba performs his job. With this knowledge, the SQL dba is positioning himself/herself at the front line with market being so competitive. Getting hands on knowledge on how to manage and migrate database from your on-premises to the azure cloud is a demanding field that every SQL dba needs to know. Having this experience in azure cloud technology will enable the student to not only work on azure platform, but will give him the opportunity to see the working of other cloud technologies such as AWS;

Who this course is for:

The course is targeted to those students that have taken the following prerequisites courses: Azure SQL Server for Beginners part 1 of 2, Learn T-SQL, SQL administration part 1, SQL administration part 2, and SQL administration part 3; and is ready to learn and manage SQL database on Azure cloud platform.