Jump to content

Joe Celko

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Dewritech (talk | contribs) at 15:47, 13 April 2016 (clean up, typo(s) fixed: Master's degrees → master's degrees (2) using AWB). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

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.[1]

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.[2]

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.[3]

Career

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 SQLUniversity.org. 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.

Bibliography

  • Joe Celko's Analytics and OLAP in SQL (Morgan-Kaufmann, 2006) ISBN 978-0-12-369512-3
  • Joe Celko's Data and Databases (Morgan Kaufmann, 1999) ISBN 978-1-55860-432-2
  • Joe Celko's SQL for Smarties (5th Edition, Morgan-Kaufmann, 2014) ISBN 9780128008300
  • Joe Celko's SQL Programming Style ISBN 978-0-12-088797-2
  • Joe Celko's SQL Puzzles and Answers (2nd edition, Morgan-Kaufmann 2006) ISBN 978-0-12-373596-6
  • Joe Celko's Trees and Hierarchies in SQL for Smarties, 2nd Edition (Morgan-Kaufmann, 2012) ISBN 978-0-12-387733-8
  • Joe Celko’s Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL. (Morgan-Kaufmann, 2008) ISBN 978-0-12-374137-0
  • Joe Celko’s Data, Measurements and Standards in SQL ISBN 978-0-12-374722-8

References

  1. ^ Morris, Richard (2009-10-16). "Geek of the Week: Joe Celko". simple-talk. Retrieved 2011-07-13.
  2. ^ Michael J. Kamfonas. "Recursive Hierarchies: The Relational Taboo!".
  3. ^ "Joe Celko, Class of '65". Baker High School. June 2006. Retrieved 2011-07-13.
Retrieved from "https://en.wikipedia.org/w/index.php?title=Joe_Celko&oldid=715078150"