Format

Classroom

Duration

5.0 Day(s)

Description

This course presents a methodology for modeling and designing relational databases.

Audience

People responsible for designing relational databases and people who need an in-depth understanding of data modeling.

Prerequisites

The course does not require any special prerequisites.

Objectives

After completing this course, you should be able to:
- Design relational databases.
- Consider logical and physical aspects including integrity
requirements during the design.

Contents

This course covers the following major topics:
- Relational concepts
- Views and results during database design
- Problem statement
- Entity-relationship modeling
- Data and process inventories
- Tuple types
- From tuple types to tables
- Integrity rules
- Indexes
- Logical data structures and views