MODULE 2 · 12 lessons · 12 challenges

SQL Assertion Test Suite

Every SQL assertion the grader supports — exercised in isolation, then in combination. Companion to the Backend Assertion Test Suite. SQLite dialect throughout.

12 lessons 12 challenges Module badge on completion

All lessons in this module

1. table_exists

Schema assertions Quiz Challenge

2. constraint_exists

Schema assertions Quiz Challenge

3. column_exists

Result-shape assertions Quiz Challenge

4. row_count

Result-shape assertions Quiz Challenge

5. result_not_empty

Result-shape assertions Quiz Challenge

6. result_contains

Result-data assertions Quiz Challenge

7. result_equals

Result-data assertions Quiz Challenge

8. result_ordered

Result-data assertions Quiz Challenge

9. Schema + seed + select roundtrip

Combos & realistic queries Quiz Challenge

10. Two tables with a foreign key + JOIN

Combos & realistic queries Quiz Challenge

11. Aggregate + GROUP BY

Combos & realistic queries Quiz Challenge

12. All-in-one comprehensive smoke test

Combos & realistic queries Quiz Challenge