 |
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
|
 |
|
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.
|
|
|
 |
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.
|
|
|
|
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.
|
|
|
|
