COURSE TITLE : CAREER ENTRY COURSE FOR SOFTWARE DEVELOPERS - LEGACY SYSTEM/COBOL
QUALIFICATION LEVEL : NC IV
NOMINAL DURATION : 280 Hours
COURSE DESCRIPTION :
This course covers the knowledge, skills and attitude required in designing a program logic, applying program development approach, applying mainframe online systems programming language skills and applying database2 (db2) application programming.
COURSE OUTCOMES:
Upon completion of this module the students/ trainees will be able to:
Explain the systems development process and basics of logic formulation.
Apply the concepts of COBOL programming in a batch environment and be able to test the code
Apply the concepts of Mainframe Online Systems and be able to code and test programs using command level CICS/COBOL2
Apply DB2 Application Programming
ENTRY REQUIREMENT:
Must be a college graduate
Must pass IQ test and Programmers aptitude test, or
Must pass the hiring company’s panel interview
COURSE STRUCTURE:
Module 1 - Developing and Maintaining Program Applications in Mainframe
System and Database Management System
Explain the systems development process and basics of logic formulation.
Apply the concepts of COBOL programming in a batch environment and be able to test the code
Apply the concepts of Mainframe Online Systems and be able to code and test programs using command level CICS/COBOL2
Apply DB2 Application Programming
COURSE DELIVERY:
Methodology:
Resources:
The trainees must be provided with the following:
EQUIPMENT & NETWORK
1 computer per student
1 computer for the instructor
computers networked and connected to a server
Internet access for each student
SOFTWARE
Version control software on the server
In each student’s computer: COBOL, DB2 (or SQL) software / compilers and linkers
MATERIALS AND TOOLS
3. Qualification of Instructor:
College graduate
At least 1 year working or teaching experience in Legacy Mainframe application development using COBOL
Should pass PSIA teacher evaluation
MODULE OF INSTRUCTION
LO1 - Explain the systems development process and basics of logic formulation
ASSESSMENT CRITERIA
Different SDLCs with the steps within each identified correctly
CONTENT
Foundational Topics
Systems Development Life Cycle
Logic Formulation
CONDITIONS:
The trainees must be provided with the following:
EQUIPMENT & NETWORK
1 computer per student
1 computer for the instructor
computers networked and connected to a server
Internet access for each student
SOFTWARE
Version control software on the server
In each student’s computer: COBOL, DB2 (or SQL) software / compilers and linkers
MATERIALS AND TOOLS
Student Manual
Command References
LCD projector in the classroom
Whiteboard
METHODOLOGY:
Lecture and discussion
Guided Lab exercises
Machine problems
ASSESSMENT METHOD:
Graded Recitation
Quizzes
Theoretical exams
Graded lab exercises
LO2 – Apply the concepts of COBOL programming in a batch environment and be able to test the code
ASSESSMENT CRITERIA
A running stand-alone COBOL application written for a batch environment that conforms to proper design and best practices, supported by automated unit tests
CONTENT
Mainframe Batch Systems
Part 1
Program Structure - Definition of Divisions
Character Strings - Characters and Words (Reserved and User-defined)
Columnar/Areas and Data Reference
Statement Categories
Basic COBOL Syntax
Reading the Syntax Diagrams
OPEN Statement
MOVE
INITIALIZE
READ
DISPLAY
PERFORM
GO TO
CLOSE
EXIT and STOP RUN
ARITHMETIC Statements
Conditions in COBOL
Simple Conditions - Class, Condition-Name, Relation, etc.
Complex Conditions
Evaluation Rules
IF Statement
EVALUATE Statement
Scope Terminators
Part 2
Introduction to IBM MVS.
Basic JCL statements
Basic Testing techniques
Part 3
Identification Division
Environment Division
Data Division
FD Clauses
Data Description Entry
Item Clauses - BLANK WHEN 0, REDEFINES, PICTURE, VALUE, etc.
Condition Names
Editing using the Picture Clause
INITIALIZE Statement
ACCEPT Statement
WRITE Statement
Part 4
Transaction Validation Processing
Sequential Master File Maintenance
Part 5
Defining Tables and OCCURS Clause
Perform Varying
CALL Statement and CALL Options
Entry Statement
Exit Program and GOBACK Statements
Linkage Section
String and Unstring Statements
INSPECT
COPY Statement
Part 6 - VSAM
Accessing VSAM Indexed Files in Cobol
Organization and Access Modes
Reading, Creating, Updating, Deleting
CONDITIONS:
The trainees must be provided with the following:
EQUIPMENT & NETWORK
1 computer per student
1 computer for the instructor
computers networked and connected to a server
Internet access for each student
SOFTWARE
Version control software on the server
In each student’s computer: COBOL, DB2 (or SQL) software / compilers and linkers
MATERIALS AND TOOLS
Student Manual
Command References
LCD projector in the classroom
Whiteboard
METHODOLOGY:
Lecture and discussion
Guided Lab exercises
Machine problems
ASSESSMENT METHOD:
Graded Recitation
Quizzes
Theoretical exams
Graded lab exercises
LO3 – Apply the concepts of mainframe online systems and be able to code and test programs using command level CICS/COBOL2
ASSESSMENT CRITERIA
Command language interface rules and best practices are observed
Command formats and argument conventions are used
The appropriate language, translator are used
Basic programming constructs are used
Modular programming approach is used
Ability to create program routines using command level CICS/COBOL2 is demonstrated.
Program routines are reviewed and corrected using debugging tools provided by the system or the organization
A debugger to trace code execution and examine variable contents to detect and correct errors is used
Guidelines for developing maintainable code and program routines adhering to a set standard is followed
Internal documentation standards and tools are followed and used
Simple tests are developed and conducted to confirm the coding process meets design specification
The tests performed are documented
Corrections are made to the code and the documentation as needed
CONTENT
CICS Overview
Batch vs. on-line
Real-time, think-time, transactions
Pseudo-conversational
CICS components, functions and features, definitions, tables
Command Language Interface
Program characteristics
Interface with CICS, EXEC CICS command format and argument conventions
Translator
Execute interface block
Program Structure
Language considerations and restrictions
Linkage section usage
Exception Processing
Handle condition and Ignore condition
Resp and Nohandle, EIBRESP
Program Control
Modular structure using XCTL, LINK, CALL and RETURN
Pseudo-conversational tasks using transid and commarea
Terminal Control
SEND and RECEIVE
Attention identifiers
DFHAID and HANDLE AID
Basic Mapping
Overview of BMS facilities
Map creation (mapset definition macro, map definition macro, field definition macro)
Attribute modification
Cursor positioning
Mapping commands (SEND, RECEIVE)
File Control
Random processing commands (read, update, delete, add)
Browsing commands (start browse, read next, read previous, end or reset browse)
CONDITIONS:
The trainees must be provided with the following:
EQUIPMENT & NETWORK
1 computer per student
1 computer for the instructor
computers networked and connected to a server
Internet access for each student
SOFTWARE
Version control software on the server
In each student’s computer: COBOL, DB2 (or SQL) software / compilers and linkers
MATERIALS AND TOOLS
Student Manual
Command References
LCD projector in the classroom
Whiteboard
METHODOLOGY:
Lecture and discussion
Guided Lab exercises
Machine problems
ASSESSMENT METHOD:
Graded Recitation
Quizzes
Theoretical exams
Graded lab exercises
LO4 - Applying DB2 Application Programming
ASSESSMENT CRITERIA
Command language interface rules and best practices are observed
Command formats and argument conventions are used
The appropriate language, translator are used
Basic programming constructs are used
Modular programming approach is used
Ability to create program routines using command level SQL is demonstrated.
Simple tests are developed and conducted to confirm the coding process meets design specification
The tests performed are documented
Corrections are made to the code and the documentation as needed
Program routines is reviewed and corrected using debugging tools provided by the system or the organization
A debugger to trace code execution and examine variable contents to detect and correct errors is used
CONTENT
DB2 Concepts and Facilities
DB2 Terms and Concepts
RDBMS Fundamentals
Data Types
Indexes
Keys
Constraints - referential and integrity
Normalization
DB2 Architecture Overview
Mainframe Express DB2 Facilities
XDB Server
SQL Wizard
Declaration Generator (DCLGEN) in COBOL Programming
SQL Data Definition Language (DDL)
SQL Data Manipulation Language (DML)
SQL Statements Embedded in COBOL (Including performance considerations)
Preparing Programs for Execution
DYNAMIC SQL IN COBOL
Using EXPLAIN to Improve SQL Performance
CONDITIONS:
The trainees must be provided with the following:
EQUIPMENT & NETWORK
1 computer per student
1 computer for the instructor
computers networked and connected to a server
Internet access for each student
SOFTWARE
Version control software on the server
In each student’s computer: COBOL, DB2 (or SQL) software / compilers and linkers
MATERIALS AND TOOLS
Student Manual
Command References
LCD projector in the classroom
Whiteboard
METHODOLOGY:
Lecture and discussion
Guided Lab exercises
Machine problems
ASSESSMENT METHOD:
Graded Recitation
Quizzes
Theoretical exams
Graded lab exercises
Graded machine problem
CAREER ENTRY COURSE FOR SOFTWARE DEVELOPER - LEGACY SYSTEM/COBOL
Share with your friends: |