Audience
This is an essential course for all would be Oracle analysts, designers, and programmers.
Prerequisites
Delegates should have a basic understanding of system development fundamentals.
Duration
3 days.
This course is available on site only. Please call for details.
Course Objectives
This course will provide delegates 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.
Course Content
Introduction
Introduction to Relational Data Modeling
The Business Systems Lifecycle
Systems Analysis
CATWOE
Conventions and Definitions
Entities and 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