PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
AUDIENCE:
Programmer
System Analyst
Database Administrator
IT Professional
DATES:
CONTENT AND OBJECTIVES:
Introduction
Create FILE commands and record layout for two files: 1- An automobile rentals master dataset. 2- Customer dataset.
Code the procedure.
System Overview
List the phases of program operations.
Basic Programming
Print multiple automobile listings sorted by various fields.
Select only cars that have: 1- Low mileage. 2- Automatic transmissions. 3- Built-in GPS unit.
Code complex extraction criteria using ANDs and ORs.
Calculate the amount of fuel charge based on the mileage; print out the bill.
Invoke a fuel charge calculation routine which will be coded and tested by the students.
Code a routine to format a detail line.
Printing Reports
Print reports with headings, footings, report title, and summary page.
Print a report with logic for every other line printed.
Create a detail report for sales.
Create a summary report for sales.
Create a detail/summary report for sales.
Code a report with multiple breaks: 1- Print special eye catchers after every break. 2- Perform additional calculations at a break.
Code an array for storing sales and customer statistics to be reported as quarterly data.
Macro, Defines, and Masks
Code, debug and test a simple macro for formatting a data item.
Processing and Logic
Populate and search an array.
Reports
Code a routine that passes values, performs chargeback calculations, and returns multiple values.
Print a report on special preprinted paper.
Input/Output
Perform a match/merge on the automobile and customer datasets.
Print a joined report.
File Processing
Bypass auto I/O processing and sequentially read a file.
Read two files into the program; retrieve data from a Db2 table.
Virtual Classroom
Blended Learning
↓
Synchronous Instruction
Asynchronous Instruction
Effective February 27, 2012, the course dates listed on the CETi schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. CETi makes no representation regarding ownership in any of the software products that we train on.
CETi courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the CETi course and that the employer has a licensed version of the software.
Certain courses only should be taught by the source software company training company and open source purveyor.
