ONYX offers classes in the following four categories, with an overview listed below.

Client/Server Applications Development:  Designed for software developers in a client/server environment; that need to understand the interface with software in a distributed processing environment.

Web or internet Applications Development:  Designed for software developers in a web-enabled environment; especially appropriate for mainframe developers transitioning to web application development.
 
Mainframe Applications Development:  Designed for those who develop, maintain and enhance software in a mainframe environment, especially for legacy systems that are expensive to rewrite.
 
Information Technology Foundation:  Designed for non-technical personnel who need a foundation to interface with technical personnel, or technical staff needing pre-requisite courses.

Oracle Overview 1 Day: OR110 (Oracle 9i) or OR510 (Oracle 10g)

This course provides an overview of Oracle and a review of relational concepts such as referential integrity, primary keys, foreign keys, locking, and programming considerations. Topics will also include Oracle architecture, SQL, SQL*Plus, TOAD and PL/SQL programming. Click here to have a detailed outline emailed to you.

Data Modeling 2 Days: OR160 with Data Warehouse Concepts 1 Day: OR165

This course introduces the principles and data modeling. It explains how to incorporate business requirements into a logical data model. The components of a logical data model are defined and how to represent this model as an entity relationship diagram. The normalization of data and how to handle complex relationships are also included. There is the option of an added 1 day class on data warehousing principles which includes the concepts of the star schema and the design of fact tables, event tables and dimension tables. Click here to have a detailed outline emailed to you.

Oracle Interactive Reporting - Answers (Seibel Analytics) for End Users 3 Day: OR440

This course introduces students to the querying and analytical capabilities of Oracle Answers which is the Seibel Analytics product that Oracle purchased. Students learn the querying and analytical capabilities of Oracle Answers using Oracle BI Enterprise Edition (OBIEE) with the web interface. Students will learn to create, modify, run, and refine ad hoc queries and incorporate them into interactive dashboards. They will learn to view, chart, and analyze multidimensional data found in their reporting data warehouse. They will also learn about iBots, Briefing Books and BI Delivers. Click here to have a detailed outline emailed to you.

Discoverer Plus for Administrators 2 Day: OR142 (Oracle 9i) or OR545 (Oracle 10g)

Oracle Business Intelligence (BI) Discoverer Plus is a web-based utility that can be used to specify queries and access data in the database according to the specifications given. BI Discoverer makes finding the data easier than it often is with other interfaces. This course gives participants hands-on experience with administration tasks for Oracle’s Graphical User Interface (GUI) based ad hoc query and data access tool – Discoverer. Students will build the End User Layer for Discoverer. Click here to have a detailed outline emailed to you.

Discoverer Plus for Endusers 2 Day: OR140 (Oracle 9i) or OR540 (Oracle 10g)

This course introduces students to the querying and analytical capabilities of Oracle Discoverer. Students will learn how to view data stored in a relational database, and analyze and create reports based upon that data using Discoverer Plus. In particular, students will learn how to create, modify, and refine ad hoc queries using Discoverer's intuitive and easy-to-use Workbook Wizard. They will learn how to present data graphically, how to format query results to create customized reports, and how to export reports to many other applications, including MS Excel, HTML, and Oracle Reports. Click here to have a detailed outline emailed to you.

Oracle Application Development 5 Days: OR145(Oracle 9i) or OR555(Oracle 10g)

This course provides developers with the skills necessary to code Oracle SQL queries and develop PL/SQL for procedures, functions and triggers. A brief introduction to relational database and Oracle architecture is provided. The course also includes the skills to create database objects (e.g. tables and indexes). Click here to have a detailed outline emailed to you.

Oracle SQL Fundamentals 3 Days: OR150(Oracle 9i) or OR550(Oracle 10g)

This class provides the basic knowledge and skills needed to code SQL statements, and the new features of Oracle. In addition to SQL topics, the course includes relational database management system (RDBMS) concepts such as referential integrity, primary keys, foreign keys, locking, and programming considerations. The SQL information is ANSI standards and can be applied to any RDBMS, including DB2, Oracle, SQL/Server, Informix, etc. Workshops are executed using an appropriate interactive tool such as TOAD or SQL*Plus or company standard software. Click here to have a detailed outline emailed to you.

Oracle PL/SQL Programming 2-3 Days: OR151(Oracle 9i) or OR551(Oracle 10g)

This introductory course provides you with the skills necessary to develop PL/SQL programs for procedures, functions and triggers. Topics include IF-THEN-ELSE, ELSIF, GOTO, LOOPS, WHILE, Cursor Control and error handling. There is a subsequent intermediate/advanced course; namely PL/SQL Workshop Click here to have a detailed outline emailed to you.

Oracle Database for Developers 2 Days: OR152(Oracle 9i) or OR552(Oracle 10g)

This course will provided programmers and developers the understanding of the duties of a Oracle database administrator. On completion of this course, the students will have the foundation to communicate with their DBA’s. Hands-on labs reinforce the learning process. Click here to have a detailed outline emailed to you.

Oracle Database Administration 5 Days: OR153(Oracle 9i) or OR553(Oracle 10g)

This course will combine lecture with hands-on programming to facilitate the student's understanding of the duties of a new Oracle database administrator for Oracle. Hands-on labs reinforce the learning process by allowing students to create and manage their own Oracle servers. Click here to have a detailed outline emailed to you.

Oracle Backup and Recovery (RMAN) 3 Days: OR154 (Oracle 9i) or OR554(Oracle 10g)

This hands-on class is intended for experienced Oracle administrators who need to use or evaluate Recovery Manager, Oracle's utility for backup and recovery. Personnel new to backup and recovery or those currently using user-managed backup techniques will benefit from this class. The course is a comprehensive and practical introduction to RMAN including architecture, setup, backup, restore and recovery, recovery catalog maintenance, debugging, tuning and reporting. The Oracle 10g course includes the new features such as Flash Database and others. Both courses contains many working examples and many hands-on workshop. Click here to have a detailed outline emailed to you.

Oracle Advanced PL/SQL Workshop 3 Days: OR197(Oracle 9i) or OR597(Oracle 10g)

This course provides you with the advanced skills necessary to code Oracle PL/SQL programs with a focus on developing procedures, functions and triggers. Some of the topics include Dynamic SQL, user defined objects, external procedures, object methods, and collections but will depend on the version. Click here to have a detailed outline emailed to you.

Advanced SQL and Performance 3 Days: OR210(Oracle 9i) or OR560(Oracle 10g)

This course provides an in-depth study of SQL, and application-based performance guidelines for relational databases with an emphasis on Oracle specific version. Topics include joins and subqueries and tuning through the use of EXPLAIN to examine the optimizer's access path decisions. These skills will be strengthened through extensive workshops and classroom lecture. This class is intended for both developers and DBA's. Click here to have a detailed outline emailed to you.

Oracle Reports 6i 4 days: OR310

This lab-intensive course is designed to lead developers through the steps involved in developing a report in Oracle. The course covers concepts involved in using the GUI report writer to build reports in various formats, which can include buttons, multimedia and OLE2 objects. This course is directed at Version 6i only. Click here to have a detailed outline emailed to you.

Oracle Reports 5 days: OR311(Oracle 9i) or OR510 (Oracle 10g)

This course is designed to lead developers through the steps involved in developing a report in Oracle in a client-server environment or a web environment. The course covers the use of default reports, the use of wizards to assist in the rapid development of reports and how to format and output reports for the web using the Web Wizard. The course also covers adding PL/SQL code and parameters to reports to automate them. Click here to have a detailed outline emailed to you.

Oracle Forms 5 Days: OR320 (Oracle 9i) or OR520 (Oracle 10g)

This lab-intensive course is designed to lead application software developers through the steps involved in building enterprise-scale Internet applications using the Oracle Forms product. We provide both Oracle 9i and 10g versions of this product. Click here to have a detailed outline emailed to you.

Oracle Data Warehousing 5 Days: OR410

This course considers how to build, implement, tune and utilize data warehouses with Oracle technology. Logical data warehouse concepts are considered such as dimension tables, fact tables and star schemas. Implementing such logical concepts using the Oracle database is then presented including defining dimensions, hierarchies, measures and other objects. Physical implementation techniques are considered such as bitmap indexes, partitioned tables, materialized views, and others. Emphasis is placed on the parallel execution features of the database and how these can yield significant performance advantages. Click here to have a detailed outline emailed to you.

Oracle Warehouse Builder 3 Days: OR416

This course considers how to utilize Oracle Warehouse Builder (OWB) Release 10g as a toolset, to extract, transform and load data. This course is Part I to OWB and will cover defining, configuring, and validating the physical instance of the data warehouse. Topics include generating, and deploying scripts to load the data warehouse. Click here to have a detailed outline emailed to you.

Oracle Warehouse Builder 2 Days: OR418

This course is Part II of the OWB training and covers more on the features of OWB amd multidimensional model including cubes, online analytic processing (OLAP) and using spreadsheet Add-in to query OLAP data. Click here to have a detailed outline emailed to you.

TOAD Tips and Techniques 1 Day: OR460

This hands-on workshop class provides the latest features of TOAD necessary to view, extract, and manipulate data within the Oracle database. This workshop covers all of the features necessary to develop, manipulate, and debug PL/SQL code, develop & tune SQL statements, using Query Builder and ER tools, and discover useful features of TOAD and how to see the data relationships of the application data and how to view/save this data. Click here to have a detailed outline emailed to you.

Oracle 10g New Features 1-2 Days: OR511

This class will give you a sound introduction to the prominent new features available with Oracle10g. The primary objective is to provide you with an understanding of the intended purpose and use of the feature, while adding context from the instructor's research and / or use of the feature. Most topics are discussed within the context of a working example, so you will have a head-start on implementation. Click here to have a detailed outline emailed to you.

Oracle 10g for Experienced Developers: OR515

This course addresses the developer-related features available with Oracle10g. Pre-requisites are developers working knowledge of Oracle 9i. Some of the topics covered are Flashback, Job Scheduler, SQL and PL/SQL enhancements, and DataPump. Most topics are discussed within the context of a working example, so you will have a head-start on implementation. Click here to have a detailed outline emailed to you.

Oracle 10g for Experienced DBA's: OR516

This course addresses the administration-related features available with Oracle10g. Pre-requisites are DBA working knowledge of Oracle 9i. The primary objective is to provide you with an understanding of the intended purpose and use of the new features, while adding context from the instructor’s research and / or use of the feature. Most topics are discussed within the context of a working example, so you will have a head-start on implementation. Click here to have a detailed outline emailed to you.

APEX - Oracle Application Express - 3 days

This class covers the fundamentals of Oracle Applications Express (APEX) including the architecture of APEX and how it works. Students will build a functioning application as they explore the features of this product including basic navigational logic, and UI concepts of APEX application development. Students will also learn the Utilities and SQL Workshop facilities of APEX. This course provides a hands on learning experience thru the lab exercises and demonstrations of some example projects that have been built with APEX. Click here to have a detailed outline emailed to you.

Introduction to Visual Basic 6.0 Programming 3-Days

This course is designed for applications developers who will develop applications in Visual Basic 6.0. It includes programming in a Windows environment, creating user interfaces, and developing event-driven procedures with databases. Click here to have a detailed outline emailed to you.

Advanced Visual Basic 6.0 Programming 4-Days

This course is designed for applications developers who will develop applications with Visual Basic 6.0 in combination with Active X and Microsoft's Component Object Model (COM). Click here to have a detailed outline emailed to you.

C Programming 5-Days

This course will be an accelerated introduction to C programming for students who wish to learn how to code, compile and debug effective and efficient structured C programs. All major elements of the language from expressions identifiers and control statements to I/O functions and libraries will be discussed. This course is suitable for applications developed within any environment. Click here to have a detailed outline emailed to you.

C++ Programming 4-Days

This course will be an accelerated introduction to C++ programming for students Using MS Visual C++. Students will learn how to code, compile and debug effective and efficient structured C++ programs. Major elements of the language from data types and key words, creating new data types using classes to I/O functions. This course is suitable for applications developed in for a 32bit Microsoft environment using Microsoft's Visual C++ in Developer Studio. Click here to have a detailed outline emailed to you.

Introduction to PERL 5 Days

Perl has been described as C, awk, sed, and shell programming all wrapped into one language. Learn how to take advantage of Perl's power through examples and extensive hands-on exercises. This course introduces object-oriented programming in Perl. Click here to have a detailed outline emailed to you.

Advanced PERL 4 Days

Perl has evolved from its beginnings as an eclectic scripting tool for UNIX administrators into one of the most popular, influential, and widely-used computer languages in history. In this course, you will learn how to fully utilize the Perl programming language. Click here to have a detailed outline emailed to you.

UNIX 3 Days

This course introduces the UNIX operating system to users with an Information Systems background who desire a comprehensive, hands-on introduction. The basic course is not specific to a particular UNIX machine, but can be customized to a specific platform if desired. Click here to have a detailed outline emailed to you.

Advanced UNIX with Scripting 3 Days

This course provides a full range of intermediate to advanced Unix tools. It provides the use of those tools useful in creating more advanced and robust utilities that perform complex tasks using the Korn shell environment. The course is not specific to a particular Unix machine, but can be customized to a specific platform if desired. Click here to have a detailed outline emailed to you.

Micro Focus COBOL Workbench 3 Days

This course provides a thorough introduction to the Micro Focus Workbench environment. It provides the skills to develop, test and debug COBOL and COBOL II programs in a PC environment, and upload to a mainframe environment. The course presents how to use the Graphical User Interface Workbench. Click here to have a detailed outline emailed to you.

Micro Focus CICS Option 2 Days

This course provids instruction on how to use the CICS Option (MCO) with the MicroFocus Transaction System (MTS). It provides the needed information and skills to develop, maintain or support CICS COBOL applications in a PC environment, then upload to a mainframe environment. Click here to have a detailed outline emailed to you.

UML Fundamentals - 1 day

UML Fundamentals teaches the basics of object-oriented (OO) principles and the Unified Modeling Language (UML). Starting from a discussion about why we build models, the course introduces the principles of abstraction, encapsulation, modularity and hierarchy. These OO principles are then applied to the fundamental modeling concepts in the UML - objects, classes, attributes, operations, and relationships. Students learn the graphical notation for the most used UML diagrams - collaboration, sequence, and class diagrams. Hands-On classroom experience allows for successful application of basic object-oriented modeling techniques. Click here to have a detailed outline emailed to you.

OOAD Using UML - 4 days

Learn how to use Object-Oriented techniques to analyze real-world requirements and to design solutions that are ready to code. Students learn how to identify and design objects, classes, and their relationships to each other which includes links, associations, and inheritance. A strong emphasis is placed on diagram notation for use cases, class and object representation, links and associations, and object messages. Click here to have a detailed outline emailed to you.

Implementing Design Patterns - 3 days

Design Patterns are proven solutions to recurring problems in object-oriented software systems. This course covers sixteen design patterns and includes detailed programming exercises to allow students to practice implementing selected patterns. Click here to have a detailed outline emailed to you.

Introduction to HTML - 1 day

Students will learn how to use good HTML coding practices to create Web pages that work, and will continue to work in the ever-changing world of Web development. In addition, students learn concepts and do tasks that foster the transition from HTML to the most recent XML-based Web authoring language recommendation, XHTML 1.0, which will become the future standard. Cascading Style Sheets, which is a complementary technology to HTML that is changing the face of Web authoring will also be introduced. Click here to have a detailed outline emailed to you.

HTML Level II - 1 day

Students will learn how to create Web sites with a variety of HTML elements and attributes, and create well-formed code that complies with the XHTML standard. Click here to have a detailed outline emailed to you.

HTML Level III - 1 day

This course is designed to introduce developers to some of the lesser known or "advanced" HTML techniques supported in the 6.0 generation of browsers. With the emergence of more standards-compliant browsers, developers can begin to use these new techniques to build more efficient, usable, and standards-compliant Web sites. In addition, developers can begin to learn and use standards-compliant markup instead of the often messy and invalid code that cross-browser workarounds have required. Click here to have a detailed outline emailed to you.

Introduction to Java Programming - 5 days

This intensive, hands-on course emphasizes becoming productive quickly as a Java 1.2 programmer. Students learn how to use Java 1.2 to implement real-world solutions, including both Web applets and server-side applications. Click here to have a detailed outline emailed to you.

Advanced JAVA - 5 days

This intensive hands-on course explores advanced Java 1.2 language features and packages. Java programmers will be able to take the content learned and immediately apply it to the problems encountered on the job. Click here to have a detailed outline emailed to you.

J2EE- 5 days

This course is an introduction to writing J2EE (Java 2 Enterprise Edition) applications An overview of J2EE technology is provided, followed by hands-on experience using JNDI and JDBC and writing Servlets, JavaServer Pages, and Enterprise JavaBeans. Click here to have a detailed outline emailed to you.

Introduction to PERL - 5 days

Perl has been described as C, awk, sed, and shell programming all wrapped into one language. Learn how to take advantage of Perl's power through examples and extensive hands-on exercises. This course introduces object-oriented programming in Perl. Click here to have a detailed outline emailed to you.

Advanced PERL - 4 days

Perl has evolved from its beginnings as an eclectic scripting tool for UNIX administrators into one of the most popular, influential, and widely-used computer languages in history. In this course, you will learn how to fully utilize the Perl programming language. Click here to have a detailed outline emailed to you.

Introduction to .NET - 1 day

Get a clear understanding of .NET, its origin, architecture, applicability, and its probable impact on the development world. See .NET in action via functional examples and code. Most importantly visualize .NET possibilities for your own development efforts. Click here to have a detailed outline emailed to you.

VB.NET - 5 days

Our comprehensive Visual Basic .NET course provides in-depth coverage of Visual Basic .NET features-from fundamental to advanced topics. This new seminar from AppDev will get you up to speed on all the new features and programming requirements including: VB .NET language features, the .NET framework, ADO.NET, object-oriented programming, Windows Forms, XCopy deployment, and much more... Click here to have a detailed outline emailed to you.

ASP.NET- 5 days (levels 1 - 3)

Level 1

.NET represents a major advance in the way applications are designed on Windows. This change amounts to much more than just a some language syntax changes and a few new Wizards. This course briefly surveys the breadth of this monumental shift and then builds a foundation on which you can add the rest of your knowledge of .NET technologies like ASP.NET, Web Services, and Visual Studio .NET. Learn the essential things you need to know in order to move on with web programming, Windows application programming, Web Services, and more sophisticated programming with .NET.

Level 2

In this course, you'll learn how to use Visual Studio .NET and Visual Basic .NET to build ASP.NET Web pages and XML Web services. You'll gain an understanding of the new architecture behind ASP.NET and how to use the new server controls. You also learn how to use ADO.NET to create data-driven ASP.NET Web forms.

Level 3

This course takes you beyond the basics of creating Web pages and XML Web Services with ASP.NET, by presenting the techniques and concepts you'll need to build efficient, full-featured Web applications. You'll learn to inter-operate with non-.NET code, to manage session state, to re-use code by creating your own controls, to improve performance with output caching, to debug your application and trace its activity, to use advanced Web services features, to configure and deploy ASP.NET applications, to authenticate users and limit their access to resources, to handle multi-user data access conflicts, and to support mobile devices. Click here to have a detailed outline emailed to you.

C#.NET - 5 days

In this course you will learn how to program .NET applications with C#. The course begins with an introduction to the fundamentals of the language, and quickly moves on to demonstrate how to write object-oriented code using this exciting new language. The heart of the course is a detailed description of writing Windows and Web applications, including Web Services, and interacting with back end databases through ADO.NET. Click here to have a detailed outline emailed to you.

WebSphere Studio - 2 days

The course begins with an examination of the framework for developing applications. Such important development issues as database connectivity, profiling, team programming, and the plug?in development environment will be covered. Click here to have a detailed outline emailed to you.

Websphere Server Application Development - 4 days

The course begins with an examination of the facilities and tools of IBM's core products: WebSphere Studio, VisualAge for Java, and WebSphere Application Server. A primary objective is to have students' become proficient with the interaction of WebSphere Studio tools and the appropriate use of each tool. The course then focuses on developing and debugging dynamic web content. A series of integrated workshops teach students to write and deploy Java applications using WebSphere Application Server. Topics unique to IBM WebSphere Application Server such as control, servlet deployment, and JavaServer Pages (JSP) will be highlighted. Performance and design issues are highlighted throughout the course. Click here to have a detailed outline emailed to you.

Websphere Application Server Administration - 4 days

The course begins with an examination of WebSphere's Application Server installation and configuration options. A primary objective is to have students' become proficient with the steps required for administering and implementing security specific to WebSphere Application Server. A series of integrated workshops teach students to administer a range of different scenarios using WebSphere Application Server. Such important issues as recovery, reporting and workload management will be taught/demonstrated. Performance issues are highlighted throughout the course. Click here to have a detailed outline emailed to you.

WebGain Studio - 4 days

The course begins with an examination of the components which comprise the framework of WebGain Studio and the methodology it uses for building Java Applications. A series of integrated walkthroughs and exercises teaches UML basics and StructureBuilder and the techniques for designing applications. Both JSP and EJB will be deployed in the WebGain environment. Click here to have a detailed outline emailed to you.

BEA WebLogic Server Administration - 4 days

This course is intended for support personnel, webmasters, and web programmers who will be responsible for managing and configuring BEA WebLogic Server. Experience with Java and distributed systems, although not required, would be helpful. The course begins with an examination of the BEA WebLogic Server architecture and administrative tools and facilities. Students' will install multiple BEA WebLogic server configurations. Performance and security issues will be highlighted throughout the course. Click here to have a detailed outline emailed to you.

DB2/SQL Application Programming 5 Days

This class provides the knowledge and skills needed to use DB2 and SQL in both interactive and embedded formats. It also includes information on DB2 concepts and facilities, referential integrity, locking, primary keys, foreign keys and data integrity, DB2 physical storage and programming considerations. Dynamic SQL is executed through SPUFI or QMF, and embedded SQL is executed using COBOL application programs. Click here to have a detailed outline emailed to you.

DB2 Embedded SQL Programming 2 Days

This course provides training for skills needed to code DB2 embedded SQL in COBOL application programs. Topics include how to prepare DB2 programs, access DB2 databases using SQL, retrieve multiple rows of output using cursors and handle commit processing through COBOL programs. Click here to have a detailed outline emailed to you.

Advanced SQL/DB2 Performance 2 Days

This course provides in-depth study of SQL especially joins and subqueries, and will strengthened these skills through extensive workshops and classroom lecture. A solid introduction to application-based DB2 performance tuning thru the use of EXPLAIN to examine the DB2 optimizer's access path decisions. Click here to have a detailed outline emailed to you.

COBOL II Programming 5 Days

This class provides people with the knowledge and skills needed to code COBOL II application programs. It also covers effective use of the language for report generation using sequential file inputs. The course can easily be divided into two parts; namely a three-day basic, followed by two-day additional COBOL topics. Click here to have a detailed outline emailed to you.

COBOL II Refresher 3 Days

This class provides the additional knowledge and skills needed to code COBOL II application programs for people who have basic knowledge of COBOL II. Topics include using VSAM file processing, variable length file processing, internal sort, multi-dimensional table processing, and dedugging techniques. In addition the course also presents principles of structure programming in COBOL coding and also covers effective use of the language. Click here to have a detailed outline emailed to you.

IBM COBOL II (OS 390) 1 Days

This class provides the additional knowledge and skills needed to code COBOL II application programs in an IBM OS 390 environment. It is for people who have basic knowledge of COBOL II, and it provides a method for getting and manipulating a true four-digit year in a COBOL Program. Topics include COBOL Intrinsic Functions and LE Callable Functions, which are Year-2000 compliant in their handling of dates. Click here to have a detailed outline emailed to you.

TSO/ISPF 2 Days

This course covers ISPF and provides an introduction to using TSO, MVS and SDSF. Students will learn the major functions of these tools in an MVS environment; such as browse, edit, and features available in the library function. They will also learn several valuable shortcuts, which will help make them more productive on the job. Click here to have a detailed outline emailed to you.

MVS JCL 3 Days

This course introduces JCL and provides the knowledge and skills necessary to code and execute batch jobs. It contains information pertaining to MVS/ESA. In addition to covering the basics of the JOB, EXEC and DD statements, the course provides the basics for MVS utility programs such as IDCAMS, IEBGENER and IEBCOPY. The course can be taught as a two-day class without the utilities. Click here to have a detailed outline emailed to you.

MVS JCL UTILITIES 2 Days

This course provides the basic knowledge of commonly used MVS utility programs such as IDCAMS, IEBGENER, IEBPTPCH, IEBCOMPR, IEBCOPY and SORT/MERGE. The course is an excellent review of JCL and the control statements available for each utility. Click here to have a detailed outline emailed to you.

INTRODUCTION TO VSAM 3 Days

This course provides the basic concepts of VSAM file processing and the facilities, such as IDCAMS and JCL usage, which makes VSAM easier to work with. This course also will provide an understanding of how VSAM uses objects such as catalogs, control intervals, control areas, indexes, etc. In addition, participants will practice creating these objects using IDCAMS. Click here to have a detailed outline emailed to you.

VSAM PROGRAMMING 2 Days

This course provides the skills needed to code COBOL and COBOL II programs that access VSAM datasets. A pre-requisite to this course is an Introduction to VSAM, which can be added to the programming topics to provide information on both VSAM concepts and programming. Click here to have a detailed outline emailed to you.

CICS COMMAND LEVEL PROGRAMMING 5 Days

This class provides the skills needed to code COBOL application programs using the CICS/MVS and CICS/ESA Command Level interfaces. CICS concepts and structures as well as programming detail, such as file control, DB2 access, program control and terminal handling, are included. Other areas of CICS are also presented: queue management, program preparation, testing and debugging. Click here to have a detailed outline emailed to you.

EASYTRIEVE PLUS 3 Days

The course presents an introduction to EASYTRIEVE PLUS. The seminar is directed at developers extracting information from files to create reports. The course will utilize lectures, conversations, inquiries, adhoc testing, manual and online error report references, and extensive use of hands-on labs with coding exercises. Click here to have a detailed outline emailed to you.

DOS/VSE JCL 3 Days

This course introduces JCL and provides the knowledge and skills necessary to code and execute batch jobs. It contains information pertaining to DOS/VSE, POWER, and JECL. In addition to covering the basics of the JOB, EXEC and DLBL, TLBL, and EXTENDS statements, the course provides the basics for VSE utility programs such as IDCAMS, SORT, and DITTO. Click here to have a detailed outline emailed to you.

Introduction to Information Technology 3 Days

This course provides the basic concepts of information systems and computers as productivity tools. It provides an understanding of the information processing cycle, which includes input, process, output and storage. Networking, relational databases, programming, client server concepts and future trends are also discussed. An emphasis is placed on increasing the comfort level with computer terminology, acronyms and general information. Click here to have a detailed outline emailed to you.

Introduction to Client/Server 3 Days

This series provides training for software developers in a Client/Server environment. Topics such as Oracle relational database, Unix, Object Oriented Design and Programming, Visual Basic, C++, and PL/SQL are included. The intended audience is people who develop software in a Client/Server environment, and the pre-requisite is a solid foundation in Information Technology. Click here to have a detailed outline emailed to you.

Introduction to Object Oriented Analysis and Design 1-2 Days

This course introduces the features of object-oriented technologies to managers, programmers and analysts. The students will learn the benefits claimed for object-oriented technologies, as well as the reality behind the claims. The most common object-oriented programming languages will be identified. In addition, the role of object-oriented analysis and design will be described. Finally, the students will be given some guidelines to follow for initial object-oriented projects. Click here to have a detailed outline emailed to you.

Introduction to Relational Databases 1 Day

This course provides relational concepts and facilities. There is an overview for DB2, Oracle, and SQL Server relational database management systems (RDBMS). In addition to management-level topics, the course includes areas such as referential integrity, primary keys, foreign keys, locking, and programming considerations. Click here to have a detailed outline emailed to you.

SQL Fundamentals 2 Days

This class provides the basic knowledge and skills needed to code SQL statements. The SQL information is ANSI standards and can be applied to any relational database management system (RDBMS), including DB2, Oracle, SQL/Server, Informix, etc. Workshops are executed using an appropriate interactive tool such as SPUFI, QMF, SQL/PLUS or company standard RDBMS software. Click here to have a detailed outline emailed to you.

Structured Programming Logic - Part I 3 Days

This course provides the concepts and fundamentals for designing structured programs before coding begins. Several methods are introduced for designing and documenting structured programs, such as functional decomposition, hierarchy charts and pseudo-code, as well as flowcharting. Topics include simple reports, summary reports with counts and totals, and programs with complex calculations. Structured walkthroughs are presented with each design. Click here to have a detailed outline emailed to you.

Structured Programming Logic - Part II 3 Days

This course provides the concepts and fundamentals for designing structured programs before coding begins. Several methods are introduced for designing and documenting structured programs, such as functional decomposition, hierarchy charts and pseudo-code, as well as flowcharting. Topics include simple reports, summary reports with counts and totals, programs with complex calculations, multi-level control breaks, file updating, and table processing. Structured walkthroughs are presented with each design. Click here to have a detailed outline emailed to you.

Project Management Principles 1-2 Days

This course presents methods and techniques that project managers can use to achieve success in the deployment of projects. It is based on the Microsoft Solutions Framework and provides 4 basic planning tools for managing projects; team model, process model, risk management process and the "trade-off triangle." Click here to have a detailed outline emailed to you.

Data Modeling 2 Days

This course introduces the principles and data modeling. It explains how to incorporate business requirements into a logical data model. The components of a logical data model are defined and how to represent this model as an entity relationship diagram. The normalization of data and how to handle complex relationships are also included. Click here to have a detailed outline emailed to you.

Process Modeling 3 Days

This course provides a practical approach to process modeling activities involved in the analysis phase of the typical systems development life cycle. It is applicable to the process modeling component of most methodologies and topics includes Data Flow Diagramming, Event List Processing, Action Diagrams, Decision Tables and Trees. Techniques for balancing of the process model to the data model is also discussed. Automated CASE tool usage is briefly discussed during the course. It is not applicable to object oriented analysis and design. Click here to have a detailed outline emailed to you.