Ideas for intro SQL presentation / training At my work, I've been asked to teach a short half-hour to an hour course about "select and joins". I'm also thinking about discussing unions, sub queries and temp tables in this course. Are there any core concepts that relate to the topic of "select and joins" that I could include to expand the length of said course?
Sure, start with my Learn SQL with the Stack Overflow Database.

It's designed for you to demo with the Stack Overflow public data dump. (I just updated it today, coincidentally.)