Joe Celko’s SQL for Smarties: Advanced SQL Programming, Third Edition, Joe Celko. • Moving Objects Databases, Ralf Güting and Markus Schneider. SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert . Joe Celko’s SQL for Smarties. Advanced SQL Programming. Book • 5th Edition • Authors: Joe Celko. Browse book content. About the book. Search in this.
|Published (Last):||7 February 2011|
|PDF File Size:||8.39 Mb|
|ePub File Size:||1.96 Mb|
|Price:||Free* [*Free Regsitration Required]|
Goodreads helps you keep track of books you want to read. Want to Read saving…. Want to Read Currently Reading Read. Refresh and try again. Open Preview See a Problem?
Joe Celko’s Trees and Hierarchies in SQL for Smarties : Joe Celko :
Thanks for telling us about the problem. Return to Book Page. SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert.
Now, 10 years later and in the third edition, this classic still reigns supreme celkoo the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also fr the best so SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert.
These are not just tips and techniques; Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. In the third edition, Joe features new examples and updates to SQL, expanded sections of Query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics.
Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums.
Offers tips for working around system deficiencies. Continues to use war stories–updated! Paperback3rd Editionpages. Published August 1st by Morgan Kaufmann Publishers first published To see what your friends thought of this book, please sign up. Lists with This Book. Nov 08, Joana rated it really liked it Shelves: Burnt the midnight oil with this book, hoping it can add a stretch to my head with this specific Oracle-based project I’m supposed to make a soft prototype of.
Useful if you already have the basic grounds. A bit repetitive, Me thinks you could cut the book’s length to a quarter down.
He sure love the pre-ANSI syntax, and you’ll learn a lot about database management system that’s for sure. View all 5 comments. Jul 20, Alex French rated it really liked it.
This book seems much better than the other Celko books I’ve read or browsed- not surprising since its his core, original book. It covers a wide range of topics, including detailed examples of many interesting niche cases. I think this book gave decent coverage of everything in those other two books- I’m not sure they really need to exist at all.
He does regularly c This book seems much better than cel,o other Celko books I’ve read or browsed- not surprising since its his core, original book. He does regularly call out when there is more coverage available in a specific book, and smraties may make sense in other cases.
Joe Celko’s SQL for Smarties: Advanced SQL Programming by Joe Celko
Lots of repetition but if you want to use it as an occasional reference, that may be good. Examples tend to switch between several different formats sometimes the schema is illustrated with data, sometimes with Tor statements, only occasionally is result data shownand it doesn’t seem to be a conscious choice.
Physical formatting could be a lot better- often a huge margin sits next to lines of code that wrap unnecessarily. And he frequently uses the! Mar 26, Robert Beveridge rated it really liked it Recommends it for: SQL administrators and developers. It had been a very long time since I had updated the Duration column on my spreadsheet, but I figured if any book warranted doing so, it would be SQL for Smarties.
I knew it had taken me a long, long time to get through it it sat on my desk at work for quite a while and I had no time there to get to itbut even I didn’t know how long specifically. As of this writing, it is the third-longest I have ever taken to read a book—from first page to last, 1, days. That is one heckuva lot of time for a book, but then SQL for Smarties is not normally the kind of book one reads from beginning to end anyway, so take all that with a grain of salt.
Celko has been a member of many of the SQL standards committees, and quotes at length from the documents he helped to author for them. For some people, that might be a great way to learn. Me, I’m a big emarties of examples, and lots of them, and they do show up in almost every section; I would’ve liked a stronger focus crlko practice than theory, but well, YMMV, and probably will. This is balanced out smarhies the fact that when Celko lets his non-existent hair down, every once in a while a sentence will pop out that you can’t believe you just read in what is, essentially, a technical manual, and those sorts of little surprises may seem like foe, but for someone like me, they add a lot of intangible value; this one will be a ref manual on my shelf after a lot of other ones have fallen by the wayside.
The other drawback, and celjo was a consciously-planned one on Celko’s part, is that the book is language-pure, which pretty much by definition in today’s world means implementation-agnostic. Which smartiss not a bad thing on the theory level, but can be celkko in practice if you straddle a couple of database lines.
Right here in Celko Hey, Microsoft, fix that, it’s an amazing function. To be fair to Celko, he throws in an admonition about that every so often, but that won’t combat wishful thinking. On the other hand, the big, big upside is that as long as you keep the above caveats in mind, SQL for Smarties is really the only SQL reference book you’ll ever need pending new editions, of course ; it may not be exhaustive—I think I remember Celko saying that once or twice—but it’s pretty comprehensive, it dives into smarries and crannies that most people will never explore even if they shouldit addresses not only the way the smartoes should be used but the ways it shouldn’t and is often pressed into service to eclko anywayetc.
There is a massive wealth of information here for database developers who use a flavor of SQL, and it belongs on the shelf of every person who fits that description, amateur or professional.
Because of its author, this book has some reputation out there.
Joe Celko’s Trees and Hierarchies in SQL for Smarties
I read through part of it at the time when I started, and never finished it. The book gives some interesting thoughts about SQL.
But the code examples are not too useful since there are a lot of errors. Jun 04, Kevin rated it liked it. Good, but a bit over-rated. Some of the code in here is a bit obscure and most would probably have trouble finding use for it on everyday projects. This book taught me everything that i needed to know about databases. Dec 08, Steven rated it really liked it Shelves: You will learn a lot by reading this book if you have a basic grounding in SQL and are looking to stretch yourself to solving the most difficult SQL problems in a set-oriented way.
How to read this. Somehow it doesn’t cover the real challenges in writing SQLs. Extremely obscure geeky stuff. This is not the stuff you use every day. Vincent rated it really liked it Sep 05, Wenxiu Bian rated smarfies liked it Jun 08, Manfred rated it it was amazing Aug 26, Peter Tilke rated it really liked it Nov 21, Carolyn Stein rated it really liked it Dec 11, Glenn rated it really liked it Nov 08, Ridwan Rohman rated it it was amazing May 07, Ronny rated it it was amazing Mar 06, Erwin Andreasen rated it really liked it Aug 06, Guillermo Labatte rated it liked it Oct 15, Justin Luke rated it it was celk Mar 18, Paul Harrington rated it liked it May 13, Mohammed Asif rated it really liked it Nov 17, Jack Baty rated it liked it Jun 22, Peter Castine rated it liked it Mar 31, Reuben rated it liked it Dec 22, Larry Xmarties rated it it was amazing Jul 17, Ian Channing rated it celkl was amazing Apr 18, UnixLists rated it it was amazing Dec 28, There are no discussion topics on this book yet.
If you like books and love to build cool products, we may be looking for you. Books by Joe Celko. No trivia or quizzes yet. Just a moment while we sign you in to your Goodreads account.