Table of Contents


db2 9 fundamentals certification study guide, first edition (exam 730)
DB2 9 Fundamentals Certification Study Guide, First Edition (Exam 730)
byRoger E. Sanders
MC Press 2007 (658 pages)
ISBN:9781583470725

Regardless of what future certification path the reader is planning on pursuing, this study guide forms the foundation for understanding the newest version of IBM's flagship database product.

Table of Contents
DB2 9 Fundamentals Certification Study Guide, First Edition
About This Book
Foreword
Preface
Chapter 1 - IBM DB2 9 Certification
Chapter 2 - Planning
Chapter 3 - Security
Chapter 4 - Working with Databases and Database Objects
Chapter 5 - Working with DB2 Data Using SQL and XQuery
Chapter 6 - Working with DB2 Tables, Views, and Indexes
Chapter 7 - Database Concurrency
Appendix A - DB2 9 Fundamentals Exam (Exam 730) Objectives
Appendix B - Sample Test
Index
List of Figures
List of Tables


Back Cover

Starting with the certification process itself and ending with the concept of isolation levels and locking, this guide covers everything needed to know to pass the DB2 9 Fundamentals Certification Exam (Exam 730). The prerequisite for all intermediate and follow-on DB2 certifications, XML usage, basic table creation, a rich set of sample questions, and detailed answers are all included, forming the foundation for understanding the newest version of IBM's flagship database product. Regardless of what future certification path the reader is planning on pursuing, this study guide will chart a course for proficiency in DB2 9.

About the Author

Roger E. Sanders is the President of Roger Sanders Enterprises, Inc. He has been designing and developing database applications for more than 20 years and has been working with DB2 and its predecessors since it was first introduced on the IBM PC (as part of OS/2 Extended Edition). He has written articles for publications such as Certification Magazine and IDUG Solutions Journal, authored tutorials for IBM's developerWorks Web site, presented at numerous International DB2 User's Group (IDUG) and Regional DB2 User's Group (RUG) conferences, taught classes on DB2 fundamentals and database administration (DB2 for Linux, UNIX, and Windows), writes a regular column (Distributed DBA) in DB2 Magazine, and is the author of many books.



DB2 9 Fundamentals Certification Study Guide, First Edition

Roger E. Sanders

image from book

image from book

MC Press Online, LP

Lewisville, TX 75077

EXAM 730-IBM Certified Database Associate for DB2 9

  • Covers all the objectives for the DB2 9 Fundamentals exam, including XML data and XQuery expressions

  • Contains 100 sample questions plus a 150-question practice exam, all with comprehensive answers and explanations

  • Written by a member of the DB2 9 Fundamentals certification development team

First Printing-May 2007

© 2007 Roger Sanders.

All rights reserved.

Every attempt has been made to provide correct information. However, the pulisher and the author do not guarantee the accuracy of the book and do not assume responsibility for information included in or omitted from it.

The following terms are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both: DB2, Lotus, Tivoli, WebSphere, Rational, IBM, the IBM logo, and IBM Press. Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. Microsoft, Windows, Windows NT, and the Windows logo are trademarks of the Microsoft Corporation in the United States, other countries, or both. Linux is a registered trademark of Linus Torvalds. Intel, Intel Inside (logo), MMX, and Pentium are trademarks of Intel Corporation in the United States, other countries, or both. OSF/1 and UNIX are registered trademarks and The Open Group is a trademark of the The Open Group in the United States and other countries. Other company, product, or service names mentioned herein may be trademarks or service marks their respective owners.

Printed in Canada. All rights reserved. Thie publication is protected by copyright, and permission mut be obtained from the publisher prior to any prohibited reporduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recordsing, or likewise.

MC Press offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales, which may include custom covers and content particular to your business, training goals, marketing focus, and branding interest.

For information regarding permissions or special orders, please contact:

  • MC Press
    Corporate Offices
    125 N. Woodland Trail
    Lewisville, TX 75077 USA

For information regarding sales and/or customer service, please contact:

  • MC Press
    P.O. Box 4300
    Big Sandy, TX 75755-4300 USA

ISBN: 1-58347-072-7

Dedication

To a good friend who has always been there when I needed him, Rev. Ross Marion

Acknowledgments

A project of this magnitude requires both a great deal of time and the support of many different individuals. I would like to express my gratitude to the following people for their contributions:

  • Susan Dykman-Information Management Certification Program Manager, IBM Information Management
    Susan invited me to participate in the DB2 9 exam development process, and provided me with screen shots of the IBM Certification Exam Testing software. Susan also reviewed the first chapter of the book and provided valuable feedback.

  • Susan Visser-IBM Press, Data Management Program Manager IBM Toronto Lab
    Once again, Susan's help was invaluable-without her help, this book would not have been written. Susan paved the way for me to acquire the rights to the Version 8.1 manuscript and move to MC Press when Pearson Education decided not to publish an updated version of my Version 8.1 book.

  • Dr. Arvind Krishna-Vice President, IBM Data Servers and Worldwide Information Management Development
    Dr. Krishna provided me with the Foreword for this book.

  • Brant Davison-Program Director, IBM Information Management Software
    Brant worked with Dr. Ambuj Goyal, Dr. Arvind Krishna, and me to ensure that IBM received the materials they needed to write the Foreword, and to make sure I received the Foreword for this book in a timely manner.

  • Rick Swagerman-Senior Technical Manager, DB2 SQL and Catalog Development IBM Toronto Lab
    Rick provided me with detailed examples illustrating how the UPDATE/DELETE NO ACTION and UPDATE/DELETE RESTRICT rules of referential constraints work. His examples were converted into some of the illustrations you see in Chapter 6, and Rick reviewed the final draft of many of these drawings for accuracy and completeness.

I would also like to thank my wife, Beth, for her help and encouragement, and for once again overlooking all of the things that did not get done while I worked on yet another book.

About the Author

image from book

Roger E. Sanders is the President of Roger Sanders Enterprises, Inc. He has been designing and developing database applications for more than 20 years and has been working with DB2 and its predecessors since it was first introduced on the IBM PC (as part of OS/2 Extended Edition). He has written articles for publications such as Certification Magazine and IDUG Solutions Journal, authored tutorials for IBM's developerWorks Web site, presented at numerous International DB2 User's Group (IDUG) and Regional DB2 User's Group (RUG) conferences, taught classes on DB2 fundamentals and database administration (DB2 for Linux, UNIX, and Windows), writes a regular column (Distributed DBA) in DB2 Magazine, and is the author of the following books:

  • Using the IBM System Storage N Series with Databases (IBM RedBook; co-author)

  • Integrating IBM DB2 with the IBM System Storage N Series (IBM RedBook; co-author)

  • Using IBM DB2UDB with IBM System Storage N Series (IBM RedBook; co-author)

  • DB2 Universal Database V8.1 Certification Exam 703 Study Guide

  • DB2 Universal Database V8.1 Certification Exam 701 and 706 Study Guide

  • DB2 Universal Database V8.1 Certification Exam 700 Study Guide

  • DB2 UDB Exploitation of NAS Technology (IBM RedBook; co-author)

  • All-In-One DB2 Administration Exam Guide

  • DB2 Universal Database SQL Developer's Guide

  • DB2 Universal Database API Developer's Guide

  • DB2 Universal Database Call Level Interface Developer's Guide

  • ODBC 3.5 Developer's Guide

  • The Developer's Handbook to DB2 for Common Servers

In addition, Roger holds the following professional certifications:

  • IBM Certified Database Administrator-DB2 9 DBA for Linux, UNIX, and Windows

  • IBM Certified Database Associate-DB2 9 Fundamentals

  • IBM Certified Advanced Database Administrator-DB2 Universal Database V8.1 for Linux, UNIX, and Windows

  • IBM Certified Database Administrator-DB2 Universal Database V8.1 for Linux, UNIX, and Windows

  • IBM Certified Developer-DB2 Universal Database V8.1 Family

  • IBM Certified Database Associate-DB2 Universal Database V8.1 Family

  • IBM Certified Advanced Technical Expert-DB2 for Clusters

  • IBM Certified Solutions Expert-DB2 UDB V7.1 Database Administration for UNIX, Windows, and OS/2

  • IBM Certified Solutions Expert-DB2 UDB V6.1 Application Development for UNIX, Windows, and OS/2

  • IBM Certified Specialist-DB2 UDB V6/V7 User