By using our website you agree to our use of cookies.

Querying SQL Databases using T-SQL

2 Day Course
Official Microsoft Curriculum
Code QATSQL

Book Now - 3 Delivery Methods Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online

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.

View detailed Course Modules

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

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
  • 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 Jun Jul Aug Sep Oct Nov
QATSQL
Virtual Classroom (Virtual On-Line)
2 Days $2,315
15-16
Next 6 Months
Microsoft SQL Server Training Courses

Course PDF

Print

Share this Course

Share

Recommend this Course

Sections