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.
Jack Baty rated it liked it Jun 22, Dec 08, Steven rated it really liked xelko Shelves: 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.
To see what your friends thought of this book, please sign up. Just a moment while we sign you in to your Goodreads account. 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.
As of this writing, it is the third-longest I have ever taken to read a book—from first page to last, 1, days.
This book seems much fot than the other Celko books I’ve read or browsed- not surprising since its his core, original book. Book ratings by Goodreads. Transactional Information Systems Gerhard Weikum. Goodreads helps you keep track of books you want to read. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products.
Continues clko use war stories–updated! Glenn rated it really liked it Nov 08, He also updates smwrties element names to meet new ISO rules with the same experience-based teaching style that made the previous editions the classics they are today. 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.
Joe Celko’s Trees and Hierarchies in SQL for Smarties
These are not just tips and techniques; also offered are the best solutions to old and new challenges. Manfred rated it it was amazing Aug 26, Adjacency List Model 3.
He sure love the pre-ANSI syntax, and you’ll learn a lot about database management system that’s for sure. Offers tips for working around system deficiencies. Data Quality Jack E. It covers a wide range of topics, including detailed examples of many interesting niche cases.
Good, but a bit over-rated. Ian Channing rated it it was amazing Apr 18, I read through part of it at the time when I started, and never finished it. 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.
Principles of Transaction Processing Philip A. Larry Worley rated it it was amazing Jul 17, Some of the code in here is a bit obscure and most would probably have trouble finding use for it on everyday projects. He fir written over columns in the computer trade and academic press, mostly dealing with data and databases.
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 jpe practice than theory, but well, YMMV, and probably will. Visit our Beautiful Books page and find lovely books for kids, photography lovers and more. 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.
Which is not a bad thing on the theory level, but can be nightmare in practice if you straddle a couple of database lines.
Joe Celko’s SQL for Smarties: Advanced SQL Programming by Joe Celko
Description The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de facto standard smagties database retrieval, and if you need to access, update, or utilize data in a modern database management system, you will need SQL to cellko it.
Joe Celko’s SQL for Smarties, 5th Edition – O’Reilly Media
Now you can get everything on Celkko. This is balanced out by 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 throwaways, 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 celkp.