DB2® Universal Database V8.1 Certification Exam 700 Study Guide [Paperback]

Roger E. Sanders (Author)

Book Description

Publication Date: October 9, 2003 | ISBN-10: 0131424653 | ISBN-13: 978-0131424654 | Edition: 1

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.

Editorial Reviews

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.

Product Details

• Paperback: 448 pages
• Publisher: IBM Press; 1 edition (October 9, 2003)
• Language: English
• ISBN-10: 0131424653
• ISBN-13: 978-0131424654
• Product Dimensions: 9 x 6 x 1.2 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.6 out of 5 stars  See all reviews (16 customer reviews)
• Amazon Best Sellers Rank: #1,139,631 in Books (See Top 100 in Books)

More About the Author

Roger E. Sanders is the President of Roger Sanders Enterprises, Inc. and a Senior Consultant Corporate Systems Engineer with EMC Corporation. He has been working with DB2 for Linux, UNIX, and Windows since it was first introduced on the IBM PC (as part of OS/2 1.3 Extended Edition) and is the author of twenty-two books on relational database technology (twenty-one books are on DB2 and one book is on ODBC). For the past nine years, Roger has authored the Distributed DBA column in IBM Data Management Magazine (formerly DB2 Magazine) and, over a fourteen year period, he has written numerous tutorials and articles for IBM's developerWorks website as well as for publications like Certification Magazine and IDUG Solutions Journal (the official magazine of the International DB2 User's Group). In 2008, 2009, 2010, and 2011, Roger was recognized as an IBM Champion for his contributions to the IBM Data Management community; in 2010, he was recognized as an IBM developerWorks Contributing Author, and in 2011, he was recognized as an IBM developerWorks Professional Author for his contributions to IBM's developerWorks web site. He lives in Fuquay-Varina, North Carolina (population 39,042).

Customer Reviews

Most Helpful Customer Reviews

6 of 6 people found the following review helpful:

5.0 out of 5 stars Go to the source and learn it the IBM way., September 20, 2004

By 

Eric L. Yen (Covia, CA USA) - See all my reviews

This review is from: DB2® Universal Database V8.1 Certification Exam 700 Study Guide (Paperback)

Bought the book on a Sunday and read it cover to cover in 6 hours. Make sure that you do the quiz at the end of each chapter. It is important to understand the reasoning behind the answer. This book reads easily and covers all the material on the test. Questions on the actual test are very similar to the type of questions in the book. The book also points you to the location for free practice test.

This book helped me pass the test with 95% (you need 61% to pass) a day later.

6 of 6 people found the following review helpful:

4.0 out of 5 stars All You Need, November 19, 2003

By 

W Boudville (Terra, Sol 3) - See all my reviews
(VINE VOICE)    (TOP 1000 REVIEWER)    (HALL OF FAME REVIEWER)    (REAL NAME)   

This review is from: DB2® Universal Database V8.1 Certification Exam 700 Study Guide (Paperback)

With any large commercial software package that has books devoted to teaching it, invariably the vendor will offer an exam. The vendor's stamp of approval on a successful passing grade has a built-in cachet. Well IBM's dB2 is one of the oldest major packages, and it certainly has exams. As is typical in these things, IBM also offers a book on exam preparation.

Naturally comprehensive. Has test questions AND answers. It does not each the theory of relational databases. You need to be clear on this. Now it certainly shows the many SQL options that IBM has implemented in dB2. But here also, you need to know that the book does not really teach SQL either. You are expected to already know SQL and have enough familiarity with dB2. The intent here is to cover the topics that will be in the exam, and do this well enough so that you can find any gaps in your knowledge and remedy these. The focus is strictly utilitarian. Lest you think this is too restrictive, let me note that it is often so with such books, and not just by IBM.

You might be encouraged to know that the book covers just the introductory certification. More advanced exams are outside its purview. For example, in a companion IBM text, "DB2 Version 8 - The Official Guide" by Zikopoulous et al, you can find more difficult topics to master. But if you are time constrained, the Study Guide will be better value.

5 of 5 people found the following review helpful:

4.0 out of 5 stars Great Book, April 4, 2004

By 

ROJY THOMAS (Lewisville, tx United States) - See all my reviews

This review is from: DB2® Universal Database V8.1 Certification Exam 700 Study Guide (Paperback)

If you are planning on taking exam 700 this is the book for you. I took the exam today and to me it feels like the author wrote the actual exam. The practice tests on the book are very similar to the real test, the only thing to watch out are for are that the actual question is a little bit of a variation from your practice test for example on the practice test the VIEW is created using WITH CHECK OPTION but on the real test that option is not there. The only reason I give this book a rating of 4 is that I still believe that couple of review questions on the text book is still wrong. Be sure to take the practice tests on the IBM website, trust me it will help you...