Back to SUMMIT Home Page Contact SUMMIT Education Inc.

 

DMS Concepts

Length
Variable 1-2 days.
 
Audience
Novice database programmers.
 
Prerequisites
None.
 
Brief Description
This course is designed for application programmers new to the DMS environment. It provides an introduction to DMS and covers database concepts including logical and physical attributes.
 
Topics/Outline
   Database Overview
   DMS Components
   Database Access
   Integrated Recovery
   Components of 2200 Integrated Recovery
   Physical Structure
   Logical Structure
   Database Design

Click to register for this class  Click to see a schedule of classes  Click to see a list of available classes  Back to Home Page

 

 

DMS Concepts and Programming

Length
5 days.
 
Audience
Database programmers.
 
Prerequisites
Knowledge of IX/ClearPath operations, systems concepts, and Executive Control Language (ECL) is recommended. Previous DMS experience is not required.
 
Brief Description
This course is designed for application programmers new to the DMS environment. It covers database concepts including logical and physical attributes. It also discusses creating a DML program and the various types of commands required.
 
Topics/Outline
   Introduction to Database Concepts
   Logical Database Attributes
   Physical Database Attributes
   Creating a DML Program
   DMS System Interface Commands
   Retrieval Commands
   Error Processing
   Update Commands
   Pointer Array Sets

Click to register for this class  Click to see a schedule of classes  Click to see a list of available classes  Back to Home Page

 

DMS Concepts and Database Design

Length
5 days.
 
Audience
Entry level database administrators, software support staff, operations supervisors or managers, or anyone new to the DMS 2200 or ClearPath environments.
 
Prerequisites
Knowledge of IX or ClearPath operations, systems concepts, and Executive Control Language (ECL) is recommended. Previous DMS experience is not required.
 
Brief Description
This course teaches students DMS database physical and logical structures, and how to design a database.
 
Topics/Outline
   Logical Database Design
   Physical Database Design
   Record Sizing
   Page Sizing
   Area Considerations
   Primary Location Modes
   Secondary Location Mode
   Design Strategies
   Subschemas

Click to register for this class  Click to see a schedule of classes  Click to see a list of available classes  Back to Home Page

 

Relational Database (RDMS) and SQL Programming

Length
5 days.
 
Audience
Entry level database administrators, software support staff, operations supervisors or managers, or anyone new to the RDMS environment.
 
Prerequisites
Knowledge of IX/ClearPath operations, systems concepts, and Executive Control Language (ECL) is recommended. Previous RDMS experience is not required.
 
Brief Description
This course provides an introduction to RDMS and programming in UCS and ASCII COBOL or FORTRAN. It also discusses the SQL and MRI interfaces.
 
Topics/Outline
   Introduction to RDMS
   Structured Query Language (SQL)
   Simple Data Retrieval
   ASCII COBOL Application Program
   UCS COBOL Application Program
   WHERE Clause
   IPF SQL Interface
   MAPPER Relational Interface (MRI)
   Joins
   Additional Data Retrieval Considerations
   Views
   Data Modification
   Obtaining Table Definition
   Programming Efficiencies and Miscellaneous Topics

Click to register for this class  Click to see a schedule of classes  Click to see a list of available classes  Back to Home Page

 

RDMS Database Design

Length
5 days.
 
Audience
Entry level database administrators, software support staff, operations supervisors or managers, or anyone new to the RDMS environment.
 
Prerequisites
Knowledge of IX/ClearPath operations, systems concepts, and Executive Control Language (ECL) is recommended. Previous R DMS experience is not required.
 
Brief Description
This course provides an introduction to RDMS database design.
 
Topics/Outline
   Relational Database Design
   Defining and Documenting Information Requirements
   Evolving Data Items into Relations/Tables
   Normalization and Evaluation
   Figuring Logical Access Costs
   Calculating Physical Sizing
   Implementing the Design
   Modifying the Design After Implementation

Click to register for this class  Click to see a schedule of classes  Click to see a list of available classes  Back to Home Page

 

Universal Data System (UDS) Concepts

Length
Variable 1-2 days.
 
Audience
Programmers new to the Universal Data System (UDS) environment.
 
Prerequisites
A background in DMS is desired, but not required. Students should possess some knowledge of database processing before attending this course.
 
Brief Description
This course provides an introduction to the Universal Data System (UDS).
 
Topics/Outline

   Introduction to Database Concepts
   Logical Database Attributes
   Physical Database Attributes
   Error Processing

Click to register for this class  Click to see a schedule of classes  Click to see a list of available classes  Back to Home Page

 

Integrated Recovery Concepts

Length
Variable 1-2 days.
 
Audience
Operators, software support staff, and database administrators.
 
Prerequisites
Basic transaction and database processing knowledge is desired but not required.
 
Brief Description
This course describes the Integrated Recovery environment. It teaches students how to support transaction and UDS files as well as how to recover the system if a file becomes corrupted or the system fails. This course is good for all those personnel who are responsible for database integrity.
 
Topics/Outline
  • Introducing Integrated Recovery
  • Application Group Overview
  • Integrated Recovery Components
  • Transaction Flow
  • Database Recovery Concepts
  • Message Recovery and MCB
  • Application Recovery

Click to register for this class  Click to see a schedule of classes  Click to see a list of available classes  Back to Home Page

 

TIP Concepts

Length
Variable 1-2 days.
 
Audience
Entry-level TIP or system programmers or experienced operations staff.
 
Prerequisites
Students should have a basic understanding of OS 2200 processing concepts.
 
Brief Description
This course introduces the student to the 2200 and ClearPath transaction environment (TIP). The different types of programs, how they are processed, and how to support the TIP environment are all covered.
 
Topics/Outline
Introduction: Anatomy of a Transaction Program
Transaction Programming Environment
Transaction Program Types
Writing a Simple Transaction Program
TIP File I/O
TIP Utilities

Click to register for this class  Click to see a Schedule of Classes  Click to see the list of available classes  Back to Home Page