- Series: The Morgan Kaufmann Series in Data Management Systems
- Paperback: 840 pages
- Publisher: Morgan Kaufmann; 3 edition (August 12, 2005)
- Language: English
- ISBN-10: 0123693799
- ISBN-13: 978-0123693792
- Product Dimensions: 7.2 x 1.8 x 9 inches
- Shipping Weight: 3.8 pounds (View shipping rates and policies)
- Average Customer Review: 17 customer reviews
- Amazon Best Sellers Rank: #1,163,254 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems) 3rd Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
There is a newer edition of this item:
"Warlight" by Michael Ondaatje
A dramatic coming-of-age story set in the decade after World War II, "Warlight" is the mesmerizing new novel from the best-selling author of "The English Patient." Pre-order today
Frequently bought together
Customers who viewed this item also viewed
Customers who bought this item also bought
"This book is a classic, and this revision will merely solidify its position." --Rudy Limeback
SQL for Smarties is a well-known and highly regarded text in the industry and a new edition of the book will be sought by database practitioners regardless of the DBMS they use. --Craig Mullins, BMC Software
A completely revised edition of the classic advanced SQL book!
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
This book is NOT an advanced SQL textbook. Another reviewer, Tim Boyes, describes it as "SQL 201", and he's exactly right. Most of the content in this book is just barely above basic SQL knowledge, and half the time I felt like I was reading a re-hash of SQL BOL.
Another thing that I noticed (how could I miss it?) was the almost incomprehensible arrogance of the author, particularly when he compares the use of IDENTITY to drug abuse. Come on, Joe. That's just insulting.
This one's going back to Amazon.
You're expected to know SQL before picking up this book, and know it well - at a minimum, this should be your second (or maybe third) book on SQL. In chapter 4, for example, he says "It's obvious this had to be a self-join", although joins (self or otherwise) aren't even introduced until chapter 17. This book won't teach you how and when to use outer joins or aggregate functions; it assumes you already have a (very good) handle on that sort of thing, and instead talks about the corner cases you're liable to run into. Although it's really amazing how far he manages to stretch SQL in this book, he doesn't try to do is try to teach you to _think_ like he does. He just shows you what he's come up with.
His examples range from the insanely clever to the borderline criminally insane, but some of them are also the sort of thing that would dim the lights if you tried to use in a real database... and almost definitely something that would be easier to maintain procedurally. The author admits to this himself, especially in the later chapters of the book where he concedes that the techniques presented aren't really good fits for SQL, but "here's how you could do it anyway".
The author does tend to wander off-topic, and there are places where three completely independent concepts will be touched on in a single paragraph, leading you to re-read a couple of times trying to figure out if these things were meant to be tied together and if you maybe missed something. There are a lot of fascinating, and very readable asides (like where the names September, October, November and December come from), but they're scattered around randomly.
All in all, this is stuff you're not going to get anywhere else, which you probably will eventually need, but this book will be neither the beginning nor the end of your SQL education.