AS/400 Database Administration I (Audio Training)

Course Description:
AS/400 Database Administration I is a self-paced audiocassette course providing comprehensive, practical training in the description and creation of physical and logical files. Includes ten audiocassettes; student text; workbook; Interactive media

When you have completed of this course, you will be able to:
   • Use Data Description Specifications (DDS) to define physical and logical files
   • Define alphanumeric and numeric fields and assign attributes that validate user-entered data
   • Present data in edited form; allow input only, output only, or both; and more
   • Create a field reference file that serves as single-source supplier of field attributes to other files
   • Create files that allow an unlimited number of file members or only one file member
   • Create files that can add, clear, or remove file members
   • Create logical files that concatenate multiple fields into one field or split a field into smaller fields
   • Create files indexed by multiple fields, permit or restrict duplicate keys, and sequence records
   • Create logical files that join or interleave records from two or more files
   • Select records based on the value of one or more fields
   • Specify how a file's access path should be maintained by the system for performance
   • Use OS/400 CL commands to display descriptions of files, fields, and more

Audience: Database Administrators and Programmers

Prerequisites: Workstation Operations and AS/400 System Operations

Course Outline:
   Physical Files
   Record Format Definitions
   Field Definitions
   Field Naming ConventionsKey Field Definitions
   Field Reference Files
   DDS Keywords
      TEXT and COLHDG
      ALIAS
      EDTCDE and EDTWRD
      COMP, RANGE, and VALUES
      CHECK
      REF and REFFLD
      FORMAT
   Multiple Members Logical Files
   Record Format Definition
   Field Definitions
   Access Path Definitions
   Select/Omit Definitions
   DDS Keywords
      RENAME
      CONCAT
      DYNSLT
      CONCAT, SST[SW1]
   Multiple Members
   Multiple Record Formats
   Joining Logical Files
   Joining Physical Files
   Field Definitions
   Access Path Definitions
   Select/Omit Definitions
   DDS Keywords
      JOIN
      JFILE
      JFLD
      JREF
      JDUPSEQ
   Access Paths
   Arrival Sequence
   Keyed Sequence
   Maintenance Types
      *IMMED
      *REBLD
      *DLY
   DDS Keywords
      DESCEND
      UNIQUE
      LIFO
      *NONE
   Key Field Definition
   File-handling CL Commands

Course Details:

Level:	Intermediate
Subject:	Database Administration
Length:	15 hrs.
Publisher:	ATS
Publish Date:	June 1998