Start reading Joe Celko's SQL for Smarties: Advanced SQL Programming on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Image not available

Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems) [Kindle Edition]

Joe Celko
4.2 out of 5 stars  See all reviews (5 customer reviews)

Print List Price: £41.99
Kindle Price: £27.92 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £14.07 (34%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition £27.92  
Paperback £29.39  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Book Description

Joe Celkos SQL for Smarties: Advanced SQL Programming offers tips and techniques in advanced programming. This book is the fourth edition and it consists of 39 chapters, starting with a comparison between databases and file systems. It covers transactions and currency control, schema level objects, locating data and schema numbers, base tables, and auxiliary tables. Furthermore, procedural, semi-procedural, and declarative programming are explored in this book.
The book also presents the different normal forms in database normalization, including the first, second, third, fourth, fifth, elementary key, domain-key, and Boyce-Codd normal forms. It also offers practical hints for normalization and denormalization. The book discusses different data types, such as the numeric, temporal and character data types; the different predicates; and the simple and advanced SELECT statements. In addition, the book presents virtual tables, and it discusses data partitions in queries; grouping operations; simple aggregate functions; and descriptive statistics, matrices and graphs in SQL. The book concludes with a discussion about optimizing SQL. It will be of great value to SQL programmers.


  • Expert advice from a noted SQL authority and award-winning columnist who has given ten years service to the ANSI SQL standards committee
  • Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL 92 or SQL 2008 environment
  • Offers tips for working around deficiencies and gives insight into real-world challenges

Product Description


"If you work with SQL in any way, shape, or form, the most recent edition of Joe Celko's SQL for Smarties needs to be on your bookshelf!"--Data Technology Today Blog

About the Author

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

Product details

  • Format: Kindle Edition
  • File Size: 2625 KB
  • Print Length: 816 pages
  • Publisher: Morgan Kaufmann; 4 edition (22 Nov. 2010)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B0050P497U
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Bestsellers Rank: #426,310 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Author

Discover books, learn about writers, and more.

Customer Reviews

4.2 out of 5 stars
4.2 out of 5 stars
Most Helpful Customer Reviews
2 of 2 people found the following review helpful
3.0 out of 5 stars Good but many errors 21 Dec. 2010
Format:Paperback|Verified Purchase
I have always admired Joe Celko for bringing SQL smarts to SQL programming. This book is a very good step forward over the previous books. However within minutes of opening the book I found several errors. And I noticed this in his other books as well. It seems the editorial and technical staff of his publisher needs improving. The most frustrating thing is that there is no website or e-mail address in the book where to get the corrections or send errata.

It can make for a frustrating and confusing read at time. His strict adherence to a SQL standard can be also frustrating. Perhaps just once in a while it would be nice to see things in T-SQL or PL/SQL.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars Superb SQL Book one of the best 23 Oct. 2011
Format:Kindle Edition|Verified Purchase
I highly recommend this excellent book - I've read over 50 database books and this is in my top 5.
Mr Celko writes in a highly opinionated, slightly arrogant style, I can understand how this annoys some readers.
I though find it entertaining and above all educational, because he is so good at explaining complex topics in a readable practical manner. I love his characterisation of ID Idiot developers for example which is so true. It's a shame there are so few advanced practical sql books relevant to the real world like this - most others are far too simplistic and of no value to anyone beyond beginner level.
Please somebody write some more books like this - especially focused on database programming and Postgres, for which there are no recently published books available (apart from Postgres tuning and admin).
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars A really useful book 20 Nov. 2012
By MikeS
Format:Paperback|Verified Purchase
This is not the best book for someone with no sql experience but if you want to move on to the next level this is the book to help you do so.
Comment | 
Was this review helpful to you?
4.0 out of 5 stars very good, if you are very good 22 April 2013
By jwk
Format:Paperback|Verified Purchase
Don't underestimate the amount of knowledge required to understand this. It is an into depth book and if you are a novice to SQL you'll have a hard time to follow Joe. He obviously is very good so he shows you a multitude of "best possible solutions" assuming you know quite a bit already.

Yes, it took me quite a bit of reading to fully understand his solutions but in the end they are worth the effort of buying & using the book to create better solutions for everyday programmer issues.
Comment | 
Was this review helpful to you?
4.0 out of 5 stars just for the fun of having it on my desk 6 July 2014
By eric_cx
Format:Paperback|Verified Purchase
Bought an early edition years ago, just for the fun of having it on my desk. This edition is better and I agree with other reviews.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category