The Practical SQL Handbook: Using Structured Query Language (3rd Edition) [Paperback]

Judith S. Bowman (Author), Sandra L. Emerson (Author), Marcy Darnovsky (Author)

Book Description

ISBN-10: 0201447878 | ISBN-13: 978-0201447873 | Publication Date: October 14, 1996 | Edition: 3

The Practical SQL Handbook is the best-selling guide to learning SQL, the standard language for accessing information in relational databases. This book not only teaches SQL as it has been established by ANSI standards committees but also as the language is used to solve real business problems. You'll learn step-by-step the basic vocabulary and functions of the language and the processes and issues involved in developing robust applications. This book provides a thorough grounding in the basics of database design, security, and integrity. You will learn SQL pragmatically, by creating a sample database and then working through dozens of examples with it. Fully updated to cover the ANSI SQL '92 standard, the third edition of The Practical SQL Handbook includes a cookbook of specific solutions, ready-to-use code, and general strategies for common business database challenges. Find out how to: *create and use views *use and apply subqueries *join tables for comprehensive data analysis *handle null values *create reports using groups and aggregate functions Bonus CD-ROM -- Get Hands-On Practice Using SQL!The CD-ROM includes the Windows 3.x , Windows 95, and Windows NT versions of the SybaseA (R) 3.0 SQL AnywhereaA A Runtime, a full-featured SQL database. 0201447878B04062001

Editorial Reviews

Amazon.com Review

This superb text explains Structured Query Language (SQL) simply without being condescending and deeply without being obscure. From its early chapters about relational database theory to its superb coverage of transaction management, this book is informative and easy to follow.

The authors begin by explaining how to design efficient data structures, an important part of database management. From there, they discuss how to populate a database with pieces of data and then explain how to construct queries that extract needed information. Throughout, the text is filled with statements, code, and output--and even common SQL errors. You ought to be able to follow along on any ANSI SQL 92-compliant system as you read this book.

Later chapters cover reports, joins, views, subqueries, and security. The authors explain each from a practical point of view. A section on common business-database tasks (how to specify decimal precision, for example) confirms this point of view. A good glossary exists in the back of this book, and a comprehensive table documents the differences among Sybase, Microsoft, Informix, and Oracle SQL command sets. The companion CD-ROM contains the Sybase SQL Anywhere Studio software, which ordinarily requires a 15-megabyte download marathon. --David Wall

From the Back Cover

0201447878B04062001

See all Editorial Reviews

Product Details

• Paperback: 454 pages
• Publisher: Pearson Education; 3 edition (October 14, 1996)
• Language: English
• ISBN-10: 0201447878
• ISBN-13: 978-0201447873
• Product Dimensions: 9 x 7.3 x 1.2 inches
• Shipping Weight: 2.3 pounds
• Average Customer Review: 4.4 out of 5 stars  See all reviews (54 customer reviews)
• Amazon Best Sellers Rank: #442,163 in Books (See Top 100 in Books)
  • #43 in Books > Computers & Technology > Programming > Algorithms > Data Structures

Customer Reviews

Most Helpful Customer Reviews

34 of 36 people found the following review helpful:

5.0 out of 5 stars Clearly written introduction to SQL with pertinent examples, December 16, 1999

By 

Jason T Rath (Pasadena, CA) - See all my reviews

This review is from: The Practical SQL Handbook: Using Structured Query Language (3rd Edition) (Paperback)

SQL appears simple, but can easily confuse a beginner. This book has excellent examples of SQL-92 to demonstrate effective SQL commands for the major RDBMSs. It also shows common mistakes and how to avoid them. There is a lot of hand-holding throughout the book, and I found the explanations deliberate and well thought out. But it is not padded with fluff. I've seen books twice as thick and half as effective. Good definitions, queries and results. Topics covered include database design, creating and filling a database, selecting data, sorting, grouping, joins, subqueries, views, an overview of security, transactions, performance, and integrity, real world business problems, and how to avoid mistakes. I read it cover to cover twice and practiced the examples (except the views, which you can't use with the included Sybase SQL Anywhere). This book lays a good foundation to build upon. Possible follow-up books include "Introduction to SQL" by Rick van der Lans (published 1999) and "Joe Celko's SQL for Smarties" by (guess who) (publ. 2000). Good luck!

26 of 27 people found the following review helpful:

5.0 out of 5 stars A Very Complete Introduction to SQL, March 11, 2000

By 

Music Critic (Philadelphia) - See all my reviews

This review is from: The Practical SQL Handbook: Using Structured Query Language (3rd Edition) (Paperback)

I've been using different dialects of SQL for about 6 years now and I've found this book to be a very good resource. If you use SQL enough, you will probably eventually want to get a more advanced book (such as one by Celko), but this book will take you far. It starts off with basic information on relational databases, ER diagrams, and normalization, and, maybe best of all, throughout the book are numerous and clear examples. It pretty much uses one example database for most examples, and it explains the layout of that database at the start. Also, the book is very good about showing where certain details differ between SQL-92 and popular SQL implementations, such as SQL Server (Sybase and Microsoft), SQL Anywhere, Informix, and Oracle PL/SQL. The examples very carefully and very clearly step through potentially confusing areas such as subqueries and existence checking. The emphasis throughout is on - as stated in the title - practical SQL. In summary, I think this book is an excellent learning tool and a good desktop reference.

17 of 17 people found the following review helpful:

5.0 out of 5 stars Excellent Introduction to Relational Databases and SQL, October 18, 2000

By 

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

This review is from: The Practical SQL Handbook: Using Structured Query Language (3rd Edition) (Paperback)

If you know nothing about databases, this book is a great place to start. It explains what a relational database is, how to design and create one, and how to perform updates and queries. It covers just about everything you'll need to know, such as normalization, outer joins, security, and transaction processing. Even though the book sticks with the basics, it covers everything that most SQL programmers will need to know.

One weakness of the book is that it doesn't distinguish which features are part of SQL-89, which are part of SQL2 (aka SQL-92). For some features, such as outer joins, implementation-specific syntax is given without the standard SQL syntax. Because of this, it may be more difficult for readers of this book to write SQL that will work on many different databases.

An important thing to note about this book is that it covers only SQL. That means it doesn't cover stored procedure dialects, embedded SQL, or SQL APIs such as ODBC, JDBC, or DBI. If you're going to actually use SQL, you'll need another reference that explains how to interface with a SQL database.