Using Drupal

'Using Drupal, 2nd edition', published by O'Reilly, focuses on Drupal 7. Each chapter explains how to build a project, with step-by-step recipes to help you build out the precise functionality the site requires.
I wrote a chapter about how to use multimedia in Drupal, and one on content management and publishing workflows.