SQL The Complete Reference.pdf

ISBN: 0072118458

An encyclopedic reference guide to the SQL database

language for both technical and non-technical readers.

Table of Contents

Colleague Comments

Back Cover

Synopsis by Dean Andrews

What is SQL and where did it come from? How do the SQL tools vary across

database applications from different vendors? How will SQL change in the

future? You'll find the answers to all these questions and many more in SQL:

The Complete Reference . Much more than just a listing of SQL commands

and their parameters, this encyclopedic reference guide explains the concepts

and constructs of SQL programming such that non-technical readers will

understand them and technical readers won't be bored.

Table of Contents

SQL

- The Complete Reference - 4

Part I An Overview of SQL

Chapter 1 - Introduction - 8

Chapter 2 - A Quick Tour of SQL - 15

Chapter 3 - SQL In Perspective - 22

Chapter 4 - Relational Databases - 38

Part II Retrieving Data

Chapter 5 - SQL Basics - 51

Chapter 6 - Simple Queries - 69

Chapter 7 - Multi-Table Queries (Joins) - 101

Chapter 8 - Summary Queries - 136

Chapter 9 - Subqueries and Query Expressions - 158

Part III Updating Data

Chapter 10 - Database Updates - 196

Chapter 11 - Data Integrity - 211

Chapter 12 - Transaction Processing - 236

Part IV Database Structure

Chapter 13 - Creating a Database - 256

Chapter 14 - Views - 290

Chapter 15 - SQL Security - 304

- 2 -

SQL: The Complete Reference

by James R. Groff and Paul N. Weinberg

Preface - 6

Chapter 16 - The System Catalog - 321

Part V Programming with SQL

Chapter 17 - Embedded SQL - 344

Chapter 18 - Dynamic SQL* - 387

Chapter 19 - SQL APIs - 430

Part VI SQL Today and Tomorrow

Chapter 20 - Database Processing and Stored Procedures - 435

Chapter 21 - SQL and Data Warehousing - 535

Chapter 22 - SQL Networking and Distributed Databases - 546

Chapter 23 - SQL and Objects - 575

Chapter 24 - The Future of SQL - 602

Part VII Appendices

Appendix A - The Sample Database - 612

Appendix B - Database Vendor Profiles - 616

Appendix C - Company and Product List - 629

Appendix D - SQL Syntax Reference - 634

Appendix E - SQL Call Level Interface - 635

Appendix F - SQL Information Schema Standard - 651

Appendix G - CD-ROM Installation Guide - 667

Back Cover

Gain the working knowledge of SQL and relational databases essential for

today's information systems professionals. Relational databases built on the

SQL database language are the foundation for modern enterprise data

processing and are also a force behind many of today's important technology

trends.

SQL: The Complete Reference provides an in-depth discussion of SQL

fundamentals, modern SQL products, and SQL's role in trends such as data

warehousing, "thin-client" architectures, and Internet-based e-commerce. This

book is your one-stop resource for all you need to know about SQL. It will help

you:

• Learn the key concepts and latest developments in relational

database technology

• Master the industry-standard SQL language for managing database

information

• Understand the differences among all the leading brands of DBMS

systems

• Set up and manage SQL-based databases and write programs to

access them

• Understand how to use and program SQL databases with application

servers and the Web to create e-commerce applications

• Find out more about the proposed SQL3 standard and the key trends

in object technologies, 64-bit architectures, distributed databases, 3-

tier Internet applications, and more

About the Authors

James R. Groff and Paul N. Weinberg were the co-founders of Network

Innovations Corporation, an early developer of SQL-based networking

- 3 -

software that links personal computers to corporate databases. Groff is

currently CEO of TimesTen Performance Software, developer of an ultra-high

performance main-memory SQL database for communications and Internet

applications. Weinberg is vice president of A2i, Inc., developer of a database-

driven, cross-media catalog publishing system that supports printed and

electronic output from a single data source.

SQL: The Complete Reference

James R. Groff

Paul N. Weinberg

Publisher

Brandon A Nordin

Associate Publisher and Editor-in-Chief

Senior Acquisitions Editor

Acquisitions Editor

Jane K. Brownlow

Project Editor

Editorial Assistant

Monica Faltiss

Copy Editor

Nancy Crumpton

Proofreader

Indexer

Valerie Robbins

Computer Designer

Michelle Galicia

Illustrators

Robert Hansen

Brian Wells

Beth Young

- 4 -

Scott Rogers

Wendy Rinaldi

Heidi Poulin

Rhonda Holmes

Jani Beckwith

Osborne/ McGraw-Hill

Berkeley, California 94710

U.S.A.

For information on translations or book distributors outside the U.S.A., or to arrange bulk

purchase discounts for sales promotions, premiums, or fund-raisers, please contact

Osborne/ McGraw-Hill at the above address.

United States of America. Except as permitted under the Copyright Act of 1976, no part

of this publication may be reproduced or distributed in any form or by any means, or

stored in a database or retrieval system, without the prior written permission of the

publisher, with the exception that the program listings may be entered, stored, and

executed in a computer system, but they may not be reproduced for publication.

Licensed Materials - Property of IBM

U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by

GSA ADP schedule Contract with IBM Corp.

Corporation or its affiliates and is registered in the U.S. and some other jurisdictions.

Microsoft® SQL Server ™ 7.0 Evaluation Edition. Copyright Microsoft Corporation, 1997-

1234567890 DOC DOC 90198765432109

ISBN 0-07-211845-8

Information has been obtained by Osborne/ McGraw-Hill from sources believed to be

reliable. However, because of the possibility of human or mechanical error by our

sources, Osborne/ McGraw-Hill , or others, Osborne/ McGraw-Hill does not guarantee the

accuracy, adequacy, or completeness of any information and is not responsible for any

errors or omissions or the results obtained from use of such information.

Acknowledgments

Special thanks to Matan Arazi for doing such an exceptional job assembling the Bonus

CD-ROM. He pulled off a real miracle to squeeze all five SQL, DBMS products onto a

single CD, a technical feat that would not have been possible without his diligent tenacity

Thanks also to everyone at Osborne for pulling it all together, including Jane Brownlow and

Wendy Rinaldi for doing tag-team duty as our acquisitions editors, and to Heidi Poulin for

her meticulous attention to detail.

- 5 -

2600 Tenth Street

IBM® DB2® Universal Database Personal Edition, Version 5.2, for the Windows®

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: