Learn more Shop now Shop now</arg> Shop now Shop now Shop now Learn More Shop now DIYED Shop now Learn more Shop Fire Shop Kindle Learn More Shop now Shop now

Customer Reviews

3.8 out of 5 stars
10
3.8 out of 5 stars
Your rating(Clear)Rate this item


There was a problem filtering reviews right now. Please try again later.

on 10 March 2007
If you like writing massive stored procedures, using cursors and other non-relational and non standard features of your database then this book probably won't appeal to you much.

Joe Celko puts a lot of effort into showing how you can write high performance and standard SQL without resorting to proprietary hacks. He clearly has a very strong understanding of the underlying theory behind relational databases and uses plenty of examples to explain his points.

I would recommend this book as a very good read to generally improve your overall knowledge of SQL and SQL best practices.
0Comment| 6 people found this helpful. Was this review helpful to you?YesNoReport abuse
on 25 May 1998
This book is not his basic volume in SQL, but his advanced volume. It helps you along explaining different issues with an excellent explanation of NULLS, their pros and their cons. It gives examples of solving problems in different SQL ways. A great buy.
0Comment| 4 people found this helpful. Was this review helpful to you?YesNoReport abuse
on 29 April 1997
Lots of examples of complicated/advanced SQL. Not for people who need to learn SQL.
0Comment| 5 people found this helpful. Was this review helpful to you?YesNoReport abuse
on 19 March 2006
I bought this book as it was mentioned on a couple of SQL users' websites/mailing lists.
I am relatively new to SQL (2yrs experience) and I found the book quite thought provoking and very positive because some of the techniques outlined by Joe Celko are new to me. However it was very positive to see that some things I had already tried were in the book.
Well presented, logical in approach and quite an entertaining read considering SQL is such a dry subject.
0Comment| 2 people found this helpful. Was this review helpful to you?YesNoReport abuse
on 19 April 2016
Excellent contents, but marred slightly by sloppy editing. Quite a surprise that such errors would be so prevalent in the fifth edition of a book, but the exhaustive information makes up for it. Celko provides a huge amount of useful advice on SQL and relational databases, quite remarkable when you consider how he strictly avoids describing specific products, but that gives the book a much greater longevity than one that ties itself to the quirks of specific versions of specific databases.
0Comment|Was this review helpful to you?YesNoReport abuse
on 12 May 2016
I had to swipe backwards and forwards between pages to get to see complete SQL code that spanned pages. A couple of times sentences were repeated. In other cases the grammar just wasn't correct.

Apart from these frustrations it's worth keeping as a reference book and dipping into as well as reading end to end. Plenty of examples to mull over
0Comment|Was this review helpful to you?YesNoReport abuse
on 13 November 2006
Large parts of this book are undoubtedly excellent as the author is intelligent. However, there are many parts where the author expresses opinion without understanding that life in the professional/commercial field is not like in academia. Statements likening sequence generation to drug habits seem extreme to me, and you would be well advised to question the views of the author. Nevertheless there is a lot of valuable information in this book and I do not regret for one moment purchasing it.
0Comment| 2 people found this helpful. Was this review helpful to you?YesNoReport abuse
on 3 May 2015
Good book
0Comment|Was this review helpful to you?YesNoReport abuse
on 26 January 1999
These are interesting techniques in SQL, that can be fun in the office. The problem is that in the real world manufacturers don't implement standard SQL and if you want Advanced SQL then it needs to be specialised. His SQL tricks book is more fun.
0Comment| 2 people found this helpful. Was this review helpful to you?YesNoReport abuse
on 1 November 1996
This book gives many tips for how to structure your database
and about the behavior of some SQL commands (much of which
is common sense anyway), but does
nothing to help the reader actually learn the language.
Examples are scarce and many of them are C code rather than SQL.
I was very disappointed with this book and must continue my
search for an SQL textbook.
0Comment| 2 people found this helpful. Was this review helpful to you?YesNoReport abuse

Need customer service? Click here

Sponsored Links

  (What is this?)