AS/400 Database Administration II (Audio Training)

Course Description:
AS/400 Database Administration II is a self-paced audiocassette course providing comprehensive, practical training in the design and implementation of databases.

Time required: approximately 15 hours

Upon completion of this audio program, you will be able to:
   • Design and create a relational database 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
   • Streamline system backup by incorporating file journaling in the backup strategy
   • Set up a commitment control environment
   • Perform backward and forward recovery operations under commitment control
   • Use Open Query File (OPNQRYF ) to dynamically select, sequence, and join records in HLL programs

Audience: Database Administrators and Programmers

Prerequisites: AS/400 Workstation Operations AS/400 System Operations AS/400 Database Administration I

Course Outline:
   Relational Database Concepts
   Database Design Concepts
      Documenting the Business Function
      Entities and Data Items
      Design as an Iterative Process
   Resolving the Database
      Homonyms and Synonyms
      Derived Data Items
      Mutually Exclusive Items
   File Normalization
      Normal Forms 1, 2, and 3
      Boyce-Codd Normal Form
   Documenting the Database Model
   Creating the Physical Database
   Journaling
      Journals and Journal Receivers
      Journal Images
      Fixing a Damaged File
      Operational Considerations
   Commitment Control
      “Set” Processing
      COMMIT and ROLLBACK
      Commitment Boundaries
      Commit Cycle
      Notify Objects
      Operational Considerations
   OPNQRYF Command
      Selecting Files and Records
      Defining Key Fields
      Mapped Fields
      Select/Omit Processing
        Grouping
   OPNQRYF Join

Course Details:

Level:	Intermediate
Subject:	Database Administration
Length:	15 hrs.
Materials:	10 Audiocassettes; Student Text; Workbook; Interactive media
Publisher:	ATS
Publish Date:	June 1998