Verhoef Training Europe.

11B Kingsmead Square, Bath, BA1 2AB, UK
Phone:+44 (0)1753 852 233 Fax: +44 (0)1753 840 190



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