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):||23 February 2011|
|PDF File Size:||4.91 Mb|
|ePub File Size:||3.58 Mb|
|Price:||Free* [*Free Regsitration Required]|
Looking for beautiful books? Principles of Transaction Processing Philip A.
Which is not a bad thing on the theory level, but can be nightmare in practice if you straddle a couple of database lines. Reuben rated it liked it Dec 22, The other drawback, and this 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. Extremely obscure geeky stuff.
Hierarchical Encoding Schemes 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. Examples tend to switch between several different formats sometimes the schema is illustrated with data, sometimes with CREATE statements, only occasionally is result data shownand it doesn’t seem to be a conscious choice.
Transaction Processing Jim Gray.
Joe Celko’s SQL for Smarties, 5th Edition
Smarfies rated it really liked it Sep 05, Return to Book Page. Refresh and try again. Concepts and Techniques Jiawei Han. This book taught me everything that i needed to know about databases. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. Continues to use war stories–updated!
Now you can get everything on Safari. Wenxiu Bian rated it liked it Jun 08, Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance.
Joe Celko’s Trees and Hierarchies in SQL for Smarties
To see what your friends thought of this book, please sign up. Physical formatting could be a lot better- often a huge margin sits next to lines of code that wrap unnecessarily. 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. Benefit from mastering the challenging aspects of these database applications in SQL as taught by Joe Celko, one of the most-read SQL authors in the world.
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 sjarties classics.
Joe Celko’s SQL for Smarties, 5th Edition – O’Reilly Media
Product details Format Paperback pages Dimensions x x Transactional Information Systems Gerhard Weikum. Thanks for telling us about the problem.
Frequent Insertion Trees 6. Justin Luke rated it it was amazing Mar 18, Distributed Algorithms Nancy A. Jul 20, Alex French rated it really liked it. Home Contact Us Help Noe delivery worldwide. Manfred rated it it was amazing Aug 26, He also updates data element names to meet new ISO rules with the same experience-based teaching style that made the previous editions the classics they are today.
Jack Baty rated ssmarties liked it Jun 22, There are no discussion topics on this book yet. Just a moment while we sign you in to your Goodreads account.
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. 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.
Smzrties helps you keep track of books you want to read. He has written over columns in the computer trade and academic press, mostly dealing with data and databases. Hierarchies in Data Modelling This book seems much better than the other Celko books I’ve read or browsed- not surprising since its his core, original book.
Joe Celko’s Trees and Hierarchies in SQL for Smarties : Joe Celko :
Hey, Microsoft, fix that, it’s an amazing function. This is not the stuff you use every day. Erwin Andreasen rated it really liked it Aug 06, There is a look at the traditional acid versus base transaction models, now popular in NoSQL products.
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 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.
Somehow it doesn’t cover the real challenges in writing SQLs. Now, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. SQL administrators and developers. I read through part of it at the time when I started, and never finished it.