PASS Summit West 2026, November 9-11|Register now

Redgate Hub

University

TSQL for Beginners: Week 2 (Solutions for SELECT Homework and Intro to JOINS)

In this second session of the course, we go through sample solutions for the homework on SELECT and ALIAS. Then we explain inner, outer, and cross joins in SQL Server. A timeline for the video is below if you'd like to jump to specific topics.

  • 00:52 Overview of the course files on GitHub
  • 01:30 View of the Azure Data Studio Jupyter notebook as it displays in GitHub
  • 03:25 Using the WideWorldImporters database
  • 03:40 Solution to Question 1 in 2_SelectAndAlias_Solutions.sql
  • 05:11 What execution plans are and why I'm showing you some
  • 08:40 the sp_help procedure, and why it's useful
  • 10:00 Computed Columns
  • 12:30 Solution to Question 2 in 2_SelectAndAlias_Solutions.sql
  • 15:25 Solution to Question 3 in 2_SelectAndAlias_Solutions.sql (and the controversy of NULLS, with an overview of NVARCHAR for good measure)
  • 22:54 ANSI NULLS and why you shouldn't turn it off
  • 24:44 Solution to Question 4 in 2_SelectAndAlias_Solutions.sql
  • 28:00 Solution to Question 5 in 2_SelectAndAlias_Solutions.sql
  • 30:23 Solution to Question 6 in 2_SelectAndAlias_Solutions.sql and a discussion of collation
  • 37:31 Solution to Question 7 in 2_SelectAndAlias_Solutions.sql and an intro to ORDER BY
  • 41:52 Solution to Question 8 in 2_SelectAndAlias_Solutions.sql with intro to OFFSET and FETCH
  • 44:19 Demo that your TSQL syntax generally doesn't determine a specific execution plan
  • 46:19 Solution to Question 9 in 2_SelectAndAlias_Solutions.sql
  • 49:40 Review of where column aliases DON'T work
  • 51:22 JOINs discussion begins here!
  • 53:00 Overview of the joins sample database and an explanation of the Jupyter notebook
  • 54:50 INNER join: matching rows from both tables
  • 59:37 LEFT OUTER join: rows from the 'left' table with matching rows from the 'right' table when present
  • 01:01:48 RIGHT OUTER join: rows from the 'right' table with matching rows from the 'left' table when present
  • 01:04:44 FULL OUTER join: return all rows from each 'side', matching where possible
  • 01:07:18 Simplify our data a bit, and then CROSS JOIN
  • 01:09:40 Recap of the joins and info about homework for next time

This document contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved