MySQL, PHP

Slides from Drunken Query Master and Join-fu Talks at ZendCon


Sorry for the slight delay in publishing the slide decks from my tutorial and session at ZendCon this past Monday and Tuesday. A short flight to RĂ­ga, Latvia, got in the way.

Below are the Open Office Impress and PDF versions of the slide decks for Legend of Drunken Query Master and Join-fu for ZendCon. Enjoy.

Legend of Drunken Query Master: The Apprentice’s Journey

  Open Office Impress slides

  PDF slides

Join-fu: The Art of SQL – ZendCon 2008

  Open Office Impress slides

  PDF slides

Topics included in the slide decks:

  • 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
  • Handling Heirarchical Data
    • Adjacency Lists
    • Nested Sets
  • Reporting techniques in SQL
    • Calculating running sums and aggregates
    • Calculating rank of results