SQL: The Complete Reference, Second Edition [Paperback]

James Groff (Author), Paul Weinberg (Author)

Book Description

ISBN-10: 0072225599 | ISBN-13: 978-0072225594 | Publication Date: August 28, 2002 | Edition: 2nd

Learn all you need to know about SQL with this one-stop resource. Updated to include information on Web services and XML, this complete guide also comes with a Windows 2000- and XP- compatible CD containing 4 databases (SQL Server 2000, IBM DB2 Version 7.2, Sybase, and mySQL).

Editorial Reviews

From the Back Cover

The Most Comprehensive SQL Resource Available

Get in-depth details on all the powerful features and capabilities of SQL inside this one-stop guide. Featuring broad coverage of every aspect of this leading database language, this book provides you with an overview of SQL then shows you how to retrieve and update data, program with SQL, use stored procedures, and much more. Covering emerging standards and new related technologies including XML, Web services, EJB, J2EE, and JDBC, this book will help you gain the knowledge and essential skills you need to effectively work with SQL. Comprehensive, organized, and practical, this is the ultimate guide to understanding and using SQL.

• Master SQL basics and use simple, multi-table, and summary queries
• Understand key concepts and the latest developments in relational database technology
• Set up and manage SQL-based databases and write programs to access them
• Create and use the sample database to run the SQL query examples in the book
• Find out about Xpath, Xquery, and other XML-based database query standards
• Discover how J2EE-based applications relate to data management
• Use and program SQL databases with application servers to create powerful Web applications
• Preview the future of SQL--including MySQL and the impact of XML and Web Services

About the Author

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

Paul N. Weinberg and James R. Groff are the authors of Using SQL, the book on which this guide is based. They were also the cofounders of Network Innovations Corporation, developers of SQL-based network software. Groff speaks and writes on SQL and UNIX topics. Weinberg is currently a developer at Apple Computer Corporation.

Product Details

• Paperback: 1080 pages
• Publisher: McGraw-Hill Osborne Media; 2nd edition (August 28, 2002)
• Language: English
• ISBN-10: 0072225599
• ISBN-13: 978-0072225594
• Product Dimensions: 9.1 x 7.2 x 2.3 inches
• Shipping Weight: 4 pounds
• Average Customer Review: 3.9 out of 5 stars  See all reviews (31 customer reviews)
• Amazon Best Sellers Rank: #654,691 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

45 of 49 people found the following review helpful:

5.0 out of 5 stars An Almost Complete SQL Reference, October 18, 2000

By 

"schapel" (Hillsborough, NJ USA) - See all my reviews

This review is from: SQL: The Complete Reference (Paperback)

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.

37 of 41 people found the following review helpful:

3.0 out of 5 stars Out of date, March 18, 2004

By 

Leslie R. Hayden "spacegeek" (East Lansing, MI United States) - See all my reviews
(REAL NAME)   

This review is from: SQL: The Complete Reference, Second Edition (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.

37 of 42 people found the following review helpful:

5.0 out of 5 stars Will Keep You Out of Trouble, September 16, 2000

By 

"kimberlydaniels" (Chapel Hill, NC USA) - See all my reviews

This review is from: SQL: The Complete Reference (Paperback)

First let me tell you why NOT TO BUY this book: You want to learn how to create SQL statements- there are lots of SQL manuals that are better, and easier to use as a reference because they are lighter in pounds. You want to learn advanced issues in creating a database- if you are that advanced you should buy a book about the particular issue you need help with.

Now let me to you WHY TO BUY this book: If you are just building databases complex enough to get into real trouble (and that happens a lot sooner than you may think) you must read this book. It gives an overview of all the problems you need to think about. Very simple databases can get into trouble if you aren't very careful about data integrity and security. This book will raise warning-flags in your head- to find out what do about those warning-flags, however, you may need to go to a book specifically about your application or problem.