Oracle Designer Data Modeling with CD Study Guide

0-619-28882-5 © 2004 Publish date: June 18, 2004 198 pages

Buy Now: $119.99

Course ID: oracle-design-dmodel-cd-sg

CBT Planet stocks a large list of Oracle computer training books including the Oracle Designer Data Modeling study guide which looks at how to build complex, logical data models using sophisticated modeling techniques.

The Oracle Designer Data Modeling courseware is designed with your needs in mind including your need for self-directed study as well as your need for real-world scenarios. You can take a look at actual special situations, try to figure them out on your own, and then compare your ideas with actual solutions.

In addition, you will examine classic structures and common models in order to learn how to rapidly complete a data model. You'll also take a look at traditional modeling techniques and newer object-oriented modeling principles so that you get complete and state-of-the-art modeling skills.

Choosing the Oracle Designer Data Modeling courseware is an excellent decision for self-paced, self-directed learning. You'll be able to learn these concepts, principles, and techniques according to your own time schedule and learning ability. Our study guides provide comprehensive coverage of complex topics using clear and concise writing. We include hands-on activities and section reviews to reinforce the subjects.

This course is terrific on its own or as a supplement to existing Oracle classes. No matter how you use it, you'll want to hand on to the manual afterwards as a useful reference book.

Course Contents

Data Modeling Principles

• Data Modeling overview
• Related Methodologies
• What Data Models can do
• Typical problems without Data Models
• Working with ERwin Model Notation
• Working with SDesignor Model Notation
• Working with Oracle Designer Model Notation
• Logical Database Design

Creating a data model

• Creating a very simple model
• Starting a data model
• Entities
• Attributes
• Relationships
• Certifying the model using normalization
• Oracle designer notation

Transform model to logical database

• Semantic and object-oriented concepts
• Semantic data modeling
• Object-oriented concepts
• Domains
• Typical entity flaws
• Typical attribute flaws
• Supertypes and subtypes
• Generalization and specialization
• Samples of specialization
• Subtype constraints
• Arc
• Lattice
• Scary stories and examples

Relational databases

• Relational database terminology
• Views
• Indexes
• Constraints
• Sequences
• Triggers

Logical database designs

• Distributed database and data partitioning

Classic structures and patterns

• Master-detail: generic
• Master-detail: invoice specific
• Bill-of-materials: data model
• Bill-of-materials: relational schema
• Hierarchy of organization units

Sample models

• Connection trap
• Credit card company
• Refine air travel model