Learning Azure SQL Querying

Introduction

• Azure SQL for learning SQL fast

1. What Is SQL?

• What are tables, rows, and columns?
• The most common SQL statements
• Differences in SQL engines

2. Azure SQL Quick Start

• 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

3. Create New Records in Azure SQL Database

• 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

4. Understand How to Read Data in Azure SQL Database Records

• 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

5. Update Existing Data in Azure SQL Database Records

• Using an UPDATE statement to change a record
• Deleting your data
• Challenge: Update the product price
• Solution: Update the product price

Conclusion

• Deleting your SQL database