| Title | Description | Duration | Outline |
|---|
|
Introduction To Oracle 9i
|
This class will develop database-programming skills
using SQL and PL/SQL. Students will learn the Oracle9i architecture,
relational design concepts, simple and complex query skills, PL/SQL
programming skills, proper software engineering techniques for
database programming, Oracle problem solving, and performance tuning
skills.
Level: Introduction
|
5 Days
| |
|
Oracle 9i DBA Fundamentals I
|
This class will develop the fundamental skills necessary to be an Oracle DBA.
Students will design and create a server using the Optimal Flexible Architecture
(OFA), configure logical and physical structures, set up database and user
security, add and administer users, and monitor and tune main server areas. Each
student will create a toolkit of administration scripts for database management
and tuning by the end of this class. This class will also address issues for
DBAs having to support Oracle8i and Oracle9i databases.
Level: Introduction
|
3 Days
| |
|
Oracle 9i SQL Programming
|
This class will develop
database programming skills using SQL.
Relational and object concepts will be covered.
Students will learn
complex SQL programming skills,
features, and tools.
Level: Introduction
|
3 Days
| |
|
Oracle Database 11g: SQL Fundamentals - Complete Coverage
|
The objective of this course is to provide an introduction to
the SQL database language within the context of an Oracle database,
based upon the latest features available. The primary objective of
this course is to consider advanced subjects and techniques
pertaining to the SQL database language, based upon the latest
features available with the Oracle release. Even professionals
experienced in other implementations of the industry-standard SQL
language will benefit from the advanced and Oracle-specific
features of SQL discussed in this course.
Level: Introduction
|
5 Days
| |
|
Oracle Database 11g: SQL Fundamentals I
|
This course is a common starting point in the Oracle database curriculum
for administrators, developers and business users. The objective of this
course is to provide an introduction to the SQL database language within
the context of an Oracle database, based upon the latest features available.
Level: Introduction
|
3 Days
| |
|
Relational Database Design
|
This course is one common starting point for the entire database curriculum.
The objective of this course is to consider the logical design of relational
databases using a methodology known as semantic data modeling and related
practical techniques.
Level: Introduction
|
2 or 3 Days
| |
|
ADO .NET Using Oracle and C#
|
This course presents
the essential elements of ADO.NET and how
to build effective Oracle database applications.
The course includes coverage of
the Oracle Data Provider for .NET (ODP.NET).
There is a practical discussion of data binding and its use in both
Windows Forms and Web Forms (ASP.NET) applications. Students will
gain a familiarity with creating a Data Access Layer, as it
applies to traditional three-tier application architecture.
Level: Intermediate
|
3 Days
| |
|
Oracle 9i DBA Fundamentals II
|
Presents the fundamentals of setting up Oracle Net Services,
configuring the shared server architecture, and backup and recovery. This class
covers the different ways an Oracle9i instance and database can fail and the
best options for recovery. Students will learn how to perform backup and
recovery with and without RMAN. Students will learn how to minimize points of
failure and reduce the Mean Time To Recover. Through the numerous backup and
recovery labs, students will gain confidence that they can recover a database
after an Oracle9i server goes down.
Level: Intermediate
|
3 Days
| |
|
Oracle 9i PL/SQL Programming
|
Students will learn
the fundamentals of the PL/SQL programming language. Stored procedures,
functions, packages and triggers implement complex business rules in Oracle.
Students will learn programming, management and security issues of working with
PL/SQL program units.
Numerous exercises and labs will introduce
students to the new PL/SQL features in Oracle9.
Level: Intermediate
|
3 Days
| |
|
Oracle Applications using ADO .NET and C#
|
A comprehensive course that provides
an introduction to Oracle Database programming
for use within the .NET environment.
Level: Intermediate
|
5 Days
| |
|
Oracle Database 11g: PL/SQL Fundamentals - Complete Coverage
|
The primary objective of this course is to provide an introduction to
the PL/SQL database programming language, based upon the latest
features available with the Oracle database. Syntax, structure and
features of the language are discussed in the context of database
applications and programming. This course equips students to develop
database server-side PL/SQL program units within an Oracle database.
Level: Intermediate
|
5 Days
| |
|
Oracle Database 11g: PL/SQL Fundamentals I
|
The primary objective of this course is to provide an introduction
to the PL/SQL database programming language, based upon the latest
features available with the Oracle database.
Syntax, structure and features of the language are discussed in
the context of database applications and programming.
Level: Intermediate
|
2 Days
| |
|
Oracle Database 11g: PL/SQL Fundamentals II
|
The objective of this course is to equip students to develop
database server-side PL/SQL program units within an Oracle
database.
Level: Intermediate
|
3 Days
| |
|
Oracle Database 11g: SQL Fundamentals II
|
The primary objective of this course is to consider advanced subjects and
techniques pertaining to the SQL database language, based upon the latest
features available with the Oracle release. Even professionals experienced
in other implementations of the industry-standard SQL language will benefit
from the advanced and Oracle-specific features of SQL discussed in this
course. This enhanced and expanded revision includes many new and expanded
conceptual subjects.
Level: Intermediate
|
3 Days
| |
|
Oracle 9i Advanced PL/SQL Programming
|
This class will focus on developing advanced PL/SQL programming skills.
Topics will include the built-in packages that come with Oracle, the creation of triggers
and advanced stored procedure features. The class will also cover
object-relational concepts, performance tuning and dynamic SQL. The Oracle9
release has greatly enhanced the features and functionality of PL/SQL.
Numerous exercises and labs will introduce students to these new features.
Level: Advanced
|
3 Days
| |
|
Oracle 9i Server Performance Tuning
|
This class teaches DBAs how to tune an Oracle9i server.
Participants will learn the different areas that impact performance,
how to detect performance issues,
verify the performance problem, determine what to tune, understand the
ramifications of making changes, and then verify the results. Tuning Oracle
memory areas, contention and waits, physical I/O, checkpoints, undo segments,
temporary segments, archiving versus noarchiving, will be covered. Students will
learn how to work with different Oracle performance and diagnostic tools. Labs
involve running scripts to generate activity, detecting performance problems,
and then learning how to fix the performance issues.
Level: Advanced
|
3 Days
| |
|
Oracle Database 11g: Administration I
|
The overall objective of this course is to allow the student to gain
the skills necessary for day-today administration of an Oracle
database. This course is the starting point for Oracle database
administrators and also sets the foundation for advanced administrator
training and certification.
Level: Advanced
|
5 Days
| |
|
Oracle Database 11g: Administration II
|
The overall objective of this course is to bring database
administrators beyond a basic understanding of their environment
and to focus attention on more advanced skills needed to effectively
configure, administer, monitor and tune the database within a
large-scale enterprise.
Level: Advanced
|
5 Days
| |
|
Oracle Database 11g: New Features For Administrators
|
The purpose of this course is to present some of the most advanced
features available to database administrators which were either
introduced with the Oracle 11g release or have been substantially
improved with that release.
Level: Advanced
|
5 Days
| |
