Querying Data with Microsoft Transact-SQL

Descrizione del corso

This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

Programma

Module 1: Getting Started with Transact-SQL

• Introduction to Transact-SQL
• Using the SELECT statement

Module 2: Sorting and Filtering Query Results

• Sorting query results
• Filtering the data

Module 3: Using Joins and Subqueries

• Using JOIN operations
• Using subqueries

Module 4: Using Built-in Functions

• Getting started with scalar functions
• Grouping aggregated results

Module 5: Modifying Data

• Inserting data into tables
• Modifying and deleting data