This book covers the second "Fundamentals" exam (test 701) an individual needs to pass in order to become an IBM Certified Database Adminstrator. 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, this book is guaranteed to provide the reader with all of the information needed to pass the V8.1 Certification test 701. 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 second certification exam.An estimated 20,000 people take this certification exam annually in the US.
| ||||||||||||
Book Description
Editorial Reviews
From the Back Cover
The official in-depth guide to passing IBM's DB2 Universal Database Version 8.1 Certification Exams 701 and 706
Over 20,000 people test to become IBM Certified Database Administrators every year. Some will pass, many will not. This book is IBM's official companion to mastering the skills that you need to ensure that you pass Certification Exams 701 and 706.
Written by a member of the DB2 UDB Version 8.1 Certification Exam development team, DB2 Universal Database v8.1 Certification Exams 701 and 706 Study Guide delivers information that every database administrator should be familiar with before they take the DB2 Universal Database v8.1 Database Administrator certification exams.
Author and DB2 UDB expert Roger E. Sanders covers every aspect of DB2 UDB v8.1 in clear, concise, and well-ordered chapters that give you the information you need to maximize your effectiveness come test time. Sanders outlines every facet of DB2 UDB v8.1 that will be featured on the exams and does so in an in-depth, professional manner that can only come from an expert with four DB2 UDB Version 8 certifications.
Each chapter also features practice exam questions and answers, as well as explanations and breakdowns of every correct answer. There is no better way to prepare for the DB2 UDB V8.1 Certification exams!
If you're a DB2 database administrator and you would like to become IBM DB2 UDB certified, then look no further-this is a must-have companion for anyone wanting to take the 701 or 706 certification exams.
About the Author
ROGER E. SANDERS, Database Performance Engineer with NetworkAppliance, Inc., is author of seven books on DB2 Universal Database,including DB2 Universal Database V8.1 Certification Exam 700 Study Guide. He hasworked with DB2 for more than 15 years and holds eight IBM DB2certifications, including IBM Certified Advanced Database Administrator-DB2 Universal Database V8.1, IBM Certified Application Developer-DB2 Universal Database V8.1, and IBM Certified Advanced Technical Expert (DB2 for Clusters). He also speaks at the International DB2 User's Group (IDUG) and Regional User Group (RUG) conferences and is a regular contributor to DB2 Magazine.
Product Details
Would you like to update product info or give feedback on images?
|
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
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
5 of 6 people found the following review helpful:
4.0 out of 5 stars
You must do the problems,
By
This review is from: DB2(R) Universal Database V8.1 Certification Exams 701 and 706 Study Guide (IBM Press Series--Information Management) (Paperback)
In the world of large commercial databases, there are really only two choices: IBM's dB2 and Oracle. While MySQL and Postgres are increasingly try to break up this cosy duopoly, they are still small players. So as a professional DBA, or an aspiring one, dB2 is a good choice. Given this, IBM provides several levels of certification. Sanders here supplies the official study guide for the 701 and 706 exams.Thumbing through this book, you see lots of SQL commands. But a lot of the SQL appears to be syntax specific to managing dB2. A dB2 programmer/user can largely deal with generic SQL. But for you, that's not enough. The value of this book is heavily in the specifics of dB2 and how to optimise its performance. The questions and answers in each chapter are at least as important as the text. If you are at all serious, you MUST tackle these. Otherwise, you've just discarded half the value of the book. Of course, the actual questions in the exams will differ. But by being able to do the book's problems, it forces you to clarify your understanding. My own SQL background is mostly with MySQL. So most of this book is new to me. I tried a couple of chapters and their problem sets. Not bad. The problems are not trivial. But the volume of material in each chapter is succinct enough to be doable in a few hours.
1 of 1 people found the following review helpful:
5.0 out of 5 stars
Another Excellent Certification Exam Study Guide,
By Paul Turpin (Charlotte, NC USA) - See all my reviews
This review is from: DB2(R) Universal Database V8.1 Certification Exam 703 Study Guide (Paperback)
If you studying for the Family Application Development Exam (703) certification exam, you will find the book to be quite helpful. I wish I had this book when I was studying 703 certification exam.
Many of us concentrate on only one or two of the methods of communicating with DB2 in our programs. The book does a good job of explaining embedded SQL programming, CLI/ODBC programming and Java programming. It is difficult to remember all the information about all of these and the book gives a great review of the programming methods. The book opens with a detailed roadmap on DB2 certification that explains the various tracks. It also has a good explanation of how to register for tests and how the tests work. Understanding how the tests work can save you valuable time on test day. Like Roger's other certification books, this one is arranged around the test sections, which seems like a good way to study for the tests. Roger likes to white space, pictures and diagrams to improve the readability of his books and this book follows that pattern. Each chapter closes with a section of practice questions, which have very informative answers that follow.
3 of 4 people found the following review helpful:
4.0 out of 5 stars
Use for competitive analysis of dB2,
By
This review is from: DB2(R) Universal Database V8.1 Certification Exam 703 Study Guide (Paperback)
This is one of the latest in a series of study guides that Sanders has put together for various dB2 certifications. As with his earlier books, a lot of its value is in the focus on what you need to know to pass an exam, in this case, the 703 exam. You will find an extensive question set at the end of each chapter, with answers later in the book. These question sets are indispensible for testing your knowledge understanding.But there is a second potential use of this book. It lets you concisely see various technical abilities of dB2. Useful if you are considering using dB2 or one of its competitors, like Oracle or Postgres or MySQL. For example, MySQL's most persuasive argument is that it is free. But it has limitations. No stored procedures [yet]. By contrast, Sanders describes these in dB2 in various chapters, and how they can reduce bandwidth in a client-server application, to cite only one instance. Another example of using this book to compare dB2 and MySQL might be the book's discussion of using foreign key constraints in dB2. Whereas currently in MySQL, foreign keys are not permitted. (Except in a very limited sense.) So with a little imagination, you can use this book as part of a competitive analysis of dB2. Perhaps not what Sanders or IBM fully intended. But the flexibility is useful.
Share your thoughts with other customers: Create your own review
|
|
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product).
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
