| Title | Description | Duration | Outline |
|---|
|
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
| |
|
ADO .NET Using Oracle and Visual Basic
|
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 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 Database 11g R2: Administration I
|
The overall objective of this training course is to allow the student
to gain the skills necessary for day-to-day administration of an Oracle database.
These training materials are the starting point for Oracle database administrators and sets the
foundation for advanced administrator training and certification.
Level: Advanced
|
5 Days
| |
|
Oracle Database 11g R2: Advanced Database Administration
|
This course brings database administrators beyond a basic understanding
of their duties and to transfer advanced skills needed to effectively
administer an Oracle database installation within a large-scale enterprise.
Level: Advanced
|
3 Days
| |
|
Oracle Database 11g R2: Architecture & Internals
|
The purpose of this course is to reveal the underlying architecture of the Oracle database environment.
This course is also intended to be of help to information technology (IT) managers and executives who
require an understanding of the technology upon which they and their staff rely.
Level: Advanced
|
2 Days
| |
|
Oracle Database 11g R2: Encryption & Advanced Data Security
|
This course considers how encryption technology should, and should not,
be employed within an Oracle database environment in response to known
threats and risks. It will also discuss other best security practices
which pertain to application security, host system configuration and the
database installation.
Level: Advanced
|
2.5 Days
| |
|
Oracle Database 11g R2: RMAN Backup & Recovery
|
This course brings database administrators beyond a basic understanding
of their duties and to transfer advanced skills needed to effectively
administer an Oracle database installation within a large-scale enterprise.
Level: Advanced
|
3 Days
| |
|
Oracle Database 11g R2: Resource Manager & Scheduler
|
This course brings database administrators beyond a basic understanding
of their duties and to transfer advanced skills needed to effectively
administer an Oracle database installation within a large-scale enterprise.
Level: Advanced
|
2 Days
| |
|
Oracle Database 11g R2: SQL Tuning
|
The purpose of this course is to equip database administrators and application developers
to build efficient SQL statements and to tune database applications. When this effort is
complemented by database server and PL/SQL application tuning, then a highly efficient
application execution environment is created. One will learn about the internals of
SQL statement execution, how to monitor the performance of such execution, and how one
can influence the behavior of the database to achieve performance gains.
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
| |
