Getting Started with Azure SQL Querying

Course details

Discover how to use Structured Query Language (SQL) to tackle the often highly complex task of working with databases. Join Anton Delsink as he shows how to leverage the vast capabilities of modern database management systems such as Microsoft Azure SQL Database, and work effectively with the rich syntax of T-SQL with Azure SQL databases. After explaining how to create a new Azure SQL database and connect with SQL Server Management Studio, Anton explains how to create tables and add data to those tables. He also explains how to combine data in queries from multiple tables. After you wrap up this course, you'll be prepared to create your own database, share access to your database with other users, and create and query tables.

Learning objectives
Creating a new Azure SQL database
Using basic SQL statements such as SELECT and INSERT
Using SQL statements to update, modify, and delete data
Adding functions to your SELECT statement to modify how numbers are displayed
Filtering and formatting results
Saving and sharing your work by creating views
Sharing access to your database with other users

Skills covered

SQL ServerDatabase AdministrationDatabase DevelopmentDatabase ManagementAzureData AnalysisNetwork AdministrationCloud PlatformsLearningProgramming LanguagesNetwork and System AdministrationCloud ComputingData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftSoftware Development

Concepts

Introduction

Introduction
What you should know
Instructions on how to use exercise files

Create a New Azure SQL Database

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

One Table

CREATE TABLE table1 (, )
SELECT FROM table1
INSERT
SELECT, WHERE
ALTER TABLE table1 ADD column
SELECT, WHERE
UPDATE
DELETE

Data Types

ALTER TABLE table1 ADD column
SELECT not star FROM table1
SELECT data conversion FROM table1
Numbers
Text

Two Tables

CREATE TABLE table2 (, )
INSERT waterfalls
SELECT, INNER JOIN, ON
SELECT, OUTER JOIN, ON
Formatting results
Filtering results

Aggregates, Sorting, and Views

Calculations with GROUP BY
ORDER BY
Create a view to store a query

Azure SQL Tasks

CREATE USER
Azure portal tasks

Conclusion

Next steps