Data Modelling for Oracle

Audience

This is an essential course for all would be Oracle analysts, designers, and programmers.

Prerequisites

The participant should have a basic understanding of System Development Fundamentals.

Duration

3 days.

Course Objectives

This course will provide the student with an in-depth insight into the methods and applications of the Relational model. The course contents takes the student from a high-level strategy process through the Waterfall Methodology to physical Oracle implementation. This essential learning will give the student a vital knowledge platform that is fundamental to the usage of Oracle Technology.

Course Content

INTRODUCTION
Introduction to Relational Data Modeling
The Business Systems Lifecycle
Systems Analysis

CATWOE
Conventions and Definitions
Entities: Relationships

ENTITIES
Introduction
Building Entities
Using Entities
Amending Entities
Attributes
Effective Attribute development and implementation

ENGINEERING
Introduction
Reverse Engineering
Entities
Relationships

PHYSICAL TRANSACTION
Introduction: The Real System-Logical to Physical
Conversion
Implementing Sub-Types
Conversion
Oracle Client/Server Models
Oracle Functionality
The complete Oracle Model
Final thoughts on model development and implication