Data Modelling and Relational Database Design

Aims and Objectives
Read, improve, create, use and judge Entity Relationship Models.
Capture business rules and constraints.
Recognise and use patterns in models.
Transfer ER models into an initial relational database design.
Apply various techniques to optimise the design in an Oracle environment for performance and maintainability.

Target Audiences
This course is for database administrators wanting to further their knowledge of relational database design.

Prerequisites
Delegates should have a basic understanding of relational database concepts as covered in introductory Oracle courses.

Course Content
Module 1: ENTITY RELATIONSHIP MODELLING
Module 2: RELATIONAL DATABASE DESIGN