Oracle Designer Data Modeling
Unfiled
Training
Provided by Webucator
This Oracle training 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. The course is intended for 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. This course is delivered as a lecture and is not hands-on.
|
|
||||||||||||||||
Oracle Designer Data Modeling
Course Outline
- Data Modeling 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)
About The Training Provider: Webucator
Webucator - Webucator delivers customized onsite technical training throughout the United States and worldwide.
