Event Archive‎ > ‎

Thinking in Sets

SQL is a declarative programming language, not a procedural language. It is based on sets and not sequential files. You do not solve problems the same way as you do in conventional languages. Here are some tips and hints to get you over to the new paradigm.

About the Speaker

Joe Celko

Joe Celko was a member of the ANSI X3H2 Database Standards Committee from 1987 to 1997 and helped write the ANSI/ISO SQL-89 and SQL-92 standards. He has written over 750 columns in the computer trade and academic press, mostly dealing with data and databases. His last magazine column was "CELKO" in INTELLIGENT ENTERPRISE magazine (CMP) and he currently writes for BMC's DBAzine.com e-magazine.

He is the author of six books: SQL FOR SMARTIES (Morgan-Kaufmann, 1995, second edition 1999, third edition 2005), SQL PUZZLES & ANSWERS (Morgan-Kaufmann, 1997), DATA & DATABASES (Morgan-Kaufmann, 1999) and TREES & HIERARCHIES IN SQL (Morgan-Kaufmann, 2004), SQL PROGRAMMING STYLE (Morgan-Kaufmann, 2005) and ANALYTICS & OLAP IN SQL (Morgan-Kaufmann, 2005).

Mr. Celko's past columns include: "SQL Explorer" in DBMS (Miller-Freeman); "Celko on SQL" in DATABASE PROGRAMMING & DESIGN (Miller-Freeman); "WATCOM SQL Corner" in POWERBUILDER DEVELOPERS' JOURNAL (SysCon); "SQL Puzzle" in BOXES & ARROWS (Frank Sweet Publishing); "DBMS/Report" in SYSTEMS INTEGRATION (Cahner-Ziff); "Data Desk" in TECH SPECIALIST (R&D); "Data Points" in PC TECHNIQUES (Coriolis Group); "Celko on Software" in COMPUTING (VNC Publications, UK), "SELECT * FROM Austin" (Array Publications, The Netherlands), and he was editor for the "Puzzles & Problems" section of ABACUS (Springer-Verlag) and he ran the CASEFORUM section 18, "Celko on SQL", on CompuServe.
Steven Teleki,
Oct 24, 2008, 12:14 PM