Session

SQL Outer Joins for Fun and Profit

Bill Karwin, Product Engineering Manager, Zend Technologies

Track: Databases
Date: Thursday, July 27
Time: 1:45pm - 2:30pm
Location: Portland 252

Many questions on database newsgroups and forums can be answered with uses of outer joins. Outer joins are part of the standard SQL language and supported by all RDBMS brands. Many programmers are expected to use SQL in their work, but few know how to use outer joins effectively.

Learn to use this powerful feature of SQL, increase your employability, and amaze your friends! Karwin will explain outer joins, show examples, and demonstrate a Sudoku puzzle solver implemented in a single SQL query.