Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

SQL: The Complete Reference, Second Edition with CDROM (Complete Reference) [Hardcover]

James R. Groff , Paul N. Weinberg , Michael Mueller
3.5 out of 5 stars  See all reviews (2 customer reviews)

Currently unavailable.
We don't know when or if this item will be back in stock.


Formats

Amazon Price New from Used from
Hardcover --  
Paperback --  

Product details

  • Hardcover
  • Publisher: Tandem Library (Aug 2002)
  • ISBN-10: 0613914643
  • ISBN-13: 978-0613914642
  • Average Customer Review: 3.5 out of 5 stars  See all reviews (2 customer reviews)

More About the Author

Discover books, learn about writers, and more.

Inside This Book (Learn More)
Browse and search another edition of this book.
First Sentence
The SQL language and relational database systems based on it are one of the most important foundation technologies in the computer industry. Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

4 star
0
3 star
0
1 star
0
3.5 out of 5 stars
3.5 out of 5 stars
Most Helpful Customer Reviews
3 of 3 people found the following review helpful
By XS73
Format:Paperback
Whilst this is a complete reference book with examples, there is a real flaw in its structure, especially for novices. The primary problems arise from the ability to access examples on the CD. The first chapters present the user with example SQL queries. This "wets the appetite", making the reader keen to try the examples out. However, you need to load the examples into a database. Not so easy, this requires you to create the database and tables. Okay, so the book shows the SQL code used to create the tables. However, the SQL code has foreign keys that reference the other tables (which you've still to create). So you're in a chicken and egg situation, when you're just at the beginning of the book looking to do some simple "select" statements. This is the most frustrating aspect of this book. Secondly you'll need to make sure you have a development environment such as Windows NT, anything else and installing and running the demo's is a real chore. This book was helpful for reference but needs to provide greater user friendliness to enable you to get working from the first chapters.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Excellent value 13 Nov 2013
Format:Paperback|Verified Purchase
A good, solid text at a very reasonable price. SQL is clearly explained and immediately usable. Was in great condition with cd included.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.6 out of 5 stars  14 reviews
38 of 42 people found the following review helpful
3.0 out of 5 stars Out of date 18 Mar 2004
By Leslie R. Hayden - Published on Amazon.com
Format:Paperback
This book needs a re-write to bring it up to the latest SQL standards. If you are still using Pre-SQL92 systems, this book is a pretty good reference.

However, it leaves out important new information such as the new JOIN syntax.

I recommend you check other texts to ensure this is the *one* that you want.
21 of 25 people found the following review helpful
1.0 out of 5 stars Disapponting re-package 10 Nov 2002
By A Customer - Published on Amazon.com
Format:Paperback
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.
6 of 6 people found the following review helpful
4.0 out of 5 stars Good, but could have been great 11 Sep 2003
By Daniel J. Elmore - Published on Amazon.com
Format:Paperback
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.
7 of 9 people found the following review helpful
5.0 out of 5 stars Book covers SQL 8 Jan 2004
By Brian Maula - Published on Amazon.com
Format:Paperback
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.
2 of 2 people found the following review helpful
5.0 out of 5 stars A prgrammers view 24 April 2007
By D. Seholm - Published on Amazon.com
Format:Paperback
As a C++ programmer that does not know C# or VB I found this book very helpful in conjunction with a book specific to the data base I was writting for.

This book will get you started on generic quiries and a book written on your specific data base will fill in the gaps for you. As mentioned in other reviews this book is not up to date on current standards, but as a primer book which this obviously is, standards can be left to a more case specific book.

But as I just stated the real value that I found in this book was in the programming with SQL section, if you do not know C# or VB and you are trying to write code that pulls or updates data to an SQL data base, good luck doing it without this book, I was able to find virtually no other book written for SQL with C or C++. I got my programming bit from this book, and more efficient data base specific look ups and append commands from another, and all the programs I have written thus far work flawlessly. So for that one section alone this book gets five stars.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback