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

This course is guaranteed to start and therefore will always take place.

In this course you will learn how to use Transact-SQL to query and modify data in relational Microsoft SQL Server based database systems:

• Microsoft SQL Server
• Azure SQL database
• Azure Synapse Analytics

While specific Transact-SQL statements supported by these different systems may differ, you can use most of the techniques covered in this course for anything. Because Transact-SQL is based on the SQL ANSI standard, you can apply the techniques taught in this course to other popular database systems.
This course focuses on the queries that are most commonly used. Transact-SQL is a comprehensive language with many advanced capabilities not covered in this course, with the topics covered in this course you will learn the most common scenarios including:

• Use SELECT to retrieve columns from a table
• Sort and filter search results
• Use joins and subqueries to retrieve data from multiple tables
• Use built-in functions, aggregations, and groupings
• Insert, update and delete data

In order to be able to cover all the material properly, to be able to complete the exercises and based on feedback from previous students, we have adjusted the standard duration of the course from two to three days.