databases_a_beginners_guide.pdf

(9783 KB) Pobierz
www.it-ebooks.info
Databases:
A Beginner’s Guide
www.it-ebooks.info
Andrew J. (Andy) 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 served as a part-time instructor
with the University of California, Berkeley, Extension for more than 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. In addition to 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 Professional, 2004) and
SQL Demystified
(McGraw-Hill Professional, 2005), and is co-author of
SQL: A Beginner’s Guide
(McGraw-Hill Professional, 2009). His database product experience includes IMS, DB2,
Sybase ASE, Microsoft SQL Server, Microsoft Access, MySQL, and Oracle (versions 7,
8, 8i, 9i, and 10g).
If you have any comments, please contact Andy at andy@andyoppel.com.
About the Author
About the Technical Editor
Todd Meister
has been developing using Microsoft technologies for more than ten years.
He’s been a Technical Editor on more than 50 books with topics ranging from SQL Server
to the .NET Framework. In addition to technical editing, he serves as an Assistant Director
for Computing Services at Ball State University in Muncie, Indiana. He lives in central
Indiana with his wife, Kimberly, and their four incredible children. Contact Todd at
tmeister@sycamoresolutions.com.
www.it-ebooks.info
Databases:
Andrew J. Oppel
A Beginner’s Guide
New York Chicago San Francisco
Lisbon London Madrid Mexico City
Milan New Delhi San Juan
Seoul Singapore Sydney Toronto
www.it-ebooks.info
Copyright © 2009 by The McGraw-Hill Companies. All rights reserved. Except as 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.
ISBN: 978-0-07-160847-3
MHID: 0-07-160847-8
The material in this eBook also appears in the print version of this title: ISBN: 978-0-07-160846-6, MHID: 0-07-160846-X.
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 cor-
porate training programs. To contact a representative please visit the Contact Us page at www.mhprofessional.com.
Information has been obtained by McGraw-Hill from sources believed to be reliable. However, because of the possibility of
human or mechanical error by our sources, McGraw-Hill, or others, 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 the use of
such information.
TERMS OF USE
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 WAR-
RANTIES AS TO THE ACCURACY, ADEQUACY OR COMPLETENESS OF OR RESULTS TO BE OBTAINED FROM
USING THE WORK, INCLUDING ANY INFORMATION THAT CAN BE ACCESSED THROUGH THE WORK VIA
HYPERLINK OR OTHERWISE, AND EXPRESSLY DISCLAIM ANY WARRANTY, EXPRESS OR IMPLIED, INCLUD-
ING BUT NOT LIMITED TO IMPLIED WARRANTIES 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 there-
from. McGraw-Hill has no responsibility for the content of any information accessed through the work. Under no circum-
stances 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 con-
tract, tort or otherwise.
www.it-ebooks.info
Zgłoś jeśli naruszono regulamin