Verhoef Training

11 Kingsmead Square, Bath, BA1 2AB.
Tel: 01225 339705 Fax: 01225 339671




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  

© 2007 Verhoef Training, Ltd.