- Series: The Morgan Kaufmann Series in Data Management Systems
- Paperback: 550 pages
- Publisher: Morgan Kaufmann; 1 edition (October 25, 1999)
- Language: English
- ISBN-10: 1558605762
- ISBN-13: 978-1558605763
- Product Dimensions: 7.2 x 1.2 x 9.2 inches
- Shipping Weight: 1.9 pounds (View shipping rates and policies)
- Average Customer Review: 26 customer reviews
- Amazon Best Sellers Rank: #1,352,311 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 Second Edition (The Morgan Kaufmann Series in Data Management Systems) 1st 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:
"Children of Blood and Bone"
Tomi Adeyemi conjures a stunning world of dark magic and danger in her West African-inspired fantasy debut. Pre-order today
Customers who viewed this item also viewed
What other items do customers buy after viewing this item?
From the Back Cover
SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques you need to transform yourself into an expert SQL programmer. Now, in this fully updated second edition, SQL mastermind Joe Celko keeps you moving forward, using his entertaining
, conversational style to teach you the best solutions to old and new challenges and to convey the way you need to think if you really want to get the most out of your SQL programming efforts.
Inside, logic- and set-based analyses replace the traditional
, procedural approach to problem-solving, helping you make the conceptual leap that separates an SQL guru from the rest of the pack. As you catch on to Celko's approach, you'll devour what he has to say about some of SQL's toughest topics: how aggregate functions really work, the best way to work with NULLs, how and why to fake array structures, and much more.
This book gives special emphasis to SQL-92 and product-independent techniques that let you optimize performance or achieve highly specialized behavior, regardless of the RDBMS with which you work. If you're serious about SQL, you won't let SQL for Smarties out of your sight.
- Presents all-new war stories that give you insight into real-world SQL programming challenges.
- Continues to cover SQL-89 but focuses heavily on the SQL-92 standard.
- Offers still more undocumented tips for working around system deficiencies.
- Teaches scores of advanced techniques that can be used with any product, in any SQL environment.
- Offers expert advice from a noted SQL authority and award-winning columnist.
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Warning: Beginners may need another book and it is not a replacement for your SQL vendor specific reference.
I didn't find the math as challenging as others, and not because I have advanced mathematical skills (I don't). The set theory is fairly straightforward and actually simplified, attempting to re-orient your thinking away from procedural code and more towards discrete structures. Believe me, reading the original Chris Date papers or Dr. Codd research on database theory would represent real mathematical challenges.
As there are many kinds of readers with different skill levels, it's possible the book holds no suprises for some. However, as someone who has used it frequently, I can't say I've seen many errors or typos in it. I don't code the examples directly into my database, either, because I translate the concepts directly into actual work-related problems.
I've found it to be an essential guide for experienced SQL developers who are looking to keep learning in a practical manner, but intuit that there is something more to SQL than the mechanics of syntax. Really changing your thinking to set-based rather than procedural problem solving is what the book tries to achieve, and it succeeds. This text is an unqualified, solid recommendation for anyone looking to evolve into a senior SQL developer.
However, while there is much in the book that is worthwhile, I found it terribly sloppy, not only in the practical solutions supplied but in all aspects of the book. Nearly every sample piece of code, even quite short snippets, has a bug in it; the descriptions of the problems he is attempting to solve and the explanations of the solutions are full of unstated assumptions; and much of the general text is imprecise or vague and skims over areas that could do with more detailed explanations. Some parts I have read several times over without being able to make any sense of them.
In fact, I have come to the point where, if a section of text or a practical example seems wrong or difficult to follow, I don't know any more if it's Joe's fault or mine.
To Joe's credit, I can say that I have corresponded with him and he was quick to reply and was willing to continue the discussion when I followed up. He generally comes across as a "great guy", and he did accept my criticism of the solution he'd given to a problem and produced a satisfactory alternative, but every point I made to him had to be explained in detail and I still felt at the end that he wouldn't get the solution 100% right when he incorporated it in his book.
One section of the book that I found absolutely fascinating was a short description of the standardization process of the Western or Gregorian calendar. It was mostly irrelevant to the topic of the book but fascinating nonetheless. There are other gems scattered throughout, he has a good list of references and I have found he has made several points which I could quote to support my postion in arguments in standards committee meetings, but I feel that it would take as much more effort to get the book right as it has take already to produce it.
Most recent customer reviews
I write queries all day, in SQL Server, Sybase 5.Read more