SQL for Drupal/PHP Developers
davidstokes
This session is for those of you who think writing database queries is a 'dark art', use an object relaltional mapper, or just plain write queries that suck. You will learn how to think in sets instead of objects or lines to avoid the dreaded N + 1 Problem, see how Structured Query Language is descriptive (descibe what you want), how database indexes really work, the proper way to create compound indexes for maximum speed, and how to create joins that will leave your coworkers in slack jawed awe at your awesome competence.