Advanced Querying SQL Databases using T-SQL

5 Day Course
Hands On
Code QATSQLPLUS

Book Now - 2 Delivery Methods Available:

Scheduled Online Onsite

Overview

This course will provide more advanced T-SQL knowledge for those who have attended the QATSQL or M20761A courses. This is not a beginner course. For those requiring a basic level of T-SQL for reporting then please review the QATSQL course first.

Target Audience

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

The course is aimed at both non-technical 'power users' and IT Professionals who will be writing queries for use with Microsoft SQL Server.

Please note - Delegates attending an Extended Classroom delivery will need access to a second monitor.

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

Using Table Expressions (4 topics)

  • Using Derived Tables
  • Using Common Table Expressions
  • Using Views
  • Using Inline Table-Valued Functions

Using Set Operators (3 topics)

  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY

Using Window Ranking, Offset, and Aggregate Functions (2 topics)

  • Creating Windows with OVER
  • Exploring Window Functions

Pivoting and Grouping Sets (2 topics)

  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets

Programming with T-SQL (2 topics)

  • T-SQL Programming Elements
  • Controlling Program Flow

Implementing Error Handling (2 topics)

  • Using TRY / CATCH Blocks
  • Working with Error Information

Implementing Transactions (3 topics)

  • Transactions and the Database Engine
  • Controlling Transactions
  • Isolation Levels

Prerequisites

Delegates should have knowledge to the level of the QATSQL or M20761A courses. This is not a beginner course. For those requiring a basic level of T-SQL for reporting then please review the QATSQL course first.

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

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 Nov Dec Jan Feb Mar Apr
QATSQLPLUS
Attend From Anywhere
2 Days $1,775
QATSQLPLUS 2 Days $1,775
QATSQLPLUS 2 Days $1,775
QATSQLPLUS
Manchester (Oxford St)
2 Days $1,775

or call:408-759-5074

Alternatively you can request a callback or schedule a call with a Training Advisor

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections