Educational SQL resources

Tutorials, quickstarts, and other educational resources meant to teach you to work with SQL Server and Azure SQL Database.

Learn SQL

Training

• Azure SQL for beginners
• Azure SQL fundamentals
• Azure SQL hands-on labs
• Azure SQL bootcamp
• LinkedIn Learning
• Pluralsight

SQL Server

Training

• Upgrade SQL Server
• Use the Query Tuning Assistant
• SQL Server workshops

Quickstart

• Connect & query with Azure Data Studio
• Connect & query with SSMS
• Writing Transact-SQL (T-SQL)
• Extended events
• Backup & restore on-premises
• Backup & restore to Azure Blob Storage

Tutorial

• Availability group
• Transactional replication
• Merge replication
• Create in-memory table
• Sign stored procedure with certificate
• Azure Blob Storage
• Database tuning advisor

Architecture

• Index architecture & design
• Pages & extents architecture
• Post migration validation & optimization
• Query processing Architecture
• Thread & task architecture
• Transaction log architecture
• Transaction locking & row versioning
• Memory management architecture

SQL Server on Azure VM (IaaS)

Quickstart

• Create VM with portal
• Create VM with PowerShell

How-To Guide

• Register with resource provider
• Configure availability group with Az CLI
• Create FCI using premium file share
• Use Azure Storage for backup & restore

Azure SQL Database (PaaS)

Training

• Choose data storage approach
• Secure SQL Database
• Geographically distributed app
• ASP.NET App to query SQL Database

Quickstart

• Create DB with portal or code
• Create DB with template
• Configure Server-level IP firewall rules

Tutorial

• Migrate using Azure Database Migration Service
• Add single DB to a failover group
• Add elastic pool to a failover group
• Configure active geo-replication
• Configure security

SQL Server on Linux

Training

• Introduction
• Deploy
• Automatically tune
• Containers

Quickstart

• Red Hat
• SUSE
• Ubuntu
• Containers
• On Azure

Tutorial

• Migrate from Windows
• Migrate to Linux containers
• Create a job
• Setup Active Directory authentication
• Configure FCI
• Deploy a Pacemaker cluster
• Create & configure availability group
• Deploy container cluster on Azure
• Configure replication

Azure SQL Managed Instance (PaaS)

Quickstart

• Create instance with portal
• Create instance with PowerShell
• Create instance pool
• Configure public endpoint
• Connect a client VM
• Configure point-to-site connection
• Restore database backup

Tutorial

• Migrate using Azure Database Migration Service
• Configure transactional replication
• Add to a failover group
• Migrate on-premises users and groups
• Configure security