 |
Courses and publications are offered to help you prepare for the certification tests. The courses are recommended, but not required, before taking a certification test.
For information on course pricing, scheduling and registration (note course code number):
IBM IT Training.
To order any publications, including certification guides, visit your favorite bookstore or visit one of the following online bookstores:
Discount IBM Developer Bookstore
Barnes & Noble online bookstore
|
 |
|
Course title:
DB2 Family Fundamentals
Course duration: 2.0 days
Course number: CF03
Abstract: Learn the functions and components of IBM DB2 UDB, a relational database manager, which may be installed on a variety of operating systems. This course addresses DB2 UDB running on z/OS, AIX, Linux, HP-UX, Sun, and Windows operating systems. Discuss the DB2 UDB products and services. Focus on the services DB2 UDB provides and how they work, not on DB2 UDB internal workings. If you are interested in iSeries, AS/400, or AS/400e, you should complete: DB2 UDB for iSeries Fundamentals (S6145) Course Materials The course materials cover DB2 UDB for z/OS Version 8 and DB2 UDB for Linux, UNIX, and Windows Version 8. Hands-On Labs No labs are included with this course. Certification Prepare for IBM Certification Test 512: DB2 UDB V7.1 Family Fundamentals and IBM Certification Test 700: DB2 UDB V8.1 Family Fundamentals Training Path This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education. http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000350 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000267 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000369 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000360
This is a basic course for administrators, analysts, programmers and other technical individuals, who need introductory knowledge of DB2 UDB. It is also for individuals preparing for advanced and specialized DB2 UDB for z/OS and OS/390 Version 7 and DB2 UDB for Linux, UNIX and Windows Version 8 education. This course may not be required for individuals with relational database system experience.
|
|
Course title:
DB2 SQL Workshop
Course duration: 2.0 days
Course number: CF12
Abstract: Note: From February 6, 2006 through April 28, 2006*, attend this course and receive a complimentary copy of Understanding DB2 - Learning Visually with Examples, by Raul F. Chong, Clara Liu, Sylvia F. Qi, and Dwaine R. Snow. This book teaches DB2 V8.2 visually, step by step, with dozens of examples and case studies drawn from the authors' unsurpassed experience as DB2 consultants at IBM. Don't miss this special opportunity to get a valued resource to help you grow your skills. Books will be available while supplies last. Learn about SQL and how it applies to the entire DB2 UDB Family. This course is appropriate for individuals working in a z/OS, VM/VSE, Linus, UNIX, or Windows environment. Complete extensive hands-on exercises to develop your skills to use the SQL you learn. Perform these exercises either by using the DB2 UDB for Linux, UNIX, or Windows product in a Windows environment or by using the DB2 UDB for z/OS product through a Time Sharing Option (TSO) interface to a z/OS system. If you are interested in iSeries, AS/400, or AS/400e, review the following DB2 SQL course: Accessing the iSeries Database Using SQL (S6137) Course Materials The course materials cover DB2 UDB for z/OS Version 8 and DB2 UDB for Linux, UNIX and Windows Version 8. Hands-On Labs Seven labs are included to address using DB2 UDB for z/OS Version 8 and DB2 UDB for Linux, UNIX and Windows Version 8. Certification Prepare for IBM Certification Test 700: DB2 UDB V8.1 Family Fundamentals. Training Path This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education. http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000350 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000267 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000457 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000369 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000360 http://www.ibm.com/services/learning/ites.wss/us/en?pageType=page&contentID=a0000363 * This offer is subject to availability. Valid while supplies last.
This is a basic course for individuals who need to write, support, or understand SQL queries. This includes but is not limited to end users, programmers, application designers, database administrators, and system administrators.
|
|
|
|
Course title:
DB2 UDB V8.1 Database Associate Certification Preparation
Course duration:
Course number:
Abstract: This series of six tutorials is designed to help you prepare for the DB2 Version 8 Family Fundamentals (Exam 700) certification preparation. Each tutorial includes a link to a free DB2 Universal Database Enterprise Edition download. These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam.
|
|
|
 |
DB2 Universal Database V8.1 Certification Exam 700 Study Guide
This book covers the first "Fundamentals" exam 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.
|
|
|
Teach Yourself DB2 Universal Database in 21 Days
Sams Teach Yourself DB2 Universal Database in 21 Days, Second Edition, focuses on performing tasks using the graphical interfaces and wizards that are provided with DB2 on the Windows platform. (DB2 also runs on z/OS, OS/400, AIX, Linux, HP-UX, and Sun Solaris.) Readers are guided through performing all the commonly used tasks to run DB2, including installing DB2, setting up DB2, creating databases and tables, populating the database with data, accessing the data, ensuring the database is tuned for performance. This book differs from the competition in that it provides examples and scenarios making it very easy for the reader to learn complicated tasks. It gives them everything they need for the commonly used tasks in a simple to understand manner. Quizzes and exercises strengthen the knowledge gained and ensure concepts are learned rather than memorized.
|
|
|
The Official Introduction to DB2 UDB for z/OS Version 8
The Official Introduction to DB2 UDB for z/OS provides a comprehensive overview of Version 8 of the DB2 UDB for z/OS product. The book serves a dual purpose: it gives new and prospective users a solid introduction to key product features and it covers material contained in the DB2 Family Fundamental exam, the first exam in the DB2 certification series. The book explains basic relational database concepts, the basics of the structured query language (SQL), and gives a solid overview of the various user tasks that are associated with this product. It includes introductory information about designing databases, creating relational objects, managing DB2 on a day-to-day basis, and writing application programs that use DB2 data. It also introduces new users to some of the more complex capabilities of DB2, such as, DB2 in the Web environment, distributed data, and data sharing. Introductory book for the DB2 mainframe audience, parallels Baklarz audience (ISBN 0130463612). Well-written (The Society of Technical Communication recognized the first edition of this book with a Merit award in the Northern California Technical Communication Competition.) Most current coverage of Version 8 of DB2 UDB for z/OS, the single largest release of this product since its inception in 1983-- Includes 8.2
|
|
|
Understanding DB2 – Learning Visually with Examples
by Chong/Liu/Qi/Snow
|
|
|
|
