Learning Azure SQL Querying

Go to class
Write Review

Free Online Course: Learning Azure SQL Querying provided by LinkedIn Learning is a comprehensive online course, which lasts for 2-3 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Learning Azure SQL Querying is taught by Anton Delsink.

Overview
  • Discover how to leverage the vast capabilities of Azure SQL Database. Learn how to work with the rich syntax of Azure SQL and use SQL Server Management Studio to write scripts.

Syllabus
  • 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 query
    6. Azure SQL Tasks
    • CREATE USER
    • Azure portal tasks
    Conclusion
    • Next steps