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