Learning T-SQL for Azure Database and Azure Synapse

Starting your journey to learn SQL? Adam gives you some resources to quickly ramp up with T-SQL for Azure SQL Database and Azure Synapse Analytics!

Start Learning T-SQL for Azure Database and Azure Synapse is an Video designed to help beginners learn the basics of T-SQL and how to use it with Azure Database and Azure Synapse. It covers topics such as writing and querying T-SQL statements, creating and manipulating database objects, and using built-in functions and stored procedures.

The video uses a combination of lectures, demonstrations, and hands-on activities to show students how to write T-SQL statements, create tables and views, and use built-in functions and stored procedures. It also provides guidance on best practices for using T-SQL with Azure Database and Azure Synapse.

Resources for SQL Standards

• SQL Standard

[https://en.wikipedia.org/wiki/SQL#Standardization_history/]

• Procedure Extensions - Different SQL bases out there

[https://en.wikipedia.org/wiki/SQL#Procedural_extensions]

• Get Started Querying with Transact-SQL - Learning Path

[https://learn.microsoft.com/training/paths/get-started-querying-with-transact-sql/]

• Transact-SQL reference (Database Engine)

[https://learn.microsoft.com/sql/t-sql/language-reference?view=sql-server-ver16]

• T-SQL Fundamentals (Developer Reference) - Itzik Ben-Gan

amzn.to/3Jd2yHQ [https://amzn.to/3Jd2yHQ]

• Learn T-SQL Querying: A guide to developing efficient and elegant T-SQL code Pedro Lopes / Pam Lahoud

amzn.to/3mriUUm [https://amzn.to/3mriUUm]

More links on about Power Platform/Power BI

• Get started with Azure Synapse Link for Azure SQL Database

Dec 19, 2022 — Learn how to connect an Azure SQL database to an Azure Synapse workspace with Azure Synapse Link.

• T-SQL feature in Synapse SQL pool - Azure - Microsoft Learn

Jan 31, 2023 — Azure Synapse SQL is a big data analytic service that enables you to query and analyze your data using the T-SQL language.

• Tutorial: Write Transact-SQL statements - Microsoft Learn

4 days ago — This tutorial is intended for users who are new to writing SQL statements. It will help new users get started by reviewing some basic statements ...

• Connect to Synapse SQL - Azure - Microsoft Learn

Jan 4, 2022 — Get connected to the Synapse SQL capability in Azure Synapse Analytics. Supported tools for serverless SQL pool. Azure Data Studio is fully ...