This course is not scheduled. Inquire about Onsite training at your facility.
Overview
| Course code | OL450 | Skill level | Intermediate |
|---|---|---|---|
| Duration | 1.0 days | Delivery type | Classroom
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price | USD $655.00 plus tax | ||
DB2 UDB for iSeries is one of the database industry's best kept secrets. Examine how it is implemented and integrated into the architecture of the iSeries and learn about its many functions and features. Get an introduction to SQL and Operations Navigator.
Audience
Database administrators and application programmers who need to manage or implement an iSeries database. Individuals who have had experience with IBM's DB2 on another platform or another relational database.
Prerequisites
General background in information processing and familiarity with database concepts. Broad experience in database products enhances the benefit of this course.
Skills taught
- List four iSeries database objects
- Use both DB2 UDB SQL and native terminology to describe objects and operations
- Describe the use of referential integrity and triggers
- State four ways that SQL can be used in programs
- Describe the process to create DB2 UDB objects
- Use interactive SQL and Operations Navigator to create basic DB2 UDB objects
- List two performance tools that can be used to improve DB2 UDB performance
- Explain the role of the database administrator
- Explain the purpose of journaling and commitment control
- Explain the considerations of distributed data
Course outline
- Introduction to relational database management and DB2 UDB for iSeries
- Introduction to SQL
- Database creation considerations
- iSeries SQL in action - database case study
- Using SQL on the iSeries
- Advanced database features
- Database administration
- Database integrity and security
- Distributed data considerations
My IBM
We're here to help
Easy ways to get the answers you need.
or call us at
Call 1-800-426-8322
Open M-F 9AM-7PM ET.
