This hands-on lab shows you how to use Data Definition Specifications to create an IBM i database. The class covers database from start to finish, including the relational database model, physical files, logical files, join files, and field reference files.
Recommended schedule: 2 day lab workshop
Who Should Attend This class is for IBM i programmers and database managers who need to know the concepts and mechanics behind DDS.
Prerequisites In order to successfully complete this course, students should have completed the following courses, or have equivalent knowledge/experience:
IBM i Concepts and Facilities
What You Will Accomplish At the end of the course, students will be able to:
Understand the relational database model as it applies to the iSeries
Design and create a physical file
How to use a field reference file
Create a logical file to resequence the data in a physical file
Create a logical file to select specific records from a physical file
Create a logical file to filter the visible fields in a physical file record format
Create a multiple format logical file
Join two or more files into a single logical file
Understand the various types of joins (inner, outer, exception)
Analyze and change the properties of a database using iSeries commands
Understand referential integrity concepts and how to implement them
Understand the role of database triggers and how to implement them in RPG
Improve application performance using database features
What You Will Receive Each student receives:
Custom printed handout, containing class notes
Completion certificate
Course Outline The class covers these topics:
Introduction to database concepts
Physical files
Non-join logical files
Join Logical files
Maintaining the database
Referential integrity
Triggers
Performance considerations
Hands-on Labs
Creating Physical Files
Creating Logical Files
Creating Join Logical Files
Changing the Database Structure
Using System Reference Files
Referential Integrity
Creating a Trigger Program
Limited Time!
Special pricing for the
Ontario area. Book a 5-day onsite class for as little as USD $900/day. Get a price quote today. Ask for offer CA900.
