From ER diagrams to EXPLAIN, with schemas students can bring from class projects.
Topics on the table
- Primary keys, foreign keys, and why orphan rows appear
- INNER versus LEFT joins with a small sample schema
- When an index helps — and when it only slows writes
Bring a draft schema from a campus project. Review the Database Fundamentals Quiz explanations afterward to lock the vocabulary.