SQL: The Complete Reference
||Author: James R. Groff, Paul N. Weinberg|
List Price: $49.99
Our Price: Click to see the latest and low price
Publisher: McGraw-Hill Osborne Media (01 March, 1999)
Sales Rank: 5,889
Average Customer Rating: 4.12 out of 5
Customer ReviewsRating: 5 out of 5
Book covers SQL
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 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.
Rating: 1 out of 5
The book is merely a re-package of the first edition; and what makes things worse - none of the errors of the first one were ever fixed:(it still claims, for instance that Oracle's stored procedures params must be declared as VARCHAR(10) - i.e. it must be sized; such syntax could not possibly compile),some examples do not compile..... Appendix shows installation of Informix,DB2 UDB 5.2, Oracle 8 and MS SQL Server 7.0 - from the first edition,while this second edition's disk includes only SQL Server 2000, DB2 7.1 and MySQL; this had undermined my trust in the "up-to-date content", claimed by the preface and the cover. As in the previous edition, it concentrates on the standard SQL, much of which has nothing to do with implementations (e.g. DOMAIN keyword). Chapter on functions lists 7, 9 (?)functions - out of hundreds implemented by RDBMS!
To be true, the book was spiced up with several new chapters on XML, EJB etc - a mile wide, an inch deep in coverage...I'd be better off buying separate books on the subject. I wish I could return it. If you cannot avoid it - buy the first edition and save tens of dollars; or - better yet - look for a different book.
· SQL Bible
· SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
· The Practical SQL Handbook: Using Structured Query Language (3rd Edition)
· SQL in a Nutshell: A Desktop Quick Reference
· Sams Teach Yourself SQL in 10 Minutes (2nd Edition)