Silverlake has successfully completed more than Five Hundred coporate traning's from all over India and Middle East.

• We are IBM Learning Services bussiness partners of iSeries, pSeries, zSeries.
  
• WE Design and Develop traning courses that suits our client's requirement.

Course Name : iSeries 400 Concepts & Programming Workshop

Delivery Method : Classroom (Hands-on Lab)

Skill Level : Basic

Language : English

Overview :

This course applies to the iSeries 400, AS/400e, and AS/400 systems. Learn iSeries 400 and AS/400e concepts, and how to use the following programming facilities: Programming Development Manager (PDM), Source Entry Utility (SEU), Screen Design Aid (SDA), Data File Utility (DFU), Structured Query Language (SQL),Operations Navigator,Query/400, and Query Manager. Hands-on labs gives you the opportunity to use these facilities.

Who Should Take This Course :

Data processing (DP) managers, system analysts, system programmers, and application programmers. This course is not intended for system operators.

What You Are Taught:

Implement an iSeries 400 or AS/400e database using Data Description Specifications(DDS), SQL, and Operations Navigator Describe basic OS/400 Work Management.

Create OS/400 objects, such as user profiles, libraries, and job descriptions Describe basic iSeries and AS/400e security Use PDM and SEU to create and maintain source code for database files, display files, and programs Compile source code and manage the resulting objects using PDM Create, modify, and test display files and menus using SDA Access and update database files using DFU Write basic Control Language (CL) programs that run and manage application programs Use these iSeries 400, or AS/400e functions: device files, file overrides, and copy file Describe iSeries 400, or AS/400e save and restore functions and other availability and recovery functions Use Query/400 and Query Manager to produce reports

Topics Include:

Basic Concepts

Work Management

Commands, Profiles, Libraries

Security Concepts

Basic Message Handling

DB/2 for AS/400 Overview

DB Files/DDS

SQL and Operations Navigator

Display Files

CL

SDA

DFU

Additional File Topics

Query Tools

Save/Restore

Additional Availability and Recovery Features

Course Name : DB2/400 Database Coding and Implementation

Delivery Method : Classroom (Hands-on Lab)

Skill Level : Intermediate

Language : English

Overview :

Learn how to code, create and maintain DB2/400 physical and logical files using native Data Description Specifications (DDS) and Command Language (CL) commands. This course also gives you a DB2/400 relational database foundation if you intend to write application programs for the AS/400 system, however it does not discuss SQL implementation of DB2/400. In this course, you learn many techniques that, if implemented, enhance the performance of applications using the database.

Who Should Take This Course:

People responsible for creating and maintaining a DB2/400 database.

What You Are Taught:

Code the DDS and create the physical and logical files necessary to implement a DB2/400 relational database

Describe the advantages of a field reference file, code the necessary DDS and create a field reference file

Explain how the choices made while coding the DDS and creating the file affect the performance of the system and the programs using the files

Describe the considerations for using DB2/400 referential integrity and triggers

Topics Include:

The Relational Database Model

Creating Physical Files

Creating Logical Files

Database Performance Considerations for Application Design

Database Maintenance

DB2/400 Referential Integrity

DB2/400 Triggers

Prerequisites:

You must be able to:

Use PDM/SEU to enter source code into a source file

Use PDM to create an AS/400 object from a source member

Explain the function of DDS in defining files on the AS/400

Use DFU to maintain a physical file

Course Name : iSeries 400 Control Language Programming Workshop

Delivery Method : Classroom (Hands-on Lab)

Skill Level : Intermediate

Language : English

Overview : This course applies to the iSeries 400, AS/400e, and AS/400 systems. Learn to write easy to use, and efficient Control Language (CL) programs that require little, or no involvement by system operators. Also, learn how to write user commands, and how to modify commands provided by IBM. You practice these skills in hands-on exercises. In some instances, you are provided with several exercises and it is suggested that you choose the one that best meets your needs.

Who Should Take This Course:

Application and system programmers.

What You Are Taught:

Write interactive and batch CL programs

Write CL programs that control the execution sequence of high level language applications programs; automatically handle exceptions, errors, and inquiry messages; interrogate and change job attributes and system values; conditionally execute and branch within a CL program; perform arithmetic and logic operations; prompt for the parameters of a command within a CL program at execution time; use data areas,data queues, and messages to communicate to other jobs on the system.

Use the interactive source debugging facilities of STRDBG

Create user defined commands to run applications.

Write your own utility programs to handle repetitive and one time system control and management tasks

