System Use

Introduction to the IBM i Environment

• Getting Started on IBM i
• Integrated File System Concepts
• Using IBM i Commands
• Using System i Navigator
• Accessing an IBM i System from Your PC
• Introduction to the IBM i Environment Competency Exam

System i Access for Windows

• Introduction to System i Access for Windows
• Using PC5250
• Transferring Files Between Your PC and an IBM i System
• Using the Directory Update Function
• Installing System i Access for Windows
• Using System i Access for Windows Competency Exam

Using Query Manager

Using Query for System i

Getting Started with DB2 Web Query

TCP/IP in the IBM i Environment

• TCP/IP Fundamentals
• TCP/IP Applications
• TCP/IP in the IBM i Environment Competency Exam

System Operation

Fundamentals of IBM i Operations

• Work Management Concepts
• Submitting and Managing Batch Jobs
• Controlling Printer Output
• Controlling Users, Queues, and Printers
• Monitoring an IBM i System
• Using Tapes
• IBM i Operations Using System i Navigator
• Fundamentals of IBM i Operations Competency Exam

IBM i System Management

• Starting and Stopping the System
• Managing Devices
• Backing Up Your System
• Checking Storage Utilization
• Cleaning Up System Storage
• Software Maintenance
• Using Virtual Media
• Handling Problems
• System Management Using System i Navigator
• IBM i System Management Competency Exam

PowerVM Concepts or Introduction to Logical Partitioning

Using IBM Systems Director Navigator for i

Programming

The IBM i Programming Environment

• IBM i Application Programming Concepts
• IBM i Application Programming Tools
• ILE Program Management
• The IBM i Programming Environment Competency Exam

RPG Programming

• RPG Fundamentals
• RPG File Processing
• Rounding Out The Essentials of RPG
• Working with Complex Data Types
• Developing a Modular RPG Application
• Developing an Interactive RPG Program
• Advanced RPG Programming
• RPG Programming Competency Exam

Java Fundamentals

• Introduction to Java
• The Basics of Java Programming
• Java Fundamentals Competency Exam

Control Language Programming

• Introduction to CL Programming
• Variables and Built-in Functions
• Controlling Command and Program Flow
• Interactive CL Applications
• Message Processing in a CL Program
• Accessing Database Files, Data Queues, and Data Areas
• Debugging an ILE CL Program
• Debugging an OPM CL Program
• Control Language Programming Competency Exam

Working with DB2 Databases

• Introduction to DB2
• Creating and Managing Physical Files
• Creating and Managing Logical Files
• Processing a DB2 Database
• Using Triggers
• Using Referential Integrity
• Working with DB2 Databases Competency Exam

Using Screen Design Aid (SDA)

Using the ILE Source-Level Debugger

Using Structured Query Language (SQL)

• SQL Fundamentals
• Coding SQL Statements in an RPG Program
• Coding SQL Statements in a COBOL Program
• SQL Stored Procedures
• Using Structured Query Language (SQL) Competency Exam

Using WebSphere Development Studio Client (WDSc)

• Introduction to WDSc
• Using the Remote System Explorer (RSE)
• Using the Integrated System i Debugger
• Using the IBM WebFacing Tool
• Using WebSphere Development Studio Client (WDSc) Competency Exam

System Administration

IBM i Security

• Introduction to IBM i Security
• Granting Object Authority
• Controlling Application Security
• System Security Considerations
• Creating an Application Environment
• Creating and Maintaining User Profiles
• Security-Related System Values
• IBM i Security Using System i Navigator
• IBM i Security Competency Exam

The Integrated File System

IFS Security

Implementing Single Sign-On

PowerVM Concepts or Introduction to Logical Partitioning

Using IBM Systems Director Navigator for i

Work Management for System Administrators

• Work Management Concepts
• Working with System Values
• Managing Subsystems
• Subsystem Workflow and Job Control
• Streamlining IBM i Operations
• Job Accounting
• Performance Tuning
• Work Management for System Administrators Competency Exam

TCP/IP in the IBM i Environment

• TCP/IP Fundamentals
• TCP/IP Applications
• Configuring and Managing TCP/IP
• Managing TCP/IP Using System i Navigator
• TCP/IP in the IBM i Environment Competency Exam

eBusiness

eBusiness for IBM i Programmers

• eBusiness: From HTML to WebSphere
• Coding HTML and XHTML: Basic Elements
• Coding HTML and XHTML: Advanced Elements
• Coding JavaScript
• Using JavaScript to Enhance Web Pages
• Writing a CGI Program in RPG
• Developing Web Applications Using Net.Data
• Ajax Programming
• eBusiness for IBM i Programmers Competency Exam