AnyBook4Less.com
Find the Best Price on the Web
Order from a Major Online Bookstore
Developed by Fintix
Home  |  Store List  |  FAQ  |  Contact Us  |  
 
Ultimate Book Price Comparison Engine
Save Your Time And Money

SQL: The Complete Reference, Second Edition

Please fill out form in order to compare prices
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
Your Country
Currency
Delivery
Include Used Books
Are you a club member of: Barnes and Noble
Books A Million Chapters.Indigo.ca

Average Customer Rating: 4.12 (24 reviews)

Customer 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.

Similar Books:

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

Powered by Apache