 |
 |
SQL: The Complete Reference, Second Edition
by James R. Groff, Paul N. Weinberg, Lyssa Wald
List Price: $59.99
Our Price: $41.99
ISBN: 0072225599
Publisher: McGraw-Hill Osborne Media (28 August, 2002)
Edition: Paperback
Sales Rank: 26,979
Average Customer Rating: 4.12 out of 5
|
Buy now directly from Amazon.com
|
|

 |  |  |
 |
 |  | Customers Reviews: |  |  |
 |  |
Rating: 5 out of 5
An Almost Complete SQL Reference
The title of this book says it all: it's an extremely complete reference to the SQL language. It covers the SQL-89 and SQL2 standards and indicates the features found in SQL2 but not in SQL-89. It covers not only basic SQL data definition, queries, and updates, but also advanced topics such as transaction processing, security, embedded SQL, stored procedures, and object-oriented databases. It also explains how some of the more popular DBMSs vary from or extend standard SQL.There are some places where the information on SQL is not quite complete. For example, the section on data types doesn't give the sizes of the integer types. As another reviewer mentioned, the section on built-in functions doesn't provide enough information to use some of the more rarely used functions. But these omissions are minor; overall, the completeness of information on SQL is quite impressive. If you're totally new to relational databases, and you need to design a database schema, you'll want to also get a book on database modeling and normalization, because these topics are not covered. But if you know relational databases or merely need to write queries and updates on an existing database, this book will be more than adequate. In addition, if you want to access a database from Java or Perl, you'll also want a book on JDBC or DBI, respectively. Perhaps a future edition of the book will cover these topics in the SQL APIs chapter, but they're probably too new to have made it into this edition.
Rating: 5 out of 5
Excellent book.
I had no previous experience in SQL and I needed to learn it fast for my job. I chose this book because it got good reviews, and I have no regrets that I bought it. The book is excellent for beginners as well as intermediate level programmers. The material is presented clearly and logically, and explanations and examples are very helpful. I would highly recommend this book to everyone who wants to learn SQL as well as to everyone who is looking for a good reference book.
Rating: 4 out of 5
Good, but could have been great
This book is, at the same time, too complete and not complete enough. The entire back half of it deals with things I'll never need, but when it came time to learn the functions, there was hardly any discussion. I've noted that this is the major gripe of other people as well.Still, it's many, many, many simple examples are very helpful to a novice/intermediate user such as myself, and I've found it easy to follow because of them.
|  |  |
 |  |  |
 |
|
| Please note: |
Checkout and payment processing is done safely and securely through Amazon.com. |
| Prices (as shown) are subject to change without notice and cannot be guaranteed. |
|
|  |