Querying SQL Databases using T-SQL

2 Day Course
Official Microsoft Curriculum
Code QATSQL

Book Now - 2 Delivery Methods Available:

Scheduled Online Onsite

Overview

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.

Modules

Hide 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
  • GROUP BY
  • HAVING

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

Prerequisites

  • 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.

Pricing

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 Feb Mar Apr May Jun Jul
QATSQL
Attend From Anywhere
2 Days $2,345
12-13
QATSQL 2 Days $2,345
QATSQL
Bristol (Castlemead)
2 Days $2,345
QATSQL 2 Days $2,345
QATSQL
Leeds (City Exchange)
2 Days $2,345
15-16
QATSQL 2 Days $2,345
12-13
QATSQL
Manchester (Oxford St)
2 Days $2,345
01-02
QATSQL 2 Days $2,345

or call:408-759-5074

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections