Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Learning Azure SQL Querying

Video Introducing this tutorial

Introduction

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

1. 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

2. One Table

CREATE TABLE (..., ...)
SELECT * FROM
INSERT
SELECT, WHERE
ALTER TABLE ADD
SELECT, WHERE
UPDATE
DELETE

3. Data Types

ALTER TABLE ADD
SELECT FROM
SELECT FROM
Numbers
Text

4. Two Tables

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

5. Aggregates, Sorting, and Views

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

6. Azure SQL Tasks

CREATE USER
Azure portal tasks

Conclusion

Next steps

You Have Got Gift 25% OFF

Use this Coupon Code “J3JKN396