Jay Pipes is a software engineer for Sun Microsystems working on the Drizzle database microkernel. Previously he was the North American Community Relations Manager at MySQL.

Co-author of “Pro MySQL” (Apress, 2005), Jay has also written articles for Linux Magazine and regularly assists software developers in identifying how to make the most effective use of MySQL. He has given sessions on performance tuning at the MySQL Users Conference, RedHat Summit, NY PHP Conference, OSCON, PHP-Quebec, ZendCon and Ohio LinuxFest, amongst others.

He lives in Columbus, Ohio, with his wife, Julie, and his four animals. In his abundant free time, when not being pestered by his two needy cats and two noisy dogs, he daydreams in code and ponders the ramifications of __clone().

This will be a Adobe Connect presentation:

Topics included in this presentation are :

• Schema optimization and vertical partitioning
• SQL Coding style guidelines
• Set-wise problem solving in SQL (and why it kicks for-loop-fu's ass.)
  •   Rewriting correlated subqueries into joins
  •   Using derived tables or subqueries in the FROM clause
• Working with N:M or "mapping" tables
  •   Dealing with OR conditions
  •   Dealing with AND conditions
  •   Combatting filesorts using Cross-join-fu
•   Understanding Left-join-fu