Amazon.co.uk Review
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, as demonstrated by a section on common database tasks (how to specify decimal precision, for example). 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-MB download marathon. --David Wall
Product Description
From the Publisher
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.
From the Back Cover
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
0201447878B04062001
About the Author
Judith S. Bowman has been a database professional since the early 1980s. She is currently an independent consultant specializing in SQL and relational database issues and is the author of Practical SQL: The Sequel (Addison-Wesley, 2001). Sandra L. Emerson is an independent consultant and former Vice President of Publishing Programs for Sybase. Marcy Darnovsky, teaches at colleges throughout the San Francisco Bay area. She was formerly at Sybase.
0201447878AB04062001
Excerpted from The Practical Sql Handbook : Using Structured Query Language by Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky. Copyright © 1996. Reprinted by permission. All rights reserved
Judith S Bowman, Sandra L Emerson and Marcy Darnovsky
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 Sybase(r) 3.0 SQL Anywhere(tm) Runtime, a full-featured SQL
database. About the Authors
Judith S Bowman
Judith S. Bowman has worked as a database professional since the early 1980s at Sybase and other database companies. She currently works as an
independent database consultant. She is the lead author of all three editions of The Practical SQL Handbook (Addison-Wesley, 1996).
Other Titles by Judith S Bowman Practical SQL: The Sequel (2001) 0-201-61638-6 The Practical SQL Handbook: Using Structured Query Language, (1993) 0-201-62623-3
Sandra L Emerson
Sandra L. Emerson, former Vice President of Publishing Programs for Sybase, Inc., is a consultant.
Other Titles by Sandra L Emerson The Practical SQL Handbook: Using Structured Query Language, (1993) 0-201-62623-3
Marcy Darnovsky
Marcy Darnovsky, formerly with Sybase, Inc., teaches at Bay Area colleges.
Other Titles by Marcy Darnovsky The Practical SQL Handbook: Using Structured Query Language, (1993) 0-201-62623-3
