Nisha Rathode

Joe Celko

Name  Joe Celko

Role  Author
Joe Celko httpswwwsimpletalkcomiwriteforarticlefiles
Books  Joe Celko's SQL for Smarties, Joe Celko's Trees and Hierarchi, Joe Celko's SQL puzzles, Joe Celko's Thinking in Sets: Auxi, Joe Celko's Analytics and OLA

Measurements scales and encoding schemes joe celko

Joe Celko is an American relational database expert from Austin, Texas. He has participated on the ANSI X3H2 Database Standards Committee, and helped write the SQL-89 and SQL-92 standards. He is the author of a Morgan-Kaufmann series of books on SQL, and over 1200 published articles on SQL and other database topics. He had been a full-time statistician for several years.


Joe Celko httpsimagesnasslimagesamazoncomimagesI2

He is credited with coining the term lasagna code and popularizing Michael J. Kamfonas' nested set model for trees in SQL, a taxonomy of data encoding schemes, and several other design patterns in SQL DDL and DML.

Early life and education

Celko achieved his undergraduate and first master's degrees in math at Georgia State University. He also has a second master's degree in computer science from Georgia Tech.


Celko has a very wide range of industries and applications starting in 1965 with a National Science Fair prize job at the Pittman-Dunn Research labs at the Frankford Arsenal. His public sector consulting work has been for prison systems, medical organizations, NASA and defense contractors. He helped set up programming and Software Engineering standards for the US Army at AIRMICS and wrote regular columns on it in the trade press on Software Engineering.

His commercial consulting work has been varied—auto loans, entertainment, aerospace, education, shipping (freight lines and ocean shipping), petro-chemical, software companies, and odd start-ups.

He has taught training classes in South Africa, Turkey, the UK, Norway, Sweden, Finland, The Netherlands, Brazil, Belgium and Switzerland. He has also created and taught on-line classes for MySQL and He was part of the founding faculty of Neumont University in Salt Lake City, a for-profit university for software developers.

Communication style

Mr. Celko is known for wearing trademark three-piece black suits with cuff links and putting on a good performance when he speaks. A well-known quote of his is "Columns are not fields. Rows are not records. Tables are not files," which has been put on tee-shirts.

There is a fan blog entitled JOE CELKO THE SQL APPRENTICE. This blog is not Joe Celko's but it is a collection of his answers in public newsgroups.

He has been an invited speaker at conferences and user groups in the US and overseas for decades. Celko has been a frequent volunteer speaker at SQL Saturdays in the United States in recent years.

His SQL books have continued to sell well and have been translated into Russian, Japanese, Chinese, French and Hungarian.


Joe Celko Wikipedia

Similar Topics
The Vulgar Hours
Paweł Sibik
Marcus Falk Olander