Begin learning SQL across all business roles, including developers and IT admins, plus get an introduction to the basics of working with a production cloud database.
Overview
Syllabus
Introduction
- Azure SQL for learning SQL fast
- What are tables, rows, and columns?
- The most common SQL statements
- Differences in SQL engines
- Create an Azure account
- Azure free services
- Create an Azure SQL Database
- Connect with the Azure Query Editor
- Challenge: Whitelist an IP address
- Solution: Whitelist an IP address
- Navigating the sample database with Azure Query Editor
- Common data types in SQL
- Stay unique with identity columns
- Inserting new data into a table
- Challenge: Insert a new product
- Solution: Insert a new product
- Selecting your new record
- Using conditional statements to only get the data you need
- Sorting your data in SQL with the ORDER BY clause
- Joining together multiple tables for increased query results
- Challenge: Get products by price with the WHERE clause
- Solution: Get products by price with the WHERE clause
- Using an UPDATE statement to change a record
- Deleting your data
- Challenge: Update the product price
- Solution: Update the product price
- Deleting your SQL database
Taught by
Anton Delsink
