Querying Data with Microsoft Transact-SQL (DP-080)

This course will teach you how to use Transact-SQL to query and modify data in relational databases that are hosted in Microsoft SQL Server-based database systems, including:

Microsoft SQL Server
Azure SQL Database
Azure Synapse Analytics

While the specific Transact-SQL statements supported by these different systems can vary, the majority of techniques described in this course can be used across all of them. Additionally, because Transact-SQL is based on the ANSI standard SQL language, the techniques learned on this course can often be used, with minimal adaptation, on other popular database systems.

This course has been designed to focus on the kinds of queries that are used most commonly. Transact-SQL is a comprehensive language, that includes many advanced capabilities not covered in this course; but you should learn enough to create the queries you need for the most common scenarios, including:

• Using SELECT to retrieve columns from a table
• Sorting and filtering query results
• Using joins and subqueries to retrieve data from multiple tables
• Using built-in functions, aggregations, and groupings
• Inserting, updating, and deleting data