SQL a Beginner's Guide.pdf

SQL

A Beginner’s Guide

Third Edition

Andy Oppel

Robert Sheldon

New York Chicago San Francisco

Lisbon London Madrid Mexico City

Milan New Delhi San Juan

Seoul Singapore Sydney Toronto

permitted under the United States 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.

0-07-154865-3

The material in this eBook also appears in the print version of this title: 0-07-154864-5.

All trademarks are trademarks of their respective owners. Rather than put a trademark symbol after every occurrence of a trademarked

name, we use names in an editorial fashion only, and to the benefit of the trademark owner, with no intention of infringement of the

trademark. Where such designations appear in this book, they have been printed with initial caps.

McGraw-Hill eBooks are available at special quantity discounts to use as premiums and sales promotions, or for use in corporate training

programs. For more information, please contact George Hoare, Special Sales, at george_hoare@mcgraw-hill.com or (212) 904-4069.

This is a copyrighted work and The McGraw-Hill Companies, Inc. (“McGraw-Hill”) and its licensors reserve all rights in and to the work.

Use of this work is subject to these terms. Except as permitted under the Copyright Act of 1976 and the right to store and retrieve one copy

of the work, you may not decompile, disassemble, reverse engineer, reproduce, modify, create derivative works based upon, transmit,

distribute, disseminate, sell, publish or sublicense the work or any part of it without McGraw-Hill’s prior consent. You may use the work

for your own noncommercial and personal use; any other use of the work is strictly prohibited. Your right to use the work may be

terminated if you fail to comply with these terms.

THE WORK IS PROVIDED “AS IS.” McGRAW-HILL AND ITS LICENSORS MAKE NO GUARANTEES OR WARRANTIES AS TO

THE ACCURACY, ADEQUACY OR COMPLETENESS OF OR RESULTS TO BE OBTAINED FROM USING THE WORK, INCLUD-

ING ANY INFORMATION THAT CAN BE ACCESSED THROUGH THE WORK VIA HYPERLINK OR OTHERWISE, AND

EXPRESSLY DISCLAIM ANY WARRANTY, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO IMPLIED WAR-

RANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. McGraw-Hill and its licensors do not warrant or

guarantee that the functions contained in the work will meet your requirements or that its operation will be uninterrupted or error free.

Neither McGraw-Hill nor its licensors shall be liable to you or anyone else for any inaccuracy, error or omission, regardless of cause, in the

work or for any damages resulting therefrom. McGraw-Hill has no responsibility for the content of any information accessed through the

work. Under no circumstances shall McGraw-Hill and/or its licensors be liable for any indirect, incidental, special, punitive, consequential

or similar damages that result from the use of or inability to use the work, even if any of them has been advised of the possibility of such

damages. This limitation of liability shall apply to any claim or cause whatsoever whether such claim or cause arises in contract, tort or

otherwise.

DOI: 10.1036/0071548645

About the Authors

Andrew (Andy) J. Oppel is a proud graduate of the Boys’ Latin School of Maryland and of

Transylvania University (Lexington, Kentucky) where he earned a BA in computer science

in 1974. Since then he has been continuously employed in a wide variety of information

technology positions, including programmer, programmer/analyst, systems architect, project

manager, senior database administrator, database group manager, consultant, database designer,

data modeler, and data architect. In addition, he has been a part-time instructor with the

University of California (Berkeley) Extension for over 20 years, and received the Honored

Instructor Award for the year 2000. His teaching work included developing three courses for

UC Extension, “Concepts of Database Management Systems,” “Introduction to Relational

Database Management Systems,” and “Data Modeling and Database Design.” He also earned

his Oracle 9i Database Associate certification in 2003. He is currently employed as a senior data

modeler for Blue Shield of California. Aside from computer systems, Andy enjoys music (guitar

and vocals), amateur radio (Pacific Division vice director, American Radio Relay League) and

soccer (referee instructor, U.S. Soccer).

Andy has designed and implemented hundreds of databases for a wide range of applications,

including medical research, banking, insurance, apparel manufacturing, telecommunications,

wireless communications, and human resources. He is the author of Databases Demystified

(McGraw-Hill/Osborne, 2004) and SQL Demystified (McGraw-Hill/Osborne, 2005). His database

product experience includes IMS, DB2, Sybase, Microsoft SQL Server, Microsoft Access,

MySQL, and Oracle (versions 7, 8, 8i, 9i, and 10g).

Robert Sheldon has worked as a consultant and technical writer for a number of years.

As a consultant, he has managed the development and maintenance of web-based and client-

server applications and the databases that supported those applications. He has designed and

implemented various Access and SQL Server databases and has used SQL to build databases,

create and modify database objects, query and modify data, and troubleshoot system- and

data-related problems. Robert has also written or cowritten eight books on various network

and server technologies, one of which received a Certificate of Merit from the Puget Sound

Chapter of the Society for Technical Communication. In addition, two of the books that

Robert has written focus exclusively on SQL Server design and implementation. Robert

has also written and edited a variety of other documentation related to SQL databases and

other computer technologies. His writing includes material outside the computer industry—

everything from news articles to ad copy to legal documentation—and he has received two

awards from the Colorado Press Association.

About the Technical Editor

James Seymour is a graduate of the University of North Carolina at Chapel Hill with a BA in

history and political science and the University of Kentucky with a MA in history. He became

first involved with computer technology in 1965 with the mainframe environment at North

Carolina. While in the United States Army during the Vietnam War, he was on the small team

that worked with the mainframe setup at the Pentagon for various military strategic scenarios.

Since 1972, he has been involved in varied computer environments with the second point-of-sale

and inventory control project in the retail industry, analytical programs and database initiatives in

the insurance and benefits industries, loss control startups, and other inventory control and sales

tracking projects throughout many different industries.

From 1987 through 1995, James was an instructor of database management in the community

college system of the state of Kentucky. In this capacity, he created the first database management

and C programming courses in the state of Kentucky and helped both public and private entities

with urgent training needs, including the programming of guidance systems on cruise missiles for

Desert Storm.

Before 1985, he was a system administrator, network administrator, programmer, and

database administrator. Since 1985, James has been a senior database administrator working

primarily with DB2 and Oracle DBMSs on multiple platforms including SQL Server

beginning with version 7.0. He is currently the senior database administrator and data

architect for a Fortune 100 company overseeing major projects in the United States, Canada,

and the United Kingdom.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: