Local course preview
SQL for Data Analysis and AI
Practise analytical PostgreSQL queries on fictional retail data. The supplied local PGlite runner is the author-tested route; no embedded SQL editor or native PostgreSQL learner trial is claimed.
Preparation: Comfort with tables, rows, columns and basic arithmetic. No prior SQL or Python is required.
Read all 13 modules as a guest, in any order. An optional account saves your place and reading marks. Practice rubrics are for self-review; they do not unlock reading or award a certificate.
Planning estimate: 14–18 hours plus 2–3 hours for the capstone. Timing and learner outcomes have not been piloted.
Start course Download original course materials (includes reference answers).
Reading progress
13 lessons remain open to guests. Marking a lesson read records reading only; it does not award assessment credit or a certificate.
Device reading marks require browser storage. Reading is always available.
Your earlier place on this device suggests these lessons. No new lesson is marked read.
Course contents
Start with a question and a safe lab
Select only the evidence you need
Filter rows without losing the unknowns
Calculate amounts and time periods
Summarise at a declared grain
Join relationships and preserve missing matches
Prevent join multiplication and reconcile money
Build readable analysis with subqueries and CTEs
Compare rows with window functions
Audit quality before trusting the result
Prepare AI features without future leakage
Use AI as a checked SQL assistant
Deliver a checked analysis capstone