Test 000-730: DB2 9 Family Fundamentals

Course title: DB2 Family Fundamentals
Course duration: 2.0 Days
Course number: CE03
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: CE12
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).

• DB2 Family Fundamentals - Instructor Led Online

This is an online course. Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio and video. 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 runs under the z/OS, VM, 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.

• SQL Workshop - Instructor Led Online

This course is the Instructor Led Online (ILO) version of classroom course CE120. This course provides an introduction to the SQL language and applies to both DB2 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 with Informix.

Course title: DB2 Family Fundamentals - Web-Based
Course duration: 16.0 hours
Course number: 1E03
Abstract:

This is a self-paced online course. The average amount of time to complete this course is 16 hours. Once you receive your access information, you will have access to this course for 1 year.

Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course.

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. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours.

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 runs under the z/OS, VM, 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.

Course title: SQL Workshop - SPVC
Course duration: 16.0 hours
Course number: 2E12
Abstract:

This is a self-paced online course and includes hands-on remote labs. The average amount of time to complete this course is 16 hours. Once you receive your access information, you will have 30 days to complete this course and its labs.

Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs.

This course provides an introduction to the SQL language and applies to both DB2 and Informix. This course is appropriate for customers working in all DB2 or Informix environments.

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 lab system access is allocated on a first-come, first-served basis. You will have a total of 40 hours allocated to complete all of the lab exercises, so when you are not using the system, ensure that you log out to maximize ability to use the lab system. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours.

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.

• DB2 9 Fundamentals Certification Study Guide

This book written by Roger E. Sanders, covers everything needed to know to pass the DB2 9 Fundamentals Certification Exam (Exam 730). The prerequisite for all intermediate and follow-on DB2 certifications, XML usage, basic table creation, a rich set of sample questions, and detailed answers are all included, forming the foundation for understanding the newest version of IBM's flagship database product. Regardless of what future certification path the reader is planning on pursuing, this study guide will chart a course for proficiency in DB2 9.

Register for an IBM Certification test at Prometric and take a step into your future.

IBM at Prometric