June 18, 2012 – SQL – How to think in sets instead of sequences or objects

Joe Celko

Joe Celko

This talk will take place on June 18th at the Microsoft Austin building.

Programmers begin programming with procedural and OO languages. A program is a sequence of deterministic steps. Unfortunately this is the worst way to program in SQL where we declare entire sets of data and have no idea how the SQL engine got it for us.

You have to make an effort to escape the old mindset. When you count a bag of coins, do you pick up each coin one at a time or do you weigh the bag?

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. He is author of eight books on SQL for Morgan-Kaufmann: SQL FOR SMARTIES (1995, 1999, 2005, 2010), SQL PUZZLES & ANSWERS (1997, 2006), DATA & DATABASES (1999) and TREES & HIERARCHIES IN SQL (2004), SQL PROGRAMMING STYLE (2005) and ANALYTICS & OLAP IN SQL (2005) and THINKING IN SETS (2008).
He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases. Mr. Celko’s past columns include: Columns for Simple-Talk (Redgate Software); “CELKO” in INTELLIGENT ENTERPRISE magazine (CMP); BMC’s DBAzine.com e-magazine; “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.

The talk will take place at  Microsoft Austin office from 5:30 p.m. to 8:00 p.m. on 6/18/2012.

Our sponsor for this month is Apex Systems.