Write never ending batch programs that become active when work arrives

Describe the parameters on the CRTCLPGM command, and the parts of a Control Language compile listing

Use the appropriate reference manuals, online Help text, and Infoseeker

Perquisites : You should complete:

iSeries 400 Concepts & Programming Workshop

Course Name : iSeries 400 Interactive Program Design

Delivery Method : Classroom (Hands-on Lab)

Skill Level : Intermediate

Language : English

Overview : This course is the Pre-Req for RPG IV and RPG/400 and explains how to control job execution and process access group, introduces to structured programming, multifunction structured program, subprogram, filesharing, ODP sharing, to code ILE programs, Data area, Data Queue, Group jobs, Screen Interface, Application Help, Subfiles and PRTF.

Who Should Take This Course:

Application and system programmers.

What You Are Taught:

Write interactive and batch CL programs to control Job and PAG

Write Structured Program using MFSP, Sub program

How to share File and ODP

Write ILE Programs Using Data Area,Data Queue and Group Jobs

Perquisites : You should complete:

AS/400 Control Language Program Workshop

Course Name: iSeries 400 and AS/400e RPG IV Programming Workshop

Delivery Method : Classroom (Hands-on Lab)

Skill Level : Advanced

Language : English

Overview :

This course applies to the iSeries 400, AS/400e, and AS/400 systems. Learn the basics of the Report Program Generator (RPG) IV language, and how to develop applications on the AS/400 using RPG IV. This course is not introductory in content, and is designed to challenge you. This course does not teach the RPG III language.

Review some topics, such as database access, that are required for writing applications, but are not part of the RPG IV language itself. Receive a comprehensive exposure to the main features and functions of RPG IV.

The course does not introduce either information processing or programming in general.

Who Should Take This Course:

Experienced programmers who are new to AS/400 RPG IV.

What You Are Taught:

Develop AS/400 applications in the RPG IV language

Maintain existing applications written in the RPG IV language

Use the Integrated Language Environment (ILE) Source Debugger tool to determine the cause of incorrect results

Topics Include :

RPG IV Introduction

Coding Specifications for RPG IV

Data Representation and Definition

Manipulating Data in Calculations

Printer Files

Using the ILE Source Debugger

Structured Programming, Subroutines and Calls

Accessing the DB2 Database Using RPG IV

Interactive Programming

Using Arrays

Data Structures and Data Areas

Prerequisites:

You should complete:

iSeries 400 and AS/400e Interactive Program Design

Venue (For all the above programs)

SilverLake Information Systems Pvt Ltd.,
(iSeries - IBM Business Partner)
282,MVS Complex, Katrigupe Circle,
Banashankari III Stage,
Bangalore-560085
Phone : 91-80-26798437 / 500

i5 and iSeries400 System Administration and Control 

Course Name : i5 and iSeries400 System Administration and Control

Delivery Method : Classroom (Hands-on Lab)

Skill Level : Intermediate

Language : English

Overview :

This course explains how to plan for, implement and manage the ongoing operations of the system. Emphasis is on security, system availability, backup and recovery, system software management and problem determination. You are also introduced to the architecture and terminology of the iSeries.

Who Should Take This Course?

Data processing managers and others responsible for implementing, managing security, system backup and recovery, system software and problem determination. This course is not recommended for operators.

What You Are Taught:

After attending this class, the student should be able to:

• Explain the components of iSeries security, such as user profile, group profile, authorization list, adopted authority and how they participate in security
• Develop a security plan for your iSeries installation
• Describe the facilities available to audit security on an iSeries
• Develop a plan to audit security on your iSeries
• Describe the iSeries availability products and features and choose the ones appropriate for your iSeries installation
• Describe how to backup and recover user and system information on the iSeries
• Develop a backup and recovery plan for your installation
• Describe iSeries problem determination procedures
• Describe how to manage PTFs on the iSeries

Topics Include:

• Security Concepts and Planning
• User Environment
• Availability Overview
• Backup and Recovery Strategy Using Save/Restore Commands
• Journal Management
• Commitment Control Overview
• Disk Management
• Backup and Recovery Planning
• Problem Determination and Resolution

Prerequisite :
iSeries 400 and AS/400e System Operator's Workshop

Venue (For all the above programs)

SilverLake Information Systems Pvt Ltd.,
282,MVS Complex, Katrigupe Circle,
Banashankari III Stage,
Bangalore-560085.
Phone : 91-80-26798437 / 500