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.
Overview
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
Taught by
Anton Delsink