AS/400 Links Partner with Rochester Institute Contact Us
Training Catalog Free Downloads Privacy / Usage


IBMi and AS400 Training
HOME >> Training Catalog >> iSeries Data Base Administration II

iSeries Data Base Administration II (ADB2)
Author: ATS
$895




Description
iSeries Data Base Administration II is a self-paced, audio-cassette 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.

  • 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 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
File Normalization
Normal Forms 1, 2, and 3
Boyce-Codd Normal Form
Documenting the Data Base Model
Creating the Physical Data Base
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

Audience
Any programmer, systems analyst, or
data base administrator who will have
the task of defining and creating data base files.
Prerequisites
iSeries Workstation Operations
iSeries System Operations
iSeries Data Base Administration I
Format
Self-Instructional
Materials
20 Audio CDs
Student Text
Workbook
Interactive Media
Time Required
Approximately 15 Hours


iSeries Data Base Administration II (ADB2)
Author: ATS
$895



Rochester Training
     RPG Skills Accelerator - Volume 2
     RPG Skills Accelerator
     e-RPG Powertools – Stone on CGIDEV2
     WebFacing Now! WAS-Express Edition
     JDBC and Record Level Access
with IBM AS/400 Toolbox for Java
     Turbo Query/400
     XML Web Services for RPG Programmers
     RPG Modernization with WDSC (from III to IV to /Free)
     Microsoft .NET for RPG Programmers (Visual Basic Version)
     Microsoft .NET for RPG Programmers (C# Version)
     iSeries Navigator for Programmers (V5R3 Edition)
     SQL for RPG Programmers
     Subprocedures for RPG Programmers
     RPG Web Skills Accelerator
     WDSC for RPG Programmers (Version 7)
     WDSC for RPG Programmers (Version 6)
     Microsoft Word with the iSeries
     Microsoft Excel with the iSeries
Operations Training
     iSeries Advanced System Operations
     iSeries System Operations
     iSeries Startup Operations
     iSeries Security
     iSeries Work Management
User Training
     iSeries Query for Users
     iSeries Query for Advanced Users
     iSeries RPG/400 Programming
     iSeries RPG/400 Interactive Programming
     iSeries RPG/400 Advanced RPG Programming
     iSeries RPG/400 Subfile Programming
     iSeries RPG IV Programming
     iSeries Data Base Administration I
     iSeries Data Base Administration II
     iSeries Control Language Programming
     iSeries CL and Programming Techniques
     iSeries SQL/400
     iSeries Advanced COBOL/400 Programming
     iSeries Interactive COBOL/400 Programming
     iSeries COBOL/400 Programming
     iSeries COBOL/400 Subfile Programming
     iSeries Program Development
Training Bundles
     iSeries Operations & Administration Bundle
     Microsoft Word and Excel with the iSeries Bundle
     RPG Skills Accelerator & RPG Web Skills Accelerator
     RPG Basics and Beyond (training bundle)
     RPG Skills Accelerator & RPG Skills Accelerator - Volume 2