Querying Data With Transact-SQL

Home > Courses > Querying Data With Transact-SQL

Course Overview

This course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying 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.

Course Objectives

Upon completion of this program, participants should be able to:

Use SQL Server query tools.
Write SELECT statements to retrieve columns from one or more tables.
Sort and filter selected data
Use built-in functions to returned data values.
Create groups of data and aggregate the results.
Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE

Pre-requisite

None

Module 1: Getting Started with Transact-SQL

In this module you will learn about the basics of the Transact-SQL (T-SQL) language, as well as general properties and terminology of relational databases. This module will also introduce the basic SELECT statement for retrieving data from a table.

Introduction to Transact-SQL
Using the SELECT statement

Lab: Get started with SQL Server query tools and writing queries in T-SQL

Module 2: Sorting and Filtering Query Results

Module 3: Using Joins and Subqueries

Module 4: Using Built-In Functions

Module 5: Modifying Data

Not Available

Course Detail

Calendar 2025

8-9 Jan

10-11 Mar

26-27 May

21-22 Jul

29-30 Sep

27-28 Nov

Have Any Question?

If you need further information about this course, please contact: