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.

Author: Kijar Juzragore
Country: Chad
Language: English (Spanish)
Genre: Science
Published (Last): 7 November 2011
Pages: 445
PDF File Size: 6.39 Mb
ePub File Size: 14.24 Mb
ISBN: 915-4-19375-627-4
Downloads: 86298
Price: Free* [*Free Regsitration Required]
Uploader: Kisar

Thanks for telling us about the problem. Frequent Insertion Trees 6.

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.

Mohammed Asif rated it really liked it Nov 17, 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.

Larry Worley rated it it was amazing Jul 17, Goodreads is the world’s largest site for readers with over 50 million reviews. See our FAQ or contact customer service:. Goodreads helps you keep track of books you want to read. Vincent rated it really liked it Sep 05, 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.

Return to Book Page. Data Quality Jack E. Now, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves!

Joe Celko’s SQL for Smarties, 5th Edition – O’Reilly Media

Carolyn Stein rated it really liked ce,ko Dec 11, Paul Harrington rated it liked it May 13, Mar 26, Robert Beveridge rated it really liked it Recommends it for: Useful if you already have the basic grounds. These are not just tips and techniques; also offered are the best solutions to old and new challenges.


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.

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. Hierarchical Encoding Schemes This is not the stuff you use every day.

Somehow it doesn’t cover the real challenges in writing SQLs. I read through part of it at the time when I started, and never finished it. You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth.

There was a problem providing the content you requested

Because of its author, this book has some reputation out there. Peter Castine rated it liked it Mar 31, The Linear Version of the Nested Sets model 7.

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. 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.


Joe Celko’s Trees and Hierarchies in SQL for Smarties : Joe Celko :

The other drawback, and sqp 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. The Best Books of To see what your friends thought of this book, please sign up.

Book ratings by Goodreads. 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.

Joe Celko’s SQL for Smarties: Advanced SQL Programming

Proprietary Extensions for Trees He is an independent consultant based in Austin, Texas. Principles of Transaction Processing Philip A. For some people, that might be a great way to learn. 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 wayside.

Nov 08, Joana rated it really liked it Shelves: Dispatched from the UK in 1 business day When will my order arrive? Offers tips for working around system deficiencies.