O'Reilly Open Source Convention
Books Safari Bookshelf Conferences O'Reilly Network

Arrow Home
Arrow Registration
Arrow Speakers
Arrow Keynotes
Arrow Tutorials
Arrow Sessions
Arrow At-a-Glance
Arrow Wiki
Arrow BOFs
Arrow Events
Arrow Exhibitors
Arrow Sponsors
Arrow Hotel/Travel
Arrow Venue Map
Arrow See & Do
Arrow Tips for
Arrow Press
Arrow Mail List



Advanced SQL
Joe Celko, Professor, Northface University

Track: Linux
Date: Tuesday, July 27
Time: 8:45am - 12:15pm
Location: Salon F


Celko's tutorial is chock full of SQL programming tricks for the working programmer:

1. Relational division
1.1. with and without remainders
1.2. Other set operations
2. Trees & Hierarchies in SQL
2.1. Differences between a tree and a hierarchy
2.2. Adjacency list model
2.3. Nested sets model
2.4. Basic operations and aggregations
4. Temporal models in SQL
4.1. Points in time versus durations
4.2. Representing "eternity"
4.3. CALENDAR table
5. Tricks with CHECK()
6. Avoiding procedural code
6.1. Use of CASE expressions to replace if-then
6.2. Use of Sequence table to replace loops
6.3. Use of functions to replace procedural code

O'Reilly Home | Privacy Policy

© 2004, O'Reilly Media, Inc.