Midware Ltd.

Sign-up for e-mail notifications

Take our weekly poll

Midware has a number of training courses available that can either be administered personally by a Midware professional or are available for purchase on CD-ROM.  This list will grow as new courses are developed.

We also understand that every company has it's own standards and training requirements.  We will be happy to work with you if you have needs for custom training programs or wish to modify the training agendas to meet your specific needs.

For more information on training, e-mail us at midware@midwareservices.com.

Courses

AS/400

• Non-RPG
  • AS/400 for end-users
  • AS/400 Database Concepts
  • AS/400 Advanced Database Concepts
• RPG Development
  • Introduction to RPG III (RPG/400)
  • RPG IV (ILE) for RPG III Programmers
  • Subfile programming
  • Embedded SQL programming
  • ILE programming in RPG

Other

• Database Concepts
• Windows Office Suite (coming soon)

Training Agendas

AS/400 for end-users

Course Description

This session covers AS/400 basics from an end-user perspective.  Discussion are kept at a non-technical level.

Who should take this course?

Anyone expected to use an AS/400 as an end user with little or no previous experience.  This course is typically used either as a primer for eventual technical training, or an introduction for end-users.

Pre-requisites

Attendees should have at least a basic understanding of navigating through the Microsoft Windows environment.

Agenda

• What is the AS/400
• Signing on
• Components of the AS/400 screen
• Navigation
• Command entry
• Getting help
• Client Access
  • Keyboard Customization
• Jobs & job queues
• Spool files & output queues
• Libraries & library lists

AS/400 Database Concepts

Course Description

This session covers the basics of the internal AS/400 data base (DB2/400) from a slightly technical perspective.  The basics of accessing data are also covered.

Who should take this course?

Anyone with a comfortable understanding of the AS/400 from a user perspective that has a requirement for additional understanding of the data base structure of the AS/400.  This session is typically used as a pre-cursor to an  entry level programmer position or for technical resources on other platforms to gain a better understanding of the AS/400's data base concepts.

Pre-requisites

Should be familiar with most of the concepts in the AS/400 for end-users.

Agenda

• Libraries & library lists
• Objects
• Data files
  • File properties
  • Physical files
  • Record formats
  • Members
  • Logical files
• Importing data to MS Excel

• Working with a job

• DDS - Creating files

• Query

• SQL

• Open Query File

AS/400 Advanced Database Concepts

Course Description

This course covers some of the more advanced features of DB2/400 including referential integrity, triggers, and journaling.

Who should take this course?

This course is geared towards database administrators, experienced developers, project leaders, or system analysts looking to take advantage of some of the more advanced features of DB2/400.

Pre-requisites

Should be familiar with most of the areas of the AS/400 for end-users section.  It is also very helpful if the individuals have experience 

Agenda

• Embedded SQL procedures
• Externalizing I/O routines
• Trigger programs
• Database constraints
• Commitment control
• Journaling

Introduction to RPG III (RPG/400)

Course Description

This course is a basic introduction to the RPG programming language on the AS/400.  Upon completion of this course, attendees will be able to write report and simple on-line screen maintenance programs

Who should take this course?

This course is an excellent first step either for entry level programmers or experienced programmers in other languages looking to become familiar with the AS/400.

Pre-requisites

Should be familiar with most of the areas of the AS/400 for end-users and AS/400 Database Concepts sections.  It is also very helpful if the attendees have some prior understanding of programming concepts.

Agenda

• Source Entry Utility (SEU) overview
• Structure of an RPG program
• File specs
• Calc specs
• Operation codes
  • MOVE/MOVEL/Z-ADD
  • Math functions
  • IF structures
  • SELEC structures
• File operations
  • Key lists
  • SETxx
  • READ
  • READE
  • CHAIN
  • WRITE
  • UPDAT
  • DELET
• Date and Time keywords
• Indicators
• Do Loops
• Subroutines
• Data areas
• Tables/Arrays
• Calling other programs
• Creating reports
• Creating online applications (not subfiles)
  • Introduction to Screen Design Aid (SDA)

RPG IV (ILE) for RPG III Programmers

Course Description

This course introduces existing RPG III (RPG/400) programmers to the RPG IV language.  The differences between RPG IV and ILE are covered, but ILE is not covered in detail.

Who should take this course?

RPG IIII programmers with little or no RPG IV programming experience.

Pre-requisites

Should be familiar with most of the topics in the Introduction to RPG III (RPG/400) course.

Agenda

• Differences between RPG III and RPG IV
• Clarification of RPG IV vs. RPG/ILE
• Converting existing RPG III programs to RPG IV
• RPG IV language elements
• New data types
• Built in functions
• Date and time support
• Activation group issues

Subfile programming

Course Description

This course introduces existing RPG programmers to subfile programming.  The various types of subfiles are covered.  RPG IV is used as the programming language for this course.  Although the features of RPG IV will not be fully explored in this course, it will also provide an introduction to the language for RPG III programmers.

Who should take this course?

RPG programmers with little or no online or subfile programming experience.

Pre-requisites

Should be familiar with most of the topics in the Introduction to RPG III (RPG/400) course.  Prior knowledge of RPG IV (ILE) - although not necessary - is helpful.

Agenda

• Developing subfiles with Screen Design Aid (SDA)
• Load-at-once subfiles
• Page-at-a-time subfiles
• Subfile control
• Processing options
• Positioning
• Record filtering
• Building subfiles using imbedded SQL

ILE Programming In RPG

Course Description

This course introduces RPG IV programmers to the Integrated Language Environment (ILE) concepts.  Although the course uses RPG for the examples, the concepts will transfer to other ILE-enabled languages (C, CL, Cobol).

Who should take this course?

RPG IV programmers with little or no ILE programming experience.

Pre-requisites

Should be familiar with most of the topics in the RPG IV (ILE) for RPG III Programmers course.

Agenda

• Review of OPM vs. ILE
• Built in functions
• Procedures
• Modules
• Static binding vs. dynamic binding (service programs)
• Organizing procedures service programs
• Binding directories
• Parameter passing
• Binder language
• Activation groups
• Pointers

Database Concepts

Course Description

This session covers generic (non-platform specific) database concepts and design consideration.  Although the basic database structures (file, record, field) are covered, more emphasis is placed on the somewhat more advanced topics of normalization and database integrity.

Who should take this course?

Developers, Database Administrators, Project Managers, or System Analysts that will be involved in system design.

Pre-requisites

Although not absolutely necessary, some prior experience with databases is recommended.

Agenda

• Database components
  • Files (tables)
  • Records (rows)
  • Fields (columns)
• Access paths
• Relationships
• Normalization
• Referential integrity

Send mail to midware@midwareservices.com with questions or comments about this web site.
Copyright © 2000 Midware, Ltd.

Last Modified:  November 06, 2000