Oracle Overview (O001) Training Course
Training Course Objectives
This course is designed to introduce the extensive range of products and services offered by the Oracle Corporation.
The course covers the core product offerings including:
- Oracle Forms
- Oracle Reports
- Oracle Discoverer
- Oracle JDeveloper
- Oracle Application Server
- Oracle Portal
The course is designed for anyone who needs an effective working knowledge of the Oracle product range and of the corporate service culture of the company.
Who Should Attend
- Managers
- Analyst/Designers
- Purchasers
- Technicians
Training Course Prerequisites
- Working knowledge of PC technology
- View Learning Path
Training Course Duration
1 Day
Training Course Contents
Relational Design
- Introduction to Relational Design
- Systems Analysis
- Conventions and Definitions
- Entities
- Relationships
Oracle, SQL, and PL/SQL
- Basic Oracle Architecture
- Logical Structure
- Physical Structures
- Memory Structures
- Administration Terminology
- Logging on to SQL*Plus
- Choosing and Describing Tables
- Elements of the SQL Query
- Data Definition Language
- Data Dictionary
- Data Manipulation Language
- Variables in SQL
- Data Control Language
- Introduction to PL/SQL
Oracle Forms
- Introduction to Forms
- Oracle Forms Objects
- The Design Tools & Wizards
Oracle Reports
- Oracle Reports Objects
- Report Level Objects
- Page Concepts
- Data Model Objects
- Layout Objects
- Parameter Form Objects
- Developing Reports
Oracle Discoverer
- Overview and introduction
- The End User Edition
- The Admin Edition
Oracle JDeveloper
- Introduction
- Java structures and templates
- J2EE design
Oracle Web Technology
- Oracle Application Server Architecture
- Internet File System
- Oracle Portal
Database Administration
- Server Manager
- Administration Terminology
- Starting up a database
- The INIT.ORA file
- Shutting down a database
- Introduction to Utilities
- Export & Import
Enterprise Manager
- Overview
Next Available Dates
iTrain delivers this course as company specific training. Please contact us for more information or course dates.
