Customer Review

7 of 9 people found the following review helpful
5.0 out of 5 stars Not for Beginners, best for enthusiasts, July 4, 2006
This review is from: Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems) (Paperback)
Don't be tempted to buy this book unless you have at least a year of experience writing complex SQL and a reasonable knowledge of the underlying data structures and database paradigms. In fact the author has a brief gripe about beginners criticising his book as not being suited for them. The book is not designed for beginners. However, if you have a suitable level of experience then this book is a must. Full of technical know-how and the supporting theory or logic in most cases. The kind of knowledge, that takes decades to accumulate, jumps off every page. If you have done a few of those same hard yards you will quickly appreciate the benefit from the distilled experience on offer. The book is written in an easy conversational style that makes even the hardest stretches of logic easy to digest. The short and concise code samples demonstrate the points made in the text very well. Solutions to every day problems are built up step by step, with each step clearly showing the progression of the logic and the potential pitfalls. In short anyone with intermediate SQL skills or higher will get tremendous advantage out of this book, I thoroughly recommend it.

Starting from the theory of database design, the book moves into Normalization, data types operations, statements, views, functions, statistics, series and gaps, arrays, trees, temporal queries, OLAP and optimization (not a complete chapter list). In short many of the same topics you get in an introductory or intermediate level book. However the depth of the coverage and the practicality of the advice and treatments given to the actual problems that dealing with these things entails, sets this book apart. These topics are not a perfunctory explanation of what they are, but a through look at how to deal with the problems you have probably already run into. As a final recommendation this book contains a good set of references to further reading on much of the theory behind the advised treatments. The text judiciously references these other authors and theory without degrading readability.

Pro - Contains the kind of experience you don't have time to suffer for.

Con - Not for Beginners, best for enthusiasts.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Be the first person to comment on this review.

[Add comment]
Post a comment
To insert a product link use the format: [[ASIN:ASIN product-title]] (What's this?)
Amazon will display this name with all your submissions, including reviews and discussion posts. (Learn more)
Name:
Badge:
This badge will be assigned to you and will appear along with your name.
There was an error. Please try again.
Please see the full guidelines here.

Official Comment

As a representative of this product you can post one Official Comment on this review. It will appear immediately below the review wherever it is displayed.   Learn more
The following name and badge will be shown with this comment:
 (edit name)
After clicking the Post button you will be asked to create your public name, which will be shown with all your contributions.

Is this your product?

If you are the author, artist, manufacturer or an official representative of this product, you can post an Official Comment on this review. It will appear immediately below the review wherever it is displayed.  Learn more
Otherwise, you can still post a regular comment on this review.

Is this your product?

If you are the author, artist, manufacturer or an official representative of this product, you can post an Official Comment on this review. It will appear immediately below the review wherever it is displayed.   Learn more
 
System timed out

We were unable to verify whether you represent the product. Please try again later, or retry now. Otherwise you can post a regular comment.

Since you previously posted an Official Comment, this comment will appear in the comment section below. You also have the option to edit your Official Comment.   Learn more
The maximum number of Official Comments have been posted. This comment will appear in the comment section below.   Learn more
Prompts for sign-in
 


Review Details

Item

Reviewer


Location: Morwell, Victoria Australia

Top Reviewer Ranking: 5,487,928