Oracle SQL
Fundamentals 3 Days: OR150(Oracle 9i) or OR550(Oracle
10g)
This class provides the basic knowledge and skills needed
to code SQL statements, and the new features of Oracle.
In addition to SQL topics, the course includes relational
database management system (RDBMS) concepts such as referential
integrity, primary keys, foreign keys, locking, and programming
considerations. The SQL information is ANSI standards
and can be applied to any RDBMS, including DB2, Oracle,
SQL/Server, Informix, etc. Workshops are executed using
an appropriate interactive tool such as TOAD or SQL*Plus
or company standard software.
Oracle PL/SQL Programming 2-3 Days: OR151(Oracle
9i) or OR551(Oracle 10g)
This course provides you with the skills necessary to
code Oracle Version 9i SQL queries with a focus on developing
PL/SQL programs for procedures, functions and triggers.
Topics include IF-THEN-ELSE, ELSIF, GOTO, LOOPS, WHILE,
Cursor Control and error handling.
Oracle Database Administration 5 Days: OR153(Oracle
9i) or OR553(Oracle 10g)
This course will combine lecture with hands-on programming
to facilitate the student's understanding of the duties
of a new Oracle database administrator for Oracle 9i.
Hands-on labs reinforce the learning process by allowing
students to create and manage their own Oracle servers.
Data Modeling 2 Days: OR160
This course introduces the principles and data modeling.
It explains how to incorporate business requirements
into a logical data model. The components of a logical
data model are defined and how to represent this model
as an entity relationship diagram. The normalization
of data and how to handle complex relationships are
also included.
Oracle PL/SQL Workshop 3 Days: OR197(Oracle
9i) or OR597(Oracle 10g)
This course provides you with the advanced skills necessary
to code Oracle PL/SQL programs with a focus on developing
procedures, functions and triggers. Some of the topics
include Dynamic SQL, user defined objects, external
procedures, object methods, and collections but will
depend on the version.
Advanced SQL and Performance 2 Days: OR210(Oracle
9i) or OR560(Oracle 10g)
This course provides an in-depth study of SQL, and application-based
performance guidelines for relational databases with
an emphasis on Oracle specific version. Topics include
joins and subqueries and tuning through the use of EXPLAIN
to examine the optimizer's access path decisions. These
skills will be strengthened through extensive workshops
and classroom lecture.
Oracle Data Warehousing 5 Days: OR410
This course considers how to build, implement, tune
and utilize data warehouses with Oracle technology.
Logical data warehouse concepts are considered such
as dimension tables, fact tables and star schemas. Implementing
such logical concepts using the Oracle database is then
presented including defining dimensions, hierarchies,
measures and other objects. Physical implementation
techniques are considered such as bitmap indexes, partitioned
tables, materialized views, and others. Emphasis is
placed on the parallel execution features of the database
and how these can yield significant performance advantages.
|
