iSeries (AS/400) Data Base Administration II
(Design and Implementation)
Course Code: ADB2
AS/400 Data Base Administration II is a self-paced, audio based course providing
comprehensive, practical training in the design and implementation of data bases.
Upon completion you'll be able to:
Design and create
a relational data base for an application.
Build a dictionary
of data items and convert it into a field reference file.
Use standard file
normalization techniques to remove redundant data items.
Use date data types
and variable length fields.
Set up, use, and
manage the journaling of changes to physical files.
backup by incorporating file journaling in the backup strategy.
Set up a commitment
and forward recovery operations under commitment control.
Use Open Query
File to dynamically select, sequence, and join records in HLL programs.
|Relational Data Base Concepts
Data Base Design Concepts
Documenting the Business Function
Entities and Data Items
Design as an Iterative Process
Resolving the Data Base
Homonyms and Synonyms
Derived Data Items
Mutually Exclusive Items
Normal Forms 1, 2, and 3
Boyce-Codd Normal Form
Documenting the Data Base Model
|Creating the Physical Data Base
Journals and Journal Receivers
Fixing a Damaged File
COMMIT and ROLLBACK
Selecting Files and Records
Defining Key Fields
Any programmer, systems analyst, or
data base administrator who will have the task of defining and creating
data base files.
Data Base Administration I
Self Study Interactive
20 Audio CD's
Interactive Software Media
| Time Required |
Approximately 15 Hours