Skip to content

Latest commit

 

History

History
32 lines (24 loc) · 1.24 KB

File metadata and controls

32 lines (24 loc) · 1.24 KB

SQL Masterclass: Zero to Data Scientist

Workshop taking a learner from SELECT to window functions, CTEs and PostgreSQL-specific analytics.

This is teaching material, not a product. The bar is that a learner can clone it and run it. Optimise for a working first command and a clear error when something is missing, not for architecture.

Running it

make help
make setup
make install
make test
make up

All targets: help, install, setup, setup-data, up, down, init-db, init-sqlite, verify, test, clean.

Python project (pyproject.toml). Use the repo's own virtualenv; never install into the system interpreter.

Rules

  • Never break the first-run path. A learner hitting an error in step one abandons the workshop. If you change setup, run it from a clean clone before calling it done.
  • Explanations belong in the README and in notebook prose, not in long code comments. The code is the lesson; it should read as the clearest version of the idea.
  • No em dashes in prose, per the house rules in /Users/param/.claude/skills/lwp-shared/house-rules.md.
  • Pin what you can. A workshop that worked last term and breaks this term because an upstream package moved is the most common failure here.