Oracle Overview

Audience

The course has been designed for management, business analysts, system architects and others who need a high level overview of how an Oracle 10G or 11G based Client/Server system is constructed.

Prerequisites

IT professionals who have some familiarity with the base operating system on which the database is mounted (e.g. UNIX, Linux, Windows). No previous experience with Oracle is expected or required.

Duration

2 days. Hands on.

Course Objectives

On completion of the course delegates will be able to:

• Describe the principal features of an Oracle 11G based system.
• Describe the principal building blocks of an Oracle 11G system.
• Comfortably use the terminology associated with an Oracle 11G based system.
• Understand the main issues associated with constructing a Client/Server system based on an Oracle 11G RDBMS.

Course Content

Review of RDBMS Principles
Oracle 11GArchitecture
Oracle SQL
Oracle SQL*Plus
Oracle PL/SQL
Oracle Developer - Forms and Reports
Oracle Designer
Oracle Discoverer
3rd Party Reporting Tools
3rd Party Development Tools