05 Resources¶
Supplemental references that support the notes, exercises, and projects.
Note
Course lecture slides, the reference textbook, and assignment files live locally under 05-resources/ but are not published with the site and are not committed to version control (they are excluded from both the build and git to respect copyright — see 05-resources/.gitignore).
Reference Material¶
| Type | What it covers |
|---|---|
| Reference textbook | Database Concepts, 9th Edition (Kroenke, Auer, Vandenberg, Yoder) — Ch. 1–7 plus Extension B, mapped to the 8 course modules |
| Class lectures | Slide decks aligned to each module, plus supplementary joins/E-R/context lessons |
| Case studies | San Juan Sailboat Charters and James River Jewelry — running case studies used across the exercises and projects |
| Sample database | Wedgewood Pacific — the schema (DEPARTMENT, EMPLOYEE, PROJECT, ASSIGNMENT) used for SQL querying and joins practice |
Tools¶
| Tool | Use | Link |
|---|---|---|
| PostgreSQL | Primary dialect for every query in this repo | postgresql.org |
| SQLite | Zero-install alternative for working through the notes | sqlite.org |
| pgAdmin / DBeaver | Browsing schemas and running SQL interactively | pgadmin.org · dbeaver.io |
| draw.io | Drawing E-R diagrams for the modeling projects | app.diagrams.net |