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.
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