Oracle Training : Oracle Designer Data Modeling

Oracle Designer Data Modeling

Oracle Training Overview

This course considers all the features of building complex logical data models using sophisticated modeling techniques. Numerous �real-world� problems and special situations are presented along with solutions. Classic structures and common models are also given to assist participants in rapidly completing a data model. Traditional modeling techniques as well as newer object-oriented modeling principles are presented providing state-of-the-art modeling skills to attendees. This course may be presented using the modeling syntax of Oracle Designer or independent of any specific modeling tool. This course is alternately named "Relational Database Design."

Oracle Training Prerequisites

None.

Oracle Training Audience

All database professionals including developers, database administrators and designers. Non-technical professionals such as business analysts and others concerned with logical database design will also benefit.

Suggested Next Courses

The course Introduction To Oracle9i SQL
The course Introduction To Oracle9i PL/SQL Language
The course Oracle9iDS Designer Systems Analysis & Modeling

Oracle Training Objectives

Build a series of logical data models
Transform a logical model into a physical model
Use the concepts of supertype and subtypes to solve modeling problems
Learn the mistakes common to many data models

Oracle Training Course duration

3 Days

Oracle Training Course outline

Data Modelling Principles

What Is Data Modeling?
Related Methodologies
What You Can Do With A Data Model
What Can Go Wrong Without A Data Model
ERwin Model Notation
SDesignor Model Notation
Oracle Designer Model Notation
Logical Database Design

Building A Data Model

Building A Very Simple Model
How To Start A Data Model
Identifying Entities
Identifying Attributes
Identifying Relationships
Certify the Model With Normalization
Oracle Designer Notation

Transform Model To Logical Database

Semantic & Object Oriented Concepts

Semantic Data Modeling
OO Concepts
Domains
Flaws That Probably Exist In Your Entities!
Flaws That May Exist In Your Attributes
SuperTypes & SubTypes
Generalization and Specialization
Sample Specialization
Subtype Constraints
Arc
Lattice
Some Scary Stories!

What Is A Relational Database?

Relational Database Terms
Views
Indexes
Constraints
Sequences
Triggers
A Logical Database Design
Distributed Database & Data Partitioning

Classic Structures & Patterns

Master-Detail (Generic)
Master-Detail (Invoice specific)
Bill-of-Materials (data model)
Bill-of-Materials (relational schema)
Organization Unit Hierarchy

Sample Models

The Connection Trap (Solution)
A Credit Card Company (Moderate)
Refine Air Travel Model (Moderate)