Skip to main content

 
Professional certification

  >  

Certifications

  >  

Test information

Test 700: DB2 V8.1 Family Fundamentals


Spacer
Overview Objectives Test PreparationSpacer
Spacer Roadmap  |  Training Resources  |  Sample / Assessment Test 
Spacer
Spacer

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
< span >Barnes & Noble online bookstore 


Classroom

Course title: DB2 Family Fundamentals
Course duration: 2.0 days
Course number: Global Course code (CF03xx)
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=pag e&contentID=a0000350

http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag e&contentID=a0000267

http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag e&contentID=a0000369

http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag e&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: Global course code( CF12xx)
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=pag e&contentID=a0000350

http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag e&contentID=a0000267

http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag e&contentID=a0000457

http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag e&contentID=a0000369

http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag e&contentID=a0000360

http://www.ibm.com/services/learning/ites.wss/us/en?pageType=pag e&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.


e-Learning
IBM DB2 UDB Essentials Curriculum

This curriculum includes:

IBM DB2 UDB Essentials Part 1 - Fundamentals of DB2 UDB Programming IBM DB2 UDB Essentials Part 2 - System and Database Administration IBM DB2 UDB Essentials Part 3 - SQL Fundamentals IBM DB2 UDB Essentials Part 4 - Advanced SQL

In Part 1 learn the fundamentals of IBM DB2. Get an introduction to the IBM DB2 UDB family and the key elements of database management services. Examine SQL comprehensively from the end user's perspective - write and run SQL and apply SQL to business intelligence. Then explore SQL and programming - the principal elements of SQL test environments, programming, compiling and execution.

In Part 2 focus on the roles and principal tasks of the system administrator and the database administrator in IBM DB2. Learn about administrative utilities and security. Get a comprehensive introduction to the areas of database modeling, database design, and distributed data processing, all of which are core concepts within IBM DB2 UDB.

In Part 3 get an introduction to the fundamental elements of SQL. Address simple query running before moving on to more complex procedures, such as retrieving data from multiple tables and creating single reports from multiple queries. Review scalar and column functions. Also, learn to run subqueries and maintain data. Learn to write basic Data Manipulation Language (DML) SQL statements and basic Data Definition Language (DDL) SQL statements.

In Part 4 learn how to make use of advanced SQL techniques to access DB2 databases in different environments. Examine creating SQL objects, CASE, CAST and summary tables, joins, subqueries, scalar functions, recursive SQL, User-defined Distinct Types (UDT) / User-Defined Functions (UDF), and general performance guidelines.

Part 1 and Part 2 are intermediate courses for individuals who need introductory knowledge of DB2 and for individuals preparing for advanced and specialized DB2 education.

Part 3 is an intermediate course for end users, programmers, application designers, database administrators, and system administrators who need to write, support, or understand SQL queries.

Part 4 is an intermediate course for experienced SQL end users, application programmers, database administrators, and user support staff members, who need more advanced knowledge of SQL. It is appropriate for individuals working in all DB2 environments, that is, OS/390, VM/VSE, AS/400, UNIX, Windows, and OS/2.




Online course

Course title: DB2 User Certification Preparation
Course duration:
Course number:
Abstract: Six new Certification tutorials are now available to help you prepare for the DB2 Fundamentals Certification (Test 512). These tutorials provide a solid base for each section of the exam. Each tutorial includes a link to a no-charge DB2 Universal Database Enterprise Edition download.


Retail Book
Understanding DB2 – Learning Visually with Examples

by Chong/Liu/Qi/Snow

Teach Yourself DB2 Universal Database in 21 Days

by Visser & Wong; Paperback - 640 pages, 2nd edition (Aug 2003); Sams

DB2 Universal Database V8.1 Certification Exam 700 Study Guide

by Sanders; Prentice Hall; Paperback - 448 pages, 1st edition (Sept 2003)

The Official Introduction to DB2 UDB for z/OS Version 8

- by Sloan; Prentice Hall; Textbook Binding - 496 pages, 1st edition (Apr 2004)

Test registration

Authorized Prometric test centers (worldwide testing)

Announcement

IBM certification tests to be delivered only through Prometric, beginning July 2, 2007