false http://photo.goodreads.com/books/1180484953m/1046365.jpg 1046365 4 In the SQL database community, Joe Celko is a well-known columnist and purveyor of valuable insights. In <I>Joe Celko's SQL for Smarties: Advanced SQL Programming</I>, he picks up where basic SQL training and experience leaves many database professionals and offers tips, techniques, and explanations that help readers extend their capabilities to top-tier SQL programming.<p> Although Celko denies that the book is about database theory, he nevertheless alludes to theory often to buttress his practical points. This title is not for novices, as the author points out. Instead, its intended audience is SQL programmers with at least a year's experience. The book maintains a fine balance between technical discussion and practical explanation--picking hot topics and offering advice on a wide range of issues.<p> The book uses ANSI SQL-89 as its baseline standard, with some mention of SQL-92 features. It does not, however, focus on any commercial product; this guide zeroes in on the SQL language. Celko covers all aspects of database design, optimization, and manipulation, with easy-to-understand explanations of key issues such as why not to use too many nulls, how to use practical normalization, and how to optimize queries. <p> This insightful text is manna for all the day-to-day SQL coders banging their heads over the language's subtle challenges. <I>--Stephen W. Plain</I><p> <B>Topics covered</B>: Database design and normalization, SQL data types, querying, grouping, set operations, optimization, data scaling, and encoding. 1032791 1995 Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems) total:21|5:4|4:5|3:9|2:3|1:0| 21 73 49 0 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 0 0 false Sun Nov 22 11:20:47 -0800 2009 Sun Nov 22 11:20:47 -0800 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 2 0 false Fri Nov 20 14:48:07 -0800 2009 Fri Nov 20 14:48:07 -0800 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 0 0 false Thu Nov 19 01:23:57 -0800 2009 Thu Nov 19 01:23:57 -0800 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 4 0 false Tue Nov 17 00:34:25 -0800 2009 Tue Nov 17 00:34:25 -0800 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 0 0 false Wed Sep 30 14:09:54 -0700 2009 Wed Sep 30 14:09:54 -0700 2009 1833246 1558605762 9781558605763 6 0 3.48 http://photo.goodreads.com/books/1188960854m/1833246.jpg http://www.goodreads.com/book/show/1833246.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming 3 0 false Wed Sep 16 23:37:28 -0700 2009 Wed Sep 16 23:37:28 -0700 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 0 0 false Sun Sep 06 03:03:43 -0700 2009 Sun Sep 06 03:46:27 -0700 2009 1833246 1558605762 9781558605763 6 0 3.48 http://photo.goodreads.com/books/1188960854m/1833246.jpg http://www.goodreads.com/book/show/1833246.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming 3 0 false Wed Aug 19 08:49:28 -0700 2009 Wed Aug 19 08:49:28 -0700 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 0 0 false Mon Jul 13 22:52:24 -0700 2009 Mon Jul 13 22:52:24 -0700 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 3 0 false Mon Jun 08 14:28:18 -0700 2009 Mon Jun 08 14:28:18 -0700 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 0 0 false Fri Jun 05 11:11:18 -0700 2009 Fri Jun 05 11:11:18 -0700 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 4 0 false Thu May 28 06:39:06 -0700 2009 Thu May 28 06:39:17 -0700 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 0 0 false Wed May 27 08:03:08 -0700 2009 Wed May 27 08:03:08 -0700 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 0 0 false Wed Apr 22 09:14:29 -0700 2009 Wed Apr 22 09:14:29 -0700 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 3 0 false Thu Apr 16 08:33:41 -0700 2009 Thu Apr 16 08:33:41 -0700 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 0 0 false Mon Feb 02 21:05:41 -0800 2009 Mon Feb 02 21:05:41 -0800 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 0 0 false Wed Jan 28 15:48:28 -0800 2009 Wed Jan 28 15:48:28 -0800 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 0 0 false Wed Jan 21 07:22:09 -0800 2009 Wed Jan 21 07:22:09 -0800 2009 1046365 0123693799 9780123693792 13 0 3.48 http://photo.goodreads.com/books/1180484953m/1046365.jpg http://www.goodreads.com/book/show/1046365.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming_Third_Edition 4 0 false Thu Dec 11 04:28:18 -0800 2008 Thu Dec 11 04:28:26 -0800 2008 1833246 1558605762 9781558605763 6 0 3.48 http://photo.goodreads.com/books/1188960854m/1833246.jpg http://www.goodreads.com/book/show/1833246.Joe_Celko_s_SQL_for_Smarties_Advanced_SQL_Programming 2 0 false Fri Sep 26 14:47:39 -0700 2008 Fri Sep 26 14:47:39 -0700 2008 http://www.goodreads.com/book_link/follow/8?book_id=1046365