Overview
-
Discover how to leverage the vast capabilities of Azure SQL Database. Learn how to work with the rich syntax of Azure SQL and use SQL Server Management Studio to write scripts.
Syllabus
-
Introduction
- Introduction
- What you should know
- Instructions on how to use exercise files
- Create a new Azure subscription
- Create a new Azure SQL database
- Configure the Azure SQL Server firewall
- Connect with SQL Server Management Studio
- Create a new SSMS project
- CREATE TABLE (..., ...)
- SELECT * FROM
- INSERT
- SELECT, WHERE
- ALTER TABLE ADD
- SELECT, WHERE
- UPDATE
- DELETE
- ALTER TABLE ADD
- SELECT FROM
- SELECT FROM
- Numbers
- Text
- CREATE TABLE (..., ...)
- INSERT waterfalls
- SELECT, INNER JOIN, ON
- SELECT, OUTER JOIN, ON
- Formatting results
- Filtering results
- Calculations with GROUP BY
- ORDER BY
- Create a view to store a query
- CREATE USER
- Azure portal tasks
- Next steps
