10g:
Introduction to SQL
In this course you are introduced to the Oracle Database 10g technology. You
are also introduced to the relational database concepts and the SQL programming
language in great detail.
|
10g: Program
with PL/SQL
This course introduces students to PL/SQL and helps them understand the
benefits of this powerful programming language. In the class, students learn to
create PL/SQL blocks of application code that can be shared by multiple forms,
reports, and data management applications.
|
10g: Advanced
PL/SQL
In this course, students learn how to use the advanced features of PL/SQL in
order to design and tune PL/SQL to interface with the database and other
applications in the most efficient manner. Using advanced features of program
design, packages, cursors, extended interface methods, and collections,
students learn how to write powerful PL/SQL programs. Programming efficiency,
use of external C and Java routines, PL/SQL server pages, and fine-grained
access are covered.
|
10g:
SQL Tuning Workshop R2
This course is designed to give the experienced SQL Developer or DBA a firm
foundation in SQL tuning techniques. The participant learns the necessary
knowledge and skills to effectively tune SQL in the Oracle Database 10g. They
learn about tuning methodology as well proactive tuning and reactive tuning
methods.
|
10g:
New Features for Administrators
This course introduces students to the new features in Oracle Database 10g -
the database for Grid computing. Students learn how to use Oracle Database 10g
new features to increase database availability, to simplify database
performance monitoring and tuning through the use of Oracle Database 10g
Advisors, and to offer simplified database manageability.
|
11g:
New Features for Administrators NEW
This course introduces students to the new features in Oracle Database 11g
Release 1- the change management capabilities on Oracle databases. Students
learn how to use Oracle Database 11g new features to manage change,
to ensure high-availability, to improve scalability and performance, to
increase data availability, and to offer simplified database manageability.
|
10g:
Administrators Workshop I
This course is your first step towards success as an Oracle professional,
designed to give you a firm foundation in basic database administration. In
this class, you will learn about the architecture and how its components work
and interact with one another and also how to install and maintain an Oracle
database.
|
10g:
Administrators Workshop II
Reduce downtime, increase security and improve the performance of Oracle
Database by taking the Administration Workshop II course. This class equips you
with the expertise to efficiently administer the database and move data from
one database to another. The included hands-on practices and workshops
reinforce the in-class training and ensure competency in this field.
|
10g: Performance Tuning
Get the most out of your 10g Database by learning performance tuning methods
that maximize the utility of the database. Students learn how to benefit from
Oracle Database 10g automatic tuning features, as well as practicing the manual
tuning methods using the statspack tool. After clearly defining the various
methodologies one can use to tune an Oracle Database, the course covers the
various tunable components of an Oracle Database. Throughout the course,
students experience hands-on the tuning of an Oracle Database by practicing
through a series of workshops.
|
10g: RAC For
Administrators (R2)
This course offers students an introduction to the general features and
capabilities of Oracle Database 10g Release 2 for Oracle Real Application
Clusters (RAC). Students learn how to install and administer OracleClusterware,
Real Application Clusters, and Automatic Storage Management. Students also
learn how to administer their Database in a Real Application Clusters
environment using Enterprise Manager Grid Control.
|
10g:
Dataguard
In this course, students learn how to use Oracle Data Guard to help protect
their Oracle Database against planned and unplanned downtimes. Data Guard
architecture is discussed, as well as the creation of physical and logical
standby databases
|
10g:
OEM Grid Control
This course introduces students to Oracle Enterprise Manager 10g Grid Control.
Students learn how to use Grid Control to install the management agent,
configure administrators and groups, manage targets and jobs and establish
security of the environment. Hands-on practice sessions give students an
opportunity to examine many of the Grid Control capabilities for themselves.
|
10g:
Backup & Recovery
In this course students learn how to use RMAN to effectively manage their
backup and recovery procedures. In addition, they learn how to use Oracle
Secure Backup for tape backup of Oracle Database files and file system files.
|
9i: DBA
Fundamentals I
This course is designed to give the Oracle database administrator (DBA) a firm
foundation in basic database administrative tasks. Students will gain a
conceptual understanding of the Oracle9i database architecture and how the
architectural structures work and interact with one another.
|
9i: DBA
Fundamentals II
This course gives the Oracle database administrator (DBA) a firm foundation in
fundamental database administrative tasks. Students learn about loading and
transporting data into databases, and the utilities used to perform these
activities. Students are also introduced to networking concepts and
configuration parameters, as well as how to solve some common network problems.
|
9i: Database
Performance Tuning
Database performance tuning is critical to any effective information system.
Reducing wait times, increasing users' productivity and maximizing the
performance of your Oracle database are critical to success.
Return to top
|
9i:
Advanced Replication
In a distributed environment, the availability of replicated data at multiple
sites is crucial to the success of the business. This course introduces you to
the Oracle replication facility to increase the availability of data at
multiple locations.
|
Managing
Oracle on Linux
The Linux operating system (OS) is one of the most exciting developments in the
world of Information Technology. Installation, administration, configuring and
tuning topics will equip the administrator to extract optimal performance with
the Oracle9i database on the Linux OS.
|
10g:
Spatial Fundamentals
This course teaches students how to model and create tables with spatial data,
index spatial data, and discusses how to spatially enable applications.
Students learn about Oracle's native data type for spatial data (SDO_GEOMETRY)
and the geometric primitives it supports. Additionally, students learn how to
load spatial data into Oracle database with various Oracle utilities
|
10g: RAC Deployment Workshop
Students attending this workshop will explore advanced RAC-related topics. These topics include node/instance/cluster management, enterprise-capable shared storage solutions and management, networking, and Oracle products integration. Since this is a workshop, hands-on lab work is stressed.
|
Data Modelling
& Rel. DB Design
This course covers the use of Entity Relationship Modeling in detail, through
many real life examples, practical business problems and solutions. After
several iterations, the ER model captures the data requirements and business
rules and forms a sound basis for the initial design of a relational database.
Return to top
|