Test 000-730: DB2 9 Family Fundamentals

Course title: DB2 Family Fundamentals
Course duration: 2.0 Days
Course number: CE030
Abstract:

This course provides you with information about the functions of IBM's DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms.

DB2 9 runs under the z/OS, Linux, UNIX, and Windows operating systems, to name a few.

The course includes discussion of how the DB2 products provide services. The focus is on the services DB2 provides and how we work with DB2, not on its internal workings.

This basic course is for persons needing an introductory knowledge of DB2, and persons preparing for advanced and specialized DB2 education.

Course title: SQL Workshop
Course duration: 2.0 Days
Course number: CE120
Abstract:

This course is the classroom delivered version of Instructor Led Online Course 3E120.

This course provides an introduction to the SQL language and applies to the entire DB2 Family, and Informix. This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.

This is a basic course anyone needing to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of the SQL Data Manipulation Language (DML).

Course title: DB2 SQL Workshop (self-paced virtual class)
Course duration: Varies
Course number: C12A1
Abstract:

Note: This course is actually a self-paced virtual class. The average time to complete the course is 30 hours. Once you register, you have 60 days to complete this course.

This is the Internet-delivered, self-paced virtual class version of our classroom course:

Learn about Structured Query Language (SQL) and how it applies to the entire DB2 UDB Family. This course is appropriate for individuals working in an OS/390, VM/VSE, AIX, or Windows environment. Complete extensive hands-on exercises to develop your skills to use the SQL you learn.

The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day, but access must be scheduled in advance. Once you have accessed the course, online instructor help is available Monday through Friday from 9:00 a.m. to 5:00 p.m. ET.  

Online Enrollment:

Before enrolling, review the Machine Requirements to be sure your system meets the minimum hardware requirements for this course.

Click the Order now link (above) to enroll in this course.

Within 48 hours after you submit the online form, you will receive a confirmation e-mail. It will contain your online link, your ID and password, and additional instructions for starting the course.

Start the course at any time. Once you start the course, you have 60 days to complete the program. You are billed for the course when you submit your enrollment form.

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

This is a basic course for individuals who need to perform SQL queries in practice. This includes end users, programmers, application designers, database administrators, and system administrators, who do not have knowledge of the SQL Data Manipulation Language (DML).

Course title: DB2 9 Fundamentals Exam 730 Certification Preparation Tutorial Series
Course duration: 7 hours
Course number: Exam 730
Abstract: The Fundamentals tutorial series provides an introduction to SQL (Structured Query Language) and covers how DB2® 9 is packaged and installed, how to create databases and database objects, and the basics of database security and transaction isolation. 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. After a quick registration, you can begin a tutorial. Each tutorial should take about an hour to complete. You can take the tutorials online, or download a PDF or zip file.