Virtual and Classroom Training - All our courses are available virtually. We have also started a safe return to classroom training. Click here to learn more.

banner image

Transact SQL (T-SQL) Skills Booster

2 Day Course
course icon

Course Information

Overview

This practical, workshop-style, Transact-SQL (T-SQL) training course is for existing SQL Server T-SQL developers or users who wish to take their existing T-SQL skills to the next level. The course is highly practical in nature. Attendees learn by doing at their own individual pace and the focus throughout is on coding T-SQL by hand. The 'T-SQL Basics Checkup' section at the start of the course is mandatory (attendees must demonstrate their basic skills before progressing to the workshop section of the course). All other listed topics are prioritised by the attendee on a 'Pick and Choose' basis (the tutor may suggest an ideal order of working). On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are made available online for each attendee.

Prerequisites

Introductory level Transact-SQL (T-SQL) skills are required as a prerequisite for this course.

Course Outline

1. T-SQL Basics Checkup
  • Ways of Solving the Problem
  • Finding the Error
  • Dealing with Common Traps
  • Operator Precedence Traps
  • When is a NOT not a NOT?
  • Ready for the Filtering Challenge?
  • An Inner Joins Checkup
  • Aggregates and Grouping up to Scratch?
  • What About Dates?
  • Ready for the Basic Skills Challenge?
2. Beyond the Inner Join
  • Self Joins
  • Embracing Outer Joins: Left, Right and Full
  • Making use of Cross Joins
3. Better Subqueries
  • Ensuring Subqueries Work Every Time
  • Working with Correlated Subqueries
  • Subqueries in SELECT
  • Using Common table Expressions (CTEs)
  • Testing for existence with EXISTS
4. Resolving T-SQL Data Type Issues
  • Know Your T-SQL Data Types
  • Which T=SQL Data Type Is It?
  • Common T-SQL Data Type Traps
  • Converting T-SQL Data Types: Numbers and Strings
  • Converting Dates and Strings
  • Common Date Issues
  • Dealing with NULL Checkup
5. Specific T-SQL Techniques
  • Using T-SQL Views to Simplify your Work
  • T-SQL Set Operations: UNION, INTERSECT and EXCEPT
  • Ranking Results with RANK(), PERCENT_RANK() and DENSE_RANK()
6. Some Advanced T-SQL Techniques
  • Creating Running Totals, Averages and Counts
  • Creating Date Sequences
  • Creating Numeric Sequences
  • Filling in Missing Values
  • Creating Calendar Tables
  • Selecting Random Rows
  • Selecting Every nth Row
  • Handling Duplicates
  • Locating Extreme Values
  • Working with Hierarchies
  • Pivoting Data

Private Courses

We can arrange your own private SQL course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

What Our Clients Think

I took so much away from this course and felt Stuart's teaching method was exceptional.

Rowanne Kiehl - SSE

Very informative course, very useful tips on how to work with SQL Management Studio. A lot of SQL quirks explained, a lot of good examples.

Magdalena Piekarska - Veolia

The trainer did a fantastic job of delivering the course and providing understanding

Niall Simmons - Haven Power

This course was great, the trainer was very knowledgeable and has improved my knowledge considerably. The facilities are fantastic. Thank You!

Kurtis Fleming - HM Revenue & Customs

A great course. The trainers experience and knowledge is a great asset.

Nancy Shering - Equinix Group Ltd

Really good course. lots of hands on practice and clear explanations.

fiona dawe - Covetrus Global Software Services

Related Courses

Public Course Dates Available!

This comprehensive SQL course will teach you the all the basics on extracting data from an SQL database as well as adding data, removing data and creating new databases.

Introductory SQL training for those who need to extract data from and update data in PostgreSQL databases.

Introductory SQL training for those who need to extract data from and update data in MySQL databases.

Introductory SQL training for those who need to extract data from, and update data in, Oracle databases

Introductory T-SQL training for developers or users who need to both extract and modify data stored in SQL Server databases.

Students will learn what SQL is and how it can help them query a database to answer business questions.

SQL training for those who need to both query and modify PostgreSQL data and create PostgreSQL databases and tables.

SQL training for MySQL developers or users who need to both query and modify MySQL data and create MySQL databases and tables.

Introductory to intermediate level Oracle SQL training for developers or users who need to query and modify data stored in Oracle database servers.

Introductory to intermediate level SQL Server-specific Transact-SQL (T-SQL) training for developers or users who need to query and modify data stored in SQL Server.

Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.

Introduction to SQL training for developers or users who need only to extract (not modify) data from PostgreSQL databases.

Introduction to SQL training for developers or users who need only to extract (not modify) data from MySQL databases.

Introduction to SQL training for developers or users who need only to extract (not modify) data from Oracle databases.

Introductory T-SQL training for developers or users who only need to extract (not modify) data stored in SQL Server databases.

Practical skills booster Oracle SQL training for existing Oracle SQL developers or users who wish to take their existing Oracle SQL skills to the next level.

Practical skills booster Transact SQL (T-SQL) training for existing SQL Server T-SQL developers or users who wish to take their existing T-SQL skills to the next level.

PL/SQL training to develop solutions with Oracle's programming objects and procedural extensions.

Procedural programming techniques for SQL Server developers. Conditional Processing, Stored Procedures, User defined Functions, DML Triggers and Error Handling techniques are covered in a highly practical and modular environment.

Practical skills booster ANSI SQL training for existing SQL developers or users who are currently working with data stored in database servers like SQL Server, Oracle, IBM DB2, PostgreSQL and MySQL and who wish to take their existing SQL skills to the next level.

Introductory to intermediate level ANSI SQL training for developers or users who need to query and modify data stored in database servers like SQL Server, Oracle, IBM DB2, PostgreSQL and MySQL.

Introductory ANSI SQL training for developers or users who only need to extract (not modify) data stored in database servers like: SQL Server, Oracle and MySQL.

Practical Introductory ANSI SQL training for developers or users who need to query and modify data stored in database servers like SQL Server, Oracle and MySQL.