Distributed Process-DATABASE
Oracle Overview 1 Day OR110
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 OR120
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.
Discoverer Plus for Endusers 1 Day OR140
This course introduces students to the querying and analytical capabilities of Oracle 9iAS 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
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 9i 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
This class provides the basic knowledge and skills needed to code SQL statements, and the new features of Oracle 9i. 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
This course provides you with the skills necessary to code Oracle Version 9i SQL queries with a focus on developing PL/SQL programs for procedures, functions and triggers. Topics include IF-THEN-ELSE, ELSIF, GOTO, LOOPS, WHILE, Cursor Control and error handling. Click here to have a detailed outline emailed to you.
Oracle9i Database For Developers 2 Days OR152
This course is targeted for developers who need an understanding of the tasks to
design and manage the data structures that support Oracle database applications.
This class will combine lecture with hands-on labs to facilitate the student’s
understanding of the Oracle database server architecture and SQL statement
processing, and learn how to organize and create tables and related storage
structures in the database. On completion of this course, the students will know
how to use and design a schema, load and extract data from the database, enforce
business rules with constraints, and have the foundation to communicate with
their DBA’s.
Oracle9i Database Administration 4 Days OR153
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 9i. 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.
Oracle9i Database Administration Part II
OR155
This course prepares students to backup, recover and network an Oracle9i Server
Database. The course covers the advanced options of the ORACLE 9i Server
architecture related to backup and recovery and the methods available for Oracle
Server networking.
Oracle Advanced PL/SQL 3 Days OR197
This course provides you with the advanced skills necessary to code Oracle Version 9i SQL queries with a focus on developing PL/SQL programs for procedures, functions and triggers. Some of the topics include Dynamic SQL, user defined objects, external procedures, object methods, and collections. Click here to have a detailed outline emailed to you.
Advanced SQL and Performance 2 Days OR210
This course provides an in-depth study of SQL, and application-based performance guidelines for relational databases with an emphasis on Oracle. 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. Click here to have a detailed outline emailed to you.
Oracle Developer Report Builder 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. Click here to have a detailed outline emailed to you.
Oracle Developer Report Builder 4 Days OR320
This lab-intensive course is designed to lead application software developers through the steps involved in building enterprise-scale Internet applications using the Oracle9iDS Forms product. Click here to have a detailed outline emailed to you.
Oracle 10g for Experienced Developers and DBA's OR515
This course provides you with the advanced skills necessary to code Oracle
Version 10g PL/SQL programs with a focus on advanced features of PL/SQL
programming for procedures, functions and triggers. Some of the topics include
Dynamic SQL, user defined objects, external procedures, object methods, bulk
processing, intersession communication, UTIL_FILE and UTIL_MAIL.
Distributed Process-PROGRAMMING
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.
|
