1 - Welcome to Subquery Magic (17.99 MB)
2 - What is a Subquery (37 MB)
3 - Should I use SQL Server MySQL or PostgreSQL to Learn Subqueries (27.21 MB)
4 - Using the Pizza DB in this Course (60.89 MB)
5 - Using the Pizza DB with SQL Server (42.43 MB)
6 - Using the Pizza DB with MySQL (34.86 MB)
7 - Using the Pizza DB with PostgreSQL (12.69 MB)
8 - Place a subquery in the column list (27.09 MB)
9 - Incorporate Subqueries into Expressions (38.13 MB)
10 - Demystify Correlated Subqueries (36.58 MB)
11 - Demystify Correlated Subqueries Example (31.55 MB)
12 - Write a Correlated Subquery with Two Tables (27.92 MB)
14 - Correlated subqueries versus Inner Joins which is better (59.11 MB)
15 - Get Existential with Exists (30.88 MB)
16 - Are you in Use the IN Condition to Test for Membership (22.48 MB)
17 - Subquery in the Having Clause (26.44 MB)
18 - Get fancy and write a correlated subquery in the HAVING clause (27.82 MB)
19 - Get fancy and write a correlated subquery in the HAVING clause Part B (22.49 MB)
20 - What is a Derived Table (33.36 MB)
21 - Joining Derived Tables (55.38 MB)