Tabellab
Data & Analytics Intermediate

SQL Beyond the Basics in a Spreadsheet: Subqueries, IN & EXISTS, Correlated Subqueries, Step-by-Step CTEs, UNION vs UNION ALL, INTERSECT & EXCEPT, Self-Joins, Date Spines & NULL Logic

Run the queries that come after the basics by hand on fictional shop data: scalar subqueries in WHERE, IN and EXISTS and the NOT IN trap with NULL, correlated subqueries per customer, CTEs as checked helper tables, UNION vs UNION ALL, INTERSECT and EXCEPT, self-joins and date spines, a NULL-safe monthly report, then subqueries in SELECT and FROM, WHERE vs HAVING, ANY and ALL, join fan-out, CASE pivots, COUNT and AVG with NULLs, recursive CTEs, CROSS JOIN grids, relational division, range joins on validity dates and query tests, ending with a five-step customer status report – 20 hands-on labs, with every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course takes SQL beyond SELECT, JOIN and GROUP BY – and lets you run every query by hand in a spreadsheet. In 20 hands-on labs you write scalar subqueries in WHERE, test membership with IN and EXISTS and meet the NOT IN trap with NULL, compare rows with correlated subqueries, split a query into CTE steps, stack results with UNION, compare lists with INTERSECT and EXCEPT, join a table to itself and fill a date spine. Then you go further: subqueries in SELECT and FROM, WHERE versus HAVING, ANY and ALL, join fan-out, CASE pivots, COUNT and AVG with NULLs, a recursive parts list, CROSS JOIN grids, relational division, range joins on price validity dates and the tests to run before trusting a join. The final project is a five-step customer status report. Every cell is checked instantly; all data is fictional.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  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

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy