AnyBook4Less.com | Order from a Major Online Bookstore |
![]() |
Home |  Store List |  FAQ |  Contact Us |   | ||
Ultimate Book Price Comparison Engine Save Your Time And Money |
![]() |
Title: SQL: The Complete Reference, Second Edition by James R. Groff, Paul N. Weinberg, Michael Mueller ISBN: 0-07-222559-9 Publisher: McGraw-Hill Osborne Media Pub. Date: 28 August, 2002 Format: Paperback Volumes: 1 List Price(USD): $59.99 |
Average Customer Rating: 4.12 (24 reviews)
Rating: 5
Summary: An Almost Complete SQL Reference
Comment: 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
Summary: Book covers SQL
Comment: Excellent book, I bought it simply because I wanted to have a reference book for SQL syntax. Don't expect this book to teach you about normal forms and whatnot, it covers the ANSI SQL standard (even SQL2) only, thereby, you'd need to pick up a book on normalization.
A note to people starting with databases: this book covers SQL syntax, it contains evaluation versions of SQL Server, DB2, and etc. It doesn't cover the actual DBMS themselves, there are books reserved for that. Lastly, before you buy this book, know the theories of relational database design such as normalization, the ideology behind relational database design is fundamental to database design, administration, and maintenance.
Rating: 4
Summary: Good, but could have been great
Comment: 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.
![]() |
Title: Sams Teach Yourself SQL in 10 Minutes (2nd Edition) by Ben Forta ISBN: 0672321289 Publisher: SAMS Pub. Date: 26 April, 2001 List Price(USD): $14.99 |
![]() |
Title: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez, John L. Viescas ISBN: 0201433362 Publisher: Pearson Educational Pub. Date: 21 August, 2000 List Price(USD): $49.99 |
![]() |
Title: SQL in a Nutshell: A Desktop Quick Reference by Kevin Kline ISBN: 1565927443 Publisher: O'Reilly & Associates Pub. Date: 01 December, 2000 List Price(USD): $29.95 |
![]() |
Title: SQL Bible by Alex Kriegel, Boris M. Trukhnov ISBN: 0764525840 Publisher: John Wiley & Sons Pub. Date: 01 April, 2003 List Price(USD): $49.99 |
![]() |
Title: The Practical SQL Handbook: Using Structured Query Language (3rd Edition) by Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky ISBN: 0201447878 Publisher: Addison-Wesley Pub Co Pub. Date: 14 October, 1996 List Price(USD): $42.95 |
Thank you for visiting www.AnyBook4Less.com and enjoy your savings!
Copyright� 2001-2021 Send your comments