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
 Attending
Arrow Press
Arrow Mail List

OSCON.

Tutorial

Advanced SQL
Joe Celko, Professor, Northface University

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

TrackBackTrackBack

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.