DP-080T00 Data Analyst

Querying Data with Microsoft Transact-SQL

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 and, Azure Synapse Analytics.

Prerequisites

Participants should have a basic understanding of relational databases before taking this course.

Course Modules

1. Getting Started with Transact-SQL
2. Sorting and Filtering Query Results
3. Using Joins and Subqueries
4. Using Built-in Functions
5. Modifying Data