Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Instant SQL Programming Paperback – August 1, 1995
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Customers who viewed this item also viewed
Customers who bought this item also bought
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
The problem with this book stems from the author's involvement with the group that sets standards for SQL. For example, after providing an example of SQL on page 259, the author states: "This is a legal expression in SQL-92, but isn't yet implemented in many products."
In other words, the example is permitted by the standards group, but you are not likely to be able to use it in Oracle, Sybase, Informix, SQL Server, etc. This type of teaching is quite common among people like the author who, as is noted on the back cover, has been a member of the ANSI X3H2 Database Standards Committee since 1987.
No doubt the book is theoretically correct. But is it practical?
When explaining the GROUP BY clause in SQL, the author gives example SQL that includes the line: GROUP BY partid. People who already know SQL will wonder about this example, because in the book's sample database partid's are unique -- it makes no sense to group them.
People who already know SQL will be lucky enough to realize that this is simply a bad example. But people who are trying to learn will scratch their heads and wonder what the real life purpose of the GROUP BY statement is -- it is not apparent from this example.
Sometimes a teacher who knows his subject very well is unable to explain it in a way that is helpful to beginners. Sometimes a teacher who is caught up in theoretical aspects of his subject is unable to explain it in a practical way. The author has both of these problems.
If you already have a good working knowledge of SQL, you might gain a few insights from this book. But the emphasis here is on the word "few." For example, the chapter on "Optimization and Performance Tips" probably should be retitled, "A Beginner's Guide to Putting an SQL Query Together." To give you an idea of how poor the advice is, the last section of this chapter on optimization and performance has a Bag of Tricks, and Trick #2 is: "Don't use more tables than you have to."
That's it -- that's the complete text of Trick #2! This has to qualify as one of the top ten least helpful SQL tips of the decade. If the author was teaching cooking, I wouldn't be surprised to see this tip: "When cooking food on the stove, don't burn anything."
So, if you are just learning SQL, you can certainly find a better offering than this one. Look for books that provide real life examples. Avoid books, like this one, that go off onto tangents about things that are permitted by the SQL-92 standard but have not been implemented yet in the database you will be using.
If you already know SQL and are looking for advanced tips and tuning ideas, look elsewhere. There are lots of good books brimming with ideas on these topics. This book just isn't one of them.
I bought this book hoping to really learn SQL, but didn't gather too much more from it. Now I have learned SQL more indepth, but still need a good reference book to look up typical "tricks" or common functions. This book is now useless.
On the cover it says "exploit your database's full capacity"...which is entirely misleading because most of the exploits are not covered at all in this book.
Great for beginner to get to intermediate stage of typical SELECT, INSERT, etc...but if you want to do more than typical, this book is NOT for you.
One note - I'm a programmer, not a DBA. So my SQL needs are pretty simple. But if you want a basic reference that covers all of the basics clearly - this is the book.
Most recent customer reviews
However, it is the one I used to learn SQL.Read more
Its getting a little out of date now but even so a good buy.Read more