Querying SQL Databases using T-SQL

2 Day Course
Official Microsoft Curriculum

Book Now - 3 Delivery Methods Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online


This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures.

This course will benefit IT Professionals who will be writing queries for use with Microsoft SQL Server 2005, 2008 or 2012. Non-technical 'power users' will also benefit from the course if they are comfortable using sophisticated software tools like SQL Server Management Studio.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Collapse all

Introduction to T-SQL (2 topics)

  • Familiarize yourself with SSMS
  • Introduction to the Query Editor

Retrieving Data (2 topics)

  • Basic Select statements
  • Using expressions in Select lists

Filtering Rows (5 topics)

  • Basic equality filters
  • Basic comparisons
  • Logical comparisons
  • String comparisons
  • NULL comparisons

Sorting Returned Rows (4 topics)

  • Basic sorting
  • Sorting on expressions
  • Unique rows
  • Limiting results

Grouping and Aggregating Data (3 topics)

  • Single aggregates

Using Multiple Tables (3 topics)

  • Inner joins
  • Outer joins
  • Unions

Using Views and Stored Procedures (2 topics)

  • Using views
  • Using stored procedures

Common Functions (4 topics)

  • Text functions
  • Date functions
  • NULL functions
  • Formatting dates


  • There are no technical pre-requisites for this course and it assumes no prior knowledge of SQL Server.
  • The course is aimed at both non-technical 'power users' and IT Professionals who will be writing queries for use with Microsoft SQL Server.

Scheduled Dates

Please select from the dates below to make an enquiry or booking.


Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.

Code Location Duration Price Oct Nov Dec Jan Feb Mar
Virtual Classroom (Virtual On-Line)
2 Days $2,105

Course PDF


Share this Course


Recommend this Course