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