DB2 Universal Database V8.1 Certification Exam 700 Study Guide - Softcover

Sanders, Roger E.

Softcover

ISBN 10: 0131424653 ISBN 13: 9780131424654

Publisher: IBM Press, 2003

Synopsis

This book covers the first "Fundamentals" exam (test 700 (previously test 516)) an individual needs to pass in order to become DB2 UDB Version 8.1 certified. Written by a DB2 UDB Certified author who worked directly with the DB2 UDB Version 8.1 Certification Exam development team and reviewed by the IBM Data Management Certification Program Manager, each book is guaranteed to provide the reader with all of the information needed to pass the V8.1 Certification test 700. Exam-like questions and answers are provided at the end of each chapter and information explaining why each answer provided is correct accompanies every answer given. This is a must-have for any DBA taking the first certification exam.

About this title

From the Back Cover

IBM DB2 Universal Database Certification gives you a powerfuladvantage in the marketplace for expertise on the world’s #1enterprise database platform. Passing IBM DB2 UDB V8.1 FamilyFundamentals Exam 700 earns you the IBM Certified Database Associatecertification and is the prerequisite for all intermediate and follow-oncertifications.

In this book, Roger E. Sanders―one ofthe world’s leading DB2 UDB experts, and an active participant inIBM’s DB2 UDB exam development process―covers everything youneed to know to pass DB2 UDB V8.1 Exam 700. Sanders covers every examobjective, beginning with a review of the DB2 family of tools andproducts, as well as fundamental database concepts such as SQL and dataconsistency.

This comprehensive study guide walks youstep-by-step through deployment planning; database security; SQL; DB2database object creation and management; database concurrency; and muchmore. Every chapter contains an extensive set of practice questionsclosely modeled on the actual exam, along with carefully explainedanswers. Coverage includes:

• Creating and deploying DB2 UDB databases
• Databaseobjects and IBM’s tools for creating, accessing, and manipulatingthem
• Protecting data: controlling access with authentication,authorities, and privileges
• Options and alternatives foraccessing DB2 data
• Using SQL to work with data objects such astables, views, and indexes
• Concurrency: maintaining dataintegrity and consistency in single- and multi-userenvironments

Whatever DB2 certification you’re planning to pursue, DB2 Exam700 is the foundation―and DB2 UDB V8.1 Certification Exam 700Study Guide is the solution.

• The definitive DB2 UDB V8.1 Family Fundamentals exam (Exam 700)preparation guide― straight from IBM
• Planning, security, data access, data objects, concurrency,management tools, SQL, and more
• Extensive sample questions based on the actual exam’s formatand approach
• Authoritative coverage of the DB2 exam and certificationprocess
• By Roger Sanders, best-selling DB2 UDB author andactive participant in IBM’s exam development process

About the Author

Roger Sanders is a Database Performance Engineer with Network Appliance, Inc. He has been designing and programming software applications for IBM PCs for more than 15 years and he has worked with the DB2 Universal Database and its predecessors for the past 10 years. He has written several computer magazine articles, authored a tutorial on Database Concurrency for IBM's DeveloperWorks web site, presented at three IDUG conferences, and is the author of seven DB2 titles (073842522, 0072133759 (best-selling all-in-one exam guide), 0071353895, 007353925, 0071345728, 0070580871, 007057725). Sanders should receive 4 Version 8 certifications before the first Version 8 book even hits the market.

Edition details

• Publisher: IBM Press
• Publication date: 2003
• ISBN 10: 0131424653
• ISBN 13: 9780131424654
• Binding: Paperback
• Language: English
• Number of pages: 448