O'Reilly Open Source Convention 2004

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

Tutorial
Advanced SQL
Joe Celko, Professor, Northface University

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

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