Educational SQL resources
Tutorials, quickstarts, and other educational resources meant to teach you to work with SQL Server and Azure SQL Database.
SQL Server
Training
Quickstart
- 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
SQL Server on Azure VM (IaaS)
Quickstart
How-To Guide
Azure SQL Database (PaaS)
Training
- Choose data storage approach
- Secure SQL Database
- Geographically distributed app
- ASP.NET App to query SQL Database
Quickstart
Tutorial
SQL Server on Linux
Training
Quickstart
Tutorial
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