IMPORTANT!!! We've had to reschedule Jay Pipes for August 14th - one week after our usual meeting time.

Presentation: Join-Fu: The Art of SQL

Jay Pipes, the North American Community Relations Manager at MySQL and co-author of Pro MySQL (Apress, 2005), joins us this month to present “Join-Fu: The Art of SQL.”

Join-fu is the art of performance-tuning your application’s SQL. Join Jay in a fun, irreverent look at the common ways application developers misuse and abuse their database.

Topics covered include:

• 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
    
  
  
• Doing GIS calculations in SQL
  
  
  
  • Without using user variables, the spatial extensions or stored functions
    
  • Calculating distance between two points
    
  • Doing radius searches in spherical geometries
    
  
  
• Reporting techniques in SQL
  
  
  
  • Calculating running sums and aggregates
    
  • Calculating rank of results
    
  
  

For more details and directions, go here.