Introduction
  • Welcome to Subquery Magic
  • What is a Subquery?
Setup your own Learning Lab
  • Download SQL Server
  • Install SQL Server
  • Download and Install SQL Server Management Studio
  • Download Sample Database Backups
  • Restore Sample Database
Writing your First Subquery
  • Place a subquery in the column list
  • Incorporate Subqueries into Expressions
  • Review subquery concepts
Create Correlated Subqueries
  • Demystify Correlated Subqueries
  • Write a Correlated Subquery with Two Tables
  • Do you have any questions?
  • Correlated subqueries versus Inner Joins, which is better?
  • Get some Correlated Subquery Reinforcement
Create Subqueries in the WHERE and HAVING Clauses
  • Get Existential with Exists
  • Are you in? Use the IN Condition to Test for Membership
  • Write subqueries in the HAVING clause
  • Get fancy and write a correlated subquery in the HAVING clause
  • Review Subqueries in the Where and Having Clause
Write Queries using Derived Tables
  • What is a Derived Table?
  • Joining Derived Tables
  • Review Derived Tables
  • Bonus Lecture: Additional Resources and Course Coupons?