Tabellab

Lessons in this course

  1. Subqueries in WHERE: Which Orders Beat the Average?LabFree
  2. IN, EXISTS and the NOT IN Trap: One NULL That Returns NothingLab Locked
  3. Correlated Subqueries: Above the Customer's Own Average & the Latest OrderLab Locked
  4. CTEs Step by Step: Three Helper Tables, Each Checked Before the NextLab Locked
  5. UNION vs UNION ALL: Stacking Two Exports and Removing Duplicate RowsLab Locked
  6. INTERSECT and EXCEPT: Rows in Both Lists, Only in A, Only in BLab Locked
  7. Self-Joins and Date Spines: Managers, Reporting Levels & Zero-Filled DaysLab Locked
  8. Mid-course project: NULL Logic, COALESCE and a Monthly Report That ReconcilesLab Locked
  9. Subqueries in SELECT and FROM: Each Customer's Share and a Filter on a Derived TableLab Locked
  10. WHERE vs HAVING: Filtering Rows Before and Groups After the SumLab Locked
  11. ANY and ALL: Comparing a Row with Every Value of a SubqueryLab Locked
  12. Join Fan-Out: Why a Join Inflates the Revenue and How to Pre-AggregateLab Locked
  13. CASE and Conditional Aggregation: Size Buckets and a Pivot Without PIVOTLab Locked
  14. Counting Right: COUNT(*), COUNT(column), COUNT(DISTINCT) and AVG with NULLsLab Locked
  15. Recursive CTEs: Walking a Parts List Level by LevelLab Locked
  16. CROSS JOIN: Every Store × Every Product and the Combinations Never SoldLab Locked
  17. Relational Division: Customers Who Bought Every Product of a SetLab Locked
  18. Range Joins: Matching Each Order to the Price Valid on Its DateLab Locked
  19. Testing a Query: Duplicate Keys, Orphan Rows and Totals That Must MatchLab Locked
  20. Final Project: A Customer Status Report from Five Query StepsLab Locked