Price: $895.00 Availability: Ships within 72 hours SKU: 711
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
AS/400 Database Administration II Author: Multiple
Price: $895.00 Availability: Ships within 72 hours SKU: 711
AS/400 Database Administration II
