DB2 Administration All-in-One Exam Guide [Hardcover]

Roger E. Sanders (Author)

Book Description

ISBN-10: 0072133759 | ISBN-13: 978-0072133752 | Publication Date: January 18, 2002

All-in-One is all you need! This authoritative reference offers complete coverage of all material on the three DB2 exams. You'll find exam objectives at the beginning of each chapter, helpful exam tips, end-of-chapter practice questions, and photographs and illustrations. The bonus CD-ROM contains practice tests, and hundreds of questions. This comprehensive guide will not only help you pass the certification exams, but will also serve as an invaluable on-the-job reference.

Editorial Reviews

From the Back Cover

Prepare to pass the DB2 certification exam

Now you can thoroughly prepare for the DB2 certification exams 509, 512, and 513 using this comprehensive reference. This definitive study tool maps out all exam objectives and provides you with key information on database fundamentals. Each chapter is loaded with practice questions and test-taking tips allowing you to maximize your exam prep time. If you're looking for a solid guide to becoming an IBM-certified professional as well as a valuable desk reference then this is the ultimate resource.

Get details on exam objectives as well as:

• Learn fundamentals of administering a DB2 database
• Use the DB2 Command Center effectively
• Create and catalog both local and remote databases
• Utilize the DB2 GUI tools for accessing and manipulating objects
• Manage groups and users
• Differentiate authorization levels
• Examine contents of system catalog tables
• Monitor DB2 activity
• Perform database-level backup and recovery

About the Author

Roger Sanders (Cary, NC) is an Educational Multimedia Specialist at SAS Institute. He has been designing and programming software for more than 15 years and is a regular contributor to DB2 Magazine.

Product Details

• Hardcover: 804 pages
• Publisher: Osborne/McGraw-Hill (January 18, 2002)
• Language: English
• ISBN-10: 0072133759
• ISBN-13: 978-0072133752
• Product Dimensions: 9.4 x 7.7 x 2.2 inches
• Shipping Weight: 4.2 pounds
• Average Customer Review: 4.0 out of 5 stars  See all reviews (10 customer reviews)
• Amazon Best Sellers Rank: #2,380,690 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

11 of 11 people found the following review helpful:

4.0 out of 5 stars DB2 Administration, March 9, 2002

By 

Collin O'Fallon (Seattle Wa) - See all my reviews

This review is from: DB2 Administration All-in-One Exam Guide (Hardcover)

This is an in depth book that covers all the options when refering to SQL, and DB2 commands. It also covers all the topics in a comprehensive manner. I have read the DB2 for dummies and the DB2 Universal Database from IBM, and the All in One DB2 Administration completely outclasses them. However the test enginge cd promises hundreds of questions and fails to deliever. The Practice test and the "real" test are word for word the same...so a big disappointment in this regard.

If you are buying a book to learn the material and ALL the options then this is the book to buy in preparing for the IBM DB2 513 certification. For the 512 I would use this book to study and get the DB2 fundamentals certification for Dummies book for the test engine (it has around 200 + questions).

If you want a Book on performance tuning etc, there are other books out there that will cover this topic in depth much better.

7 of 7 people found the following review helpful:

5.0 out of 5 stars The other reviewers should have bought the'Dummies' book, April 11, 2002

By 

Mark Hayakawa "QuietSunset" (Raleigh, NC) - See all my reviews
(REAL NAME)   

This review is from: DB2 Administration All-in-One Exam Guide (Hardcover)

This is by far the best book I've every used on the subject. I use the book daily as a reference at the job. The book is well laid out. The materials covered are well presented, and talk to the topics at hand in great depth. This is very useful when you need to understand why somethings works.

I had no problems with installing and using the materials on the CD. Additionally, the questions are printable as well. So, even if you can't seem to figure out how to get the on-line stuff to work, there is hardcopy. I found that the hardcopy was much more effective studying for the certification exam than the on-line format, because I could read the explanations for the answers as well. The hardcopy was also faster to study from, and could be used without a computer...;*)...

7 of 8 people found the following review helpful:

3.0 out of 5 stars DB2 All In One Exam Guide, March 5, 2002

By A Customer

This review is from: DB2 Administration All-in-One Exam Guide (Hardcover)

They should have never released this book with the CD-ROM that does not work. The publishers were aware that the CD-ROM was full of bugs and their developers are scrambling to correct it.
I am extremely dissapointed..