UPDATE: The date of this meeting has been changed to Thursday, August 14th.
When: Thursday, August 14, 2008 — 7pm-9pm
Where: Consulate General of Canada
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
Location
Our meeting takes place at the Consulate General of Canada at 100 Colony Square in Midtown Atlanta (at the corner of Peachtree and 14th Streets). Click here for directions. You will need to see the concierge in order to gain access to the 17th floor.
