fr
en
IBM i: The DB2 for IBM i Database
Your IBM i applications depend on consistent data management. With DB2 and SQL, connect data structures, querying and operations to gain greater control over processing. Strengthen your ability to produce verifiable results and discuss technical choices.
- Duration
- 3 days 21 hours
- Code
- OL62FR Code
Presentation
DB2 UDB is the relational database integrated into IBM i. Successive versions have extended the i5/OS environment with features such as triggers and referential integrity.
Objectives
This course teaches participants to make optimal use of their database. By the end, they will be able to implement DB2 UDB for i5/OS (OS/400).
Program
Introduction to relational databases: the relational model and normalisation.
Creating tables (physical files):
- Adding data.
- DDS, SQL and iSeries Navigator.
- Journaling.
Creating views and indexes (logical files): DDS, SQL and iSeries Navigator.
Database operations.
Database maintenance.
Referential integrity.
Overview of DB2 UDB features.
Triggers.
Audience
This course is intended for database administrators, operations managers and analyst-programmers.
Prerequisites
Completion of IBM i: Basic Functions and Utilities (OL49FR), or equivalent skills, is required.
Teaching and assessment methods
- Initial skills assessment
- Training materials provided to participants
- Continuous assessment throughout the course
- End-of-course feedback questionnaire
- Combination of theory and practical application
- Attendance records
- Post-course follow-up evaluation
- Quiz / multiple-choice questions
- Practical exercises
Dates and sessions
Choose the date and delivery format that suit you.
No upcoming sessions are currently available.