The course is organized as modules. Each module combines theory, worked SQL examples, interactive practice, a module exam, and progress tracking.
M00
Module 0: Orientation and SQL Thinking
Learn SQL purpose, result sets, row grain, GreenCart schema reasoning, SQLite sandbox basics, output order, and beginner debugging without course-navigation filler.
M01
Module 1: Database Foundations and the GreenCart Schema
Learn database purpose, table-shaped data, GreenCart entities, SQLite types, keys, relationships, constraints, metadata inspection, and first query-planning habits.
M02
Module 2: Creating Tables and Loading Data
Build a small GreenCart SQLite schema: data types, CREATE TABLE, keys, constraints, INSERT seed rows, load order, reset scripts, and validation queries.
M03
Module 3: SELECT Fundamentals and Result Shaping
Learn to shape one-table result sets with explicit columns, aliases, DISTINCT, sorting, limits, offsets, and calculated columns.
M04
Module 4: Filtering Rows and Handling Missing Data
Learn WHERE filters, comparisons, Boolean logic, ranges, IN, LIKE, NULL predicates, COALESCE fallbacks, exclusions, and filtering debug habits.
M05
Module 5: Functions, Text, Dates, Numbers, and CASE
Transform result values with text functions, concatenation, extraction, rounding, date formatting, duration calculations, and CASE labels.
M06
Module 6: Aggregation and Business Reporting
Turn row-level GreenCart data into counts, totals, averages, grouped reports, HAVING filters, conditional KPIs, and joined business dashboards.
M07
Module 7: Joins and Relationship Queries
Combine related GreenCart tables with inner joins, left joins, anti-joins, self-joins, cross joins, and multi-table relationship paths.
M08
Module 8: Subqueries and Set Operations
Answer layered GreenCart questions with scalar subqueries, IN, EXISTS, derived tables, NULL-safe anti-checks, UNION, INTERSECT, and EXCEPT.
M09
Module 9: Data Changes, Integrity, Views, and Transactions
Move from read-only querying into safe INSERT, UPDATE, DELETE, constraints, foreign keys, schema changes, views, transactions, and savepoints.
M10
Module 10: Performance, Metadata, and Capstone SQL
Close the core course with indexes, query plans, metadata inspection, sargable predicates, debugging, workload thinking, and integrated capstone reporting on the canonical GreenCart schema.
Ready to write your next SQL query?
Start as a guest or sign in to save progress and Daily Challenge tokens.