Oracle Technical Overview

Course Number:  579-JK
Recommended Duration:  1 day

Intended Audience
Management, Users, Programmers, and anyone else desiring an overview of the Oracle environment.

Course Overview
An overview of Oracle's database and tools for business managers, technical managers, and technical personnel.

Course appropriate for Oracle 10g.  Course covers Oracle9i and Oracle8i.  It is also useful for shops using Oracle8 or Oracle 7.

Objectives
The Oracle's database and its associated tools are presented in an overview fashion, providing a good overall picture of how the system works.  Application planning issues, highlights, and pitfalls are presented and discussed interactively with attendees.

Prerequisites
No prior knowledge of Oracle, its tools, or SQL are required.

Topics

• Relational database concepts

• Objects and other new features

• Oracle product overview

• Comparison of Oracle tools to other tools

• Introduction to SQL

• Overview of basic SQL queries

• Review of Oracle object creation and physical storage

• Overview of SQL data manipulation and management commands

• Introduction to Pro*C or Pro*COBOL interface

• Developer Forms demonstration

• Developer Reports demonstration

• Oracle and Java demonstration

• Future directions for Oracle