The Practical SQL Handbook: Using Structured Query Language

Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky

ISBN 10: 0201447878 / ISBN 13: 9780201447873

Published by Addison Wesley 14/10/1996, 1996

About this Item

Shipped within 24 hours from our UK warehouse. Clean, undamaged book with no damage to pages and minimal wear to the cover. Spine still tight, in very good condition. Remember if you are not happy, you are covered by our 100% money back guarantee. Seller Inventory # 6545-9780201447873

Bibliographic Details

Title: The Practical SQL Handbook: Using Structured...

Publisher: Addison Wesley 14/10/1996

Publication Date: 1996

Binding: Soft cover

Condition: Very Good

About this title

Synopsis:

An introduction to relational database management and SQL, concentrating on solving real business problems, for those with no previous knowledge of SQL. The accompanying CD-ROM contains the Windows 3.x, Windows 95, and Windows NT versions of an SQL database. This third edition is updated to cover the ANSI SQL '92 standard, and includes specific solutions, ready-to-use code, and general strategies for common business database challenges. Annotation c. by Book News, Inc., Portland, Or.

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