When to join at query time and when to pre-join.
Made for you now: slide lessons from basics to production, usually with code and a quiz. See a finished one