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.
- 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
- Subqueries in WHERE: Which Orders Beat the Average?Free
- IN, EXISTS and the NOT IN Trap: One NULL That Returns Nothing Locked
- Correlated Subqueries: Above the Customer's Own Average & the Latest Order Locked
- CTEs Step by Step: Three Helper Tables, Each Checked Before the Next Locked
- UNION vs UNION ALL: Stacking Two Exports and Removing Duplicate Rows Locked
- INTERSECT and EXCEPT: Rows in Both Lists, Only in A, Only in B Locked
- Self-Joins and Date Spines: Managers, Reporting Levels & Zero-Filled Days Locked
- Mid-course project: NULL Logic, COALESCE and a Monthly Report That Reconciles Locked
- Subqueries in SELECT and FROM: Each Customer's Share and a Filter on a Derived Table Locked
- WHERE vs HAVING: Filtering Rows Before and Groups After the Sum Locked
- ANY and ALL: Comparing a Row with Every Value of a Subquery Locked
- Join Fan-Out: Why a Join Inflates the Revenue and How to Pre-Aggregate Locked
- CASE and Conditional Aggregation: Size Buckets and a Pivot Without PIVOT Locked
- Counting Right: COUNT(*), COUNT(column), COUNT(DISTINCT) and AVG with NULLs Locked
- Recursive CTEs: Walking a Parts List Level by Level Locked
- CROSS JOIN: Every Store × Every Product and the Combinations Never Sold Locked
- Relational Division: Customers Who Bought Every Product of a Set Locked
- Range Joins: Matching Each Order to the Price Valid on Its Date Locked
- Testing a Query: Duplicate Keys, Orphan Rows and Totals That Must Match Locked
- Final Project: A Customer Status Report from Five Query Steps Locked
Learner reviews
Be the first to review this course.