Instant SQL Programming (Paperback)

~ (Author)

Editorial Reviews

Product Description

SQL--Structured Query Language--is the language all relational databases use to make enquiries. This essential book teaches SQL programming in the shortest possible time. It covers both the ANSI standard as the minimum requirement, and also discusses different implementations. It also serves as a handy reference.

Product Details

• Paperback: 389 pages
• Publisher: Wrox Press (August 1995)
• Language: English
• ISBN-10: 1874416508
• ISBN-13: 978-1874416500
• Product Dimensions: 9.2 x 7 x 1.4 inches
• Shipping Weight: 1.8 pounds
• Average Customer Review: 3.2 out of 5 stars  See all reviews (23 customer reviews)
• Amazon.com Sales Rank: #849,508 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

19 of 19 people found the following review helpful:

2.0 out of 5 stars Definitely NOT FOR BEGINNERS, January 14, 1999

By A Customer

I bought this book after reading several favorable recommendations. Unfortunately, they were all from people who had some prior knowledge of SQL and "assumed" that this book would be good for beginners, because it made complete sense to them when they read it.

Having no SQL knowledge whatsoever, I had a hard time trying to fish out little SQL code tidbits that I could run myself, and thereby learn by doing. This book really discourages that. (See the reader review from 1998-04-10.)

If you are new to SQL, try Teach Yourself SQL in 24 hours (don't let the title throw you) from Sam's Publishing, which I found to be much better suited for neophytes.

Also, the author is member of Ansi SQL standards committee, and it shows. He talks about esoteric SQL topics, i.e. comparing facets of SQL-92 to sQL-89, etc. Not only does this get in the way of the useful content, it is usually an irrelevant distraction that the reader could do without.

19 of 19 people found the following review helpful:

2.0 out of 5 stars Not good for people looking for their first book on SQL, April 10, 1998

By A Customer

Most people who are looking to learn SQL want explanations of SQL and examples. A nice plus is to have strategies for making your SQL run as efficiently as possible.

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.

7 of 7 people found the following review helpful:

1.0 out of 5 stars Not a good book for learning SQL, April 14, 1999

By A Customer

This book reads like a compilation of notes and papers from some standards conference. The author comes off as very full of himself and doesn't need to be bothered by giving practical content to this theory.

Much of the useful information is hidden in the author's syntax notation.

This book is too confusing for a beginner and too shallow for a pro. There is nothing "Instant" about this book. I am very disappointed with this WROX publication