phase 3 · 3.1-sql-fundamentals

SQL fundamentals — no Go

review intervals 7d 21d 60d drills sql-crud-raw

The lesson for this task hasn't been written yet. The mastery criteria below is the shortest description of what you'll own when this task is green.

Mastery criteria

- In psql (or sqlite3): CREATE TABLE with types + constraints, INSERT, UPDATE, DELETE, SELECT with WHERE
- INNER JOIN two tables with a COUNT + GROUP BY
- Explain: what is an index, why adding one helps SELECT and hurts INSERT
- Explain transactions with ACID in plain language; demonstrate ROLLBACK

Verify

Run from your go-dojo repo root:

go-dojo verify 3.1-sql-fundamentals

This runs the task's go test suite in exercises/phase-3/3.1-sql-fundamentals/, commits the attempt to .go-dojo/attempts/, and updates your mastery.