I've taught courses on SQL to newbies and learned a lot from it.
My rule for the slide deck was "don't use a term you haven't explained". So I'd write a slide and check for new words. If I really needed them I'd have to add a slide before that introduced and explained the term.
Figuring out exercises that got students oriented to the concepts was another trick. People really don't get stuff until they've done it for themselves.
By the end of the second day I had people writing joins on their own.
My rule for the slide deck was "don't use a term you haven't explained". So I'd write a slide and check for new words. If I really needed them I'd have to add a slide before that introduced and explained the term.
Figuring out exercises that got students oriented to the concepts was another trick. People really don't get stuff until they've done it for themselves.
By the end of the second day I had people writing joins on their own.