Contact Details
902-292-9899
info@dcatt.ca
Querying Data with Microsoft Transact-SQL
Course Number:
DP-080T00
Days:
2
Price:
$1,195.00
Course Description
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 Topics
Module 1: Getting Started with Transact-SQL
Module 2: Sorting and Filtering Query Results
Module 3: Using Joins and Subqueries
Module 4: Using Built-in Functions
Module 5: Modifying Data