Learning Azure SQL Querying
1h 25mBeginner2023-05-12
Authors
Jeremy Villeneuve
Founder of Halvanta, LLC, an IT consulting firm
Course details
Azure SQL allows you to go live within minutes, using a cloud-hosted database. It provides a great way to begin your journey of learning SQL for data processing and analytics. In this course, Jeremy Villeneuve guides you through the process of getting started. Jeremy goes over what SQL is, as well as common statements and differences in SQL engines. He presents an Azure SQL quick start guide, then shows you how to create new records using the Azure Query Editor. Jeremy explains how to read data in Azure SQL database records, as well as how to update existing data. Each chapter in this course includes a challenge and sample solution, so you can test your understanding of what you learn.
Skills covered
Desktop DatabasesDatabase DevelopmentDatabase ManagementAzureNetwork AdministrationCloud PlatformsLearningNetwork and System AdministrationCloud ComputingBusiness Software and ToolsMicrosoftSoftware Development
Concepts
Introduction
- Azure SQL for learning SQL fast
What Is SQL
- What are tables, rows, and columns
- The most common SQL statements
- Differences in SQL engines
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
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
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
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