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):||28 February 2016|
|PDF File Size:||2.97 Mb|
|ePub File Size:||8.51 Mb|
|Price:||Free* [*Free Regsitration Required]|
Joe Celko’s SQL for Smarties: Advanced SQL Programming by Joe Celko
Glenn rated it really liked it Nov 08, 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 smartiees 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 nooks and crannies that most people will never explore even if they shouldit addresses not only the way the language should be used but the ways it shouldn’t and is often pressed into service to do anywayetc.
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.
Physical formatting could be a lot better- often a huge margin sits next to lines of code that wrap unnecessarily. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products.
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. Table of contents 1. Reuben rated it liked it Dec 22, The other drawback, and this was a fot one on Celko’s part, is that the book is ror, which pretty much by definition in today’s world means implementation-agnostic.
There was a problem providing the content you requested
Product details Format Paperback pages Dimensions x x I read through part of it at the time when I started, and never finished it. The book gives some interesting thoughts about SQL. Goodreads helps you keep track of books you want to read.
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. 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.
Principles of Transaction Processing Philip Smxrties. Path Enumeration Models 4.
Joe Celko’s Trees and Hierarchies in SQL for Smarties : Joe Celko :
If you like books and love to build cool products, we may be looking for you. Adjacency List Model 3. I knew it had taken me a long, long time to get through it it sat on my desk at qsl for quite a smartiea and I had no time there to get to itbut even I didn’t know how long specifically.
Good, but a bit over-rated. Frequent Insertion Trees 6. Time and Relational Theory C. Hierarchical Encoding Schemes Visit our Beautiful Books page and find lovely books for kids, photography lovers and more.
Refresh and try again. Because of its author, this book has some reputation out there. He does regularly call out when there is more coverage available in a specific book, and that may make sense in other fog.
Data Quality Jack E. SQL is the de facto standard for xmarties retrieval, and if you need to access, update, or utilize data in a modern database management system, you will need SQL to do it.
Me, I’m a big fan of examples, and lots of them, and they do show up in almost every section; I would’ve liked a stronger focus on practice than theory, but well, YMMV, and probably will. Lists with This Book. UnixLists rated it it was amazing Dec 28, Vincent rated it really liked it Sep 05, Physical Database Design Sam S.
Justin Luke rated it it was amazing Mar 18, Book ratings by Goodreads. Some of the code in here is a bit obscure and most would probably have trouble finding use for it on everyday projects. Jun 04, Kevin rated it liked it. Erwin Andreasen rated it really liked it Aug 06, And he frequently uses the!