Relational Database Design

Objective

This course provides detailed information about the basic relational database concepts.

Audience

Application developers and database administrators

Prerequisites

A fundamental knowledge of data processing

Content

Database Basics

• Database Requirements
• Database Types
• Disadvantages and Limitations of Relational Databases
• Terminologies
• Entity Relationship Model
• Design Process

Conceptual Modeling (ERM)

• Notation
• Association Cardinalities
• Combinations of Cardinalitites

Logic Modeling

• Identification vs. Primary vs. Foreign Key
• Associations
• Presentation of a Relational Model
• Anomalies
• Normalization
• Conversion of an ER Model (practical example)

Introduction to SQL

• Data Definition (DDL)
• Data Manipulation (DML)
• Data Query (DQL)
• Additional Terms (Index, View, Trigger, etc.)

Course Information

Course No:5215E
Duration: 2 days
Price: € 1.100,00