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.