Bob Christenson from Mustardseed Media, Inc. recently tought this seminar on "real world" Drupal theming - which resulted in these screencasts. Anyone looking to theme Drupal will want to check these out:

http://deanmeistr-drupal.blip.tv/posts?view=archive&nsfw=dc

I love sites that teach by scenarios. Stephen's done a great job here at showing you how to build online communities. He gives a step by step view of installing and configuring Drupal.

http://stephenondrupal.blogspot.com/2007/10/tutorial-creating-group-coll...