Oracle
Database Administration - DBA
Oracle
Database Backup & Recovery
Oracle Database
Performance Tuning
Oracle9i
New & Advanced Features for DBAs
Description
This course
considers all the features of building complex logical data models using
sophisticated modeling techniques. Numerous ‘real-world’ problems and special
situations are presented along with solutions. Classic structures and common
models are also given to assist participants in rapidly completing a data
model. Traditional modeling techniques as well as newer object-oriented
modeling principles are presented providing state-of-the-art modeling skills to
attendees. This course may be presented using the modeling syntax of Oracle Designer
or independent of any specific modeling tool. This course is alternately
entitled "Oracle Designer Data Modeling".
At
Course Completion
Description
The foundation for all
Oracle professionals is the SQL language along with Oracle's SQL*Plus
extensions. A detailed consideration of these languages includes such topics as
creating and maintaining table definitions in the data dictionary, specifying
data types, manipulating tables and developing sophisticated queries quickly
and accurately.
Description
The Oracle PL/SQL
language provides for programming logic features not contained within SQL. The
grammar, syntax and benefits of using the PL/SQL language within an Oracle
database environment are considered.
At
Course Completion
The primary objective
of this course is to provide an introduction to the PL/SQL database programming
language.
Description
Essential advanced features within the Oracle SQL language are considered within this course. Building indexes, specifying declarative constraints, managing security privileges for tables and using SQL to satisfy some of the most complex query requests are all among the topics considered within this course. This course largely focuses on SQL features that are unique to the Oracle database and as such is applicable even for SQL professionals experienced in other databases.
Oracle Database Administration - DBA
Description
This course
provides a starting point for administration of the Oracle database. The first
2-day segment considers an in-depth discussion of the database architecture,
including the Oracle instance, background processes, the SGA and memory
structures, data files, tablespaces, extents, blocks
and rows. Common administration tasks are also considered such as security,
backup & recovery, physical storage of indexes and tables and many others.
This course was
formerly called "Oracle Database Architecture & Administration".
At
Course Completion
Oracle Database Backup & Recovery
Description
One of the most
challenging tasks ever presented to database administrators is that of recovery
from failure, especially if the recovery must not result in a loss of any data.
This course presents all the standard failure scenarios and the best recovery
strategies for each. Backup strategies for cold backups, on-line backups,
complete and partial backups are discussed. Extensive exercises allow students
to simulate failures and perform actual recovery within the workshop.
At
Course Completion
The
objective of this course is to equip database administrators with the skills
necessary to backup a production Oracle database and to recover as much
information as possible in the event of a major failure. Significant subjects
to be considered are:
Oracle Database Performance Tuning
Description
This course
presents techniques for finding performance or configuration problems within
the Oracle database and solving those problems. Manual techniques as well as
those employing the specialty Packs within Oracle Enterprise Manager are
considered. Workshop exercises allow participants the opportunity to examine
the internal operation of an Oracle instance, isolate problems, test possible
solutions and implement effective remedies.
This course was
formerly called "Oracle Database Tuning & Troubleshooting".
Description
This course
uncovers the mystery of the Oracle database middleware contained within Oracle
Net / SQL*Net. All of the configuration files are considered along with their
contents and how these can be customized. The Oracle Net assistant is also
covered and this tool is used for multi-threaded server configuration of the
database, activating the Oracle Names Server and the Oracle Connection Manager.
At
Course Completion
·
Configure a distributed Oracle Net and SQL*Net environment
·
Use the Oracle Net Assistant for simple and complex configurations
·
Place the database in multi-threaded server mode
·
Incorporate the Oracle Names Server and Connection Manager into
the environment
Oracle9i New & Advanced Features for DBAs
Description
This course is designed for database administrators who will be moving
to the Oracle9i database platform. This course presents the new and advanced
features of the database introduced in its 9i release.