Oracle8/Oracle7 DATABASE ADMINISTRATION 1  (5 days)

This 5 day class is for intermediate to advanced Oracle developers, programmers and DBA’s. The class covers the following material:
How to use SVRMGR to start and stop the database. Improving Oracle performance through proper file placement.
Backup and Recovery strategies. Table recovery through Export/Import. Copying Flat files into the Oracle database. Utilizing Roles to create appropriate privileges and perform grants. Creating tablespaces for better performance and organization. Creating databases with mirrored control files & redo logs. Understanding the Oracle Architecture and its features and flaws. Mastering the Shared SQL Area to improve performance & reduce contention. Utilizing the dynamic performance tables to identify Data Dictionary problems. Developing a plan to find contention with Redo Logs & Rollback segments.  Building databases to bring Public and private Rollback Segments online.

Oracle8/Oracle7 DATABASE TUNING  (3 days)
This 3 day class is for intermediate to advanced Oracle developers, programmers and DBA’s. The class covers the following material:  How to use SVRMGR to start and stop the database.  Improving Oracle performance through proper File placement.  Utilizing Roles to create appropriate privileges and perform grants.  Creating tablespaces for better performance and organization.  Creating databases with mirrored control files & redo logs.  Understanding the Oracle Architecture and its features and flaws.  Mastering the Shared SQL Area to improve performance & reduce contention.  Utilizing the dynamic performance tables to identify Data Dictionary problems.  Developing a plan to find contention with Redo Logs & Rollback segments.  Building databases to bring Public and private Rollback Segments online

Oracle8/Oracle7 Developer 2000  (5 days)
This class is for beginning to intermediate developers and programmers. The class covers the following material:
How to use the Oracle GUI interfaces and Object Navigator.  Identifying the capabilities and performance features of Developer 2000.  Utilizing Oracle FORMS for creating simple screens.  Learning to use Forms to create Master/Detail screens.  Modifying data using Oracle Forms and restricting INSERT/UPDATE/DELETE capabilities.  How to use ORACLE REPORTS for developing simple reports.  Master/Detail reports using multiple table data.  Allowing customers to pass data into a report for better reports.  Forms, Tabular, master/detail and Label reports are produced.  Utilizing Oracle graphics to produce bar, pie and line graphs.  Creating menus to use Forms, Reports & Graphs.

Oracle8/Oracle7 Performance & Tuning  (3 days)
This 3 day class is for beginning to intermediate Oracle developers and programmers. The class covers the following material:  How to use administrative SQL and query the Data Dictionary for performance data.  Identifying the levels of tuning for an Oracle7 database.  The ability to utilize tablespaces and roles for improving access to Oracle tables.   Utilizing ROWID for faster Oracle data retrieval.  Learning to use HINTS to influence the Oracle Optimizer.  When to use RULE-based optimization versus COST-based optimization.  How to review Oracle’s optimization plan using the EXPLAIN statement.  Mastering FIRST-ROWS, ALL_ROWS, COST, CHOOSE, & RULE optimization through ALTER SESSION statements.  Utilizing the ORACLE diagnostic tools SQL_TRACE & TKPROF.  Developing objects using ANSI constraints (CHECK, UNIQUE, Primary and Foreign key) implementation.  Building Indexes and using CLUSTERS.  Estimating storage requirements.  Oracle LOCKING.

ORACLE PL/SQL

Introduction to PL/SQL.  Processing in the PL/SQL environment.  Scalar Variables.  Scoping Variables.  Creating Records & PL/SQL Tables. Using Composite records.  Modifying Records in PL/SQL Blocks.  Execution Block.  Using Exception block.  Cursor Processing.  Passing Parameters with Cursors.  Creating Procedures & Functions.  Defining Triggers.