The Practical SQL Handbook: Using Structured Query Language

3.83 avg rating
( 59 ratings by Goodreads )
 
9780201447873: The Practical SQL Handbook: Using Structured Query Language
View all copies of this ISBN edition:
 
 

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

"synopsis" may belong to another edition of this title.

Review:

The Practical SQL Handbook 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, 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

From the Publisher:

The best selling guide to learning SQL
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.

"About this title" may belong to another edition of this title.

Other Popular Editions of the Same Title

9780201626230: The Practical SQL Handbook

Featured Edition

ISBN 10: 0201626233 ISBN 13: 9780201626230
Publisher: Addison Wesley, 1994
Softcover

9780201517385: The Practical S. Q. L. Handbook: Using Structured Query Langauge

Addiso..., 1989
Softcover

Top Search Results from the AbeBooks Marketplace

Stock Image

1.

Bowman, Judith S.; Emerson, Sandra L.; Darnovsky, Marcy
Published by Pearson Education (1996)
ISBN 10: 0201447878 ISBN 13: 9780201447873
New Paperback Quantity Available: 1
Seller:
Barnes & Nooyen Books
(Spring, TX, U.S.A.)

Book Description Pearson Education, 1996. Paperback. Condition: New. New Condition, Paperback book, Seller Inventory # 2005090233

More information about this seller | Contact this seller

Buy New
8.37
Convert currency

Add to Basket

Shipping: 3.08
Within U.S.A.
Destination, rates & speeds
Stock Image

2.

Bowman, Judith S.; Emerson, Sandra L.; Darnovsky, Marcy
Published by Pearson Education (1996)
ISBN 10: 0201447878 ISBN 13: 9780201447873
New Paperback Quantity Available: 1
Seller:
Orion Tech
(Grand Prairie, TX, U.S.A.)

Book Description Pearson Education, 1996. Paperback. Condition: New. Seller Inventory # 0201447878-11-7549768

More information about this seller | Contact this seller

Buy New
11.53
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds
Stock Image

3.

Bowman, Judith S., Emerson, Sandra L., Darnovsky, Marcy
ISBN 10: 0201447878 ISBN 13: 9780201447873
New Paperback Quantity Available: 1
Seller:
ABC
(Saint Louis, MO, U.S.A.)

Book Description Paperback. Condition: Brand New. New. Seller Inventory # DH PB29pg252to551-8221

More information about this seller | Contact this seller

Buy New
37.31
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds
Stock Image

4.

Bowman, Judith S.; Emerson, Sandra L.; Darnovsky, Marcy
ISBN 10: 0201447878 ISBN 13: 9780201447873
New Quantity Available: 1
Seller:
BennettBooksLtd
(San Diego, CA, U.S.A.)

Book Description Condition: New. New. Seller Inventory # M-0201447878

More information about this seller | Contact this seller

Buy New
63.48
Convert currency

Add to Basket

Shipping: 3.81
Within U.S.A.
Destination, rates & speeds