Transact SQL (T-SQL) Training in Vancouver

Transact SQL (T-SQL) Training in Vancouver, Canada

The training is ideal for database professionals, data analysts, and developers seeking to master the querying and programming capabilities of T-SQL.

Enroll Now

Transact SQL (T-SQL) Training is a professional training program delivered by ProgNXT in Vancouver, Canada. ProgNXT, a globally recognized corporate training provider in 55+ countries, offers this Transact SQL (T-SQL) Training course with hands-on, instructor-led sessions. This course provides a comprehensive introduction to Transact-SQL (T-SQL), the proprietary extension of SQL used by Microsoft SQL Server. The...

Expert Panel

Designed and delivered by the ProgNXT Database Management Expert Panel — a vetted team of industry professionals with 15+ years of hands-on experience in MySQL, PostgreSQL, Oracle, and database optimization

ProgNXT Database Management Expert Panel

Course Code: NSW35
21 Hrs
Last Updated: April 2026

Course Rating5/5

This course provides a comprehensive introduction to Transact-SQL (T-SQL), the proprietary extension of SQL used by Microsoft SQL Server. The training is ideal for database professionals, data analysts, and developers seeking to master the querying and programming capabilities of T-SQL. Participants will gain hands-on experience writing queries, managing data, and building stored procedures and functions to support real-world database applications.

Welcome to the official Transact SQL (T-SQL) Training certification program in Vancouver, Canada. This comprehensive training is designed to elevate your professional skills and provide you with practical, industry-relevant knowledge locally. As a globally recognized corporate training provider operating in 55+ countries, ProgNXT ensures that our curriculum meets the highest standards of excellence.

Whether you are looking to upskill your team or advance your personal career, our expert-led sessions will guide you through the core concepts of this domain. Upon successful completion of the 21 Hrs program, participants will receive a globally accepted certification, demonstrating their proficiency and readiness to tackle complex challenges in the field.

Basic knowledge of relational databases
Familiarity with SQL concepts is helpful but not required

Retrieve, filter, and manipulate data using T-SQL
Apply joins, subqueries, and window functions
Automate database tasks with scripts and procedures
Implement transactional control and error handling
Work with views, indexes, and temporary tables

Writing and optimizing T-SQL queries
Understanding SQL Server database architecture
Using joins, subqueries, and set operations
Creating and managing stored procedures and functions
Implementing error handling and transactions
Data filtering, grouping, and aggregation

SELECT queries and filtering data
Joins, unions, and subqueries
Aggregation and grouping
Stored procedures and functions
Transactions and error handling

ProgNXT Certification will be awarded upon successful completion of the training and evaluation.

T-SQL Fundamentals and Query Basics

Introduction to SQL Server and T-SQL

SQL Server architecture overview
Tools for T-SQL (SSMS, Azure Data Studio)

Writing Basic T-SQL Queries

SELECT statements and syntax
Filtering with WHERE clause
Sorting and Aliasing

Data Types and Expressions

Built-in functions (String, Date, Numeric)
NULL handling and expressions

Hands-On Lab

Working with Joins, Aggregations, and Subqueries

Querying Multiple Tables

INNER, LEFT, RIGHT, FULL JOINs
CROSS JOIN and SELF JOIN
Combining Results with UNION, INTERSECT, EXCEPT

Aggregation and Grouping

GROUP BY and HAVING clauses
Using Aggregate Functions (SUM, AVG, COUNT, etc.)

Subqueries and Derived Tables

Scalar and Correlated Subqueries
Using CTEs (Common Table Expressions)

Hands-On Lab

Programming Constructs, Transactions, and Stored Procedures

Programming with T-SQL

Variables and Control-of-Flow Statements (IF, WHILE, CASE)
Error Handling (TRY...CATCH)

Transactions and Concurrency

BEGIN, COMMIT, ROLLBACK
Isolation levels and locks overview

Stored Procedures and User-Defined Functions

Creating and executing procedures
Input/output parameters
Scalar and Table-valued Functions

Hands-On Lab

Participants will receive course materials, slides, reference materials, exercises and access to resources for further learning.

Participants will be evaluated based on:

Daily quizzes, mock questions and query resolution. Participation in hands-on exercises and labs. Performance in the final review and hands-on exercises will be evaluated. ProgNXT Certificate of Completion will be awarded to participants who complete the course and pass the evaluations.

Transact SQL (T-SQL) Training Events in vancouver

Online Events

Global Region	Location	Start Date	End Date	Action
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌

More Upcoming Session Dates

October 2026

📍 Vancouver, Canada

11th Oct 2026→13th Oct 2026

🌐 Online Instructor-Led

11th Oct 2026→13th Oct 2026

📍 Vancouver, Canada

26th Oct 2026→28th Oct 2026

🌐 Online Instructor-Led

26th Oct 2026→28th Oct 2026

November 2026

📍 Vancouver, Canada

8th Nov 2026→10th Nov 2026

🌐 Online Instructor-Led

8th Nov 2026→10th Nov 2026

📍 Vancouver, Canada

27th Nov 2026→29th Nov 2026

🌐 Online Instructor-Led

27th Nov 2026→29th Nov 2026

December 2026

📍 Vancouver, Canada

1st Dec 2026→3rd Dec 2026

🌐 Online Instructor-Led

5th Dec 2026→7th Dec 2026

📍 Vancouver, Canada

28th Dec 2026→30th Dec 2026

🌐 Online Instructor-Led

28th Dec 2026→30th Dec 2026

Events for other courses in Vancouver, Canada

Global Region	Course Name	Start Date	End Date	Action
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌
‌	‌	‌	‌	‌

Transact SQL (T-SQL) Training in Vancouver