Name: Data Modeling and Relational Database Design
Course Code: OR20000
Duration: 4
Scheduled Dates for OR20000
This course covers the use of Entity Relationship Modeling in detail, through many real life examples, practical business problems and solutions. After several iterations, the ER model captures the data requirements and business rules and forms a sound basis for the initial design of a relational database. The second part of the course is about the design process and presents the considerations for creating a normalized, stable, maint ainable and well defined relational database, such as Oracle9i.
Target Audience
Business Analysts, Database Designers, Database Administrators
Key Topics
- Entity Relationship Modeling
- - Why create conceptual models?
- - Distinguishing Data and Information
- - Tracking Entities in various source materials
- - Modeling Subtypes and Supertypes
- - Creating appropriate Names for Entities, Attributes and Relationships
- - Representing a Model in Diagrams
- - Identifying Things in the Real World
- - Establishing Unique Identifiers (UID)
- Relational Database Design
- - Why create a Database Design?
- - Creating well structured Names for Database Objects
- - Establishing the Basic Mapping of an ER Model to Table Model
- - Mapping Entities and Attributes
- - Various ways of Denormalizing your Table Design
- - Selecting the appropriate Oracle Data Type
- - Recognizing Design Fossils like Generic Arcs
- - Design for a Distributed Environment
Objectives
- Recognize and use patterns in models
- Apply various techniques to optimize the design in an Oracle environment for performance and maintainability
- Transfer ER models into an initial relational database design
- Read, improve, create, use and judge Entity Relationship Models
- Capture business rules and constraints
Required Skills/Experience
- Basic understanding of relational database concepts
Note
TBT is available, please contact your sales representative for purchase
Fee: $2,400.00
Course Schedule:
Back to Course Description
Austin
Charlotte
Columbia
Hunt Valley
Lansing
Madison
Milwaukee
Minneapolis
Oak Brook
Oklahoma City
Phoenix
Raleigh
San Antonio
Schaumburg
Tulsa
Washington DC
