Delegates:
Delegates who require an understanding of relational
databases.
Objectives:
On completion of this course, delegates will have an understanding
of the structure of a Relational Database Management System and
have sufficient knowledge to converse with RDBMS
professionals.
Topics Covered:
Introduction to Databases
Database Management Systems
Database System Development
Conceptual Data Models
Entities
Attributes
Relationships
Constraints
Assumptions
Identifying Entities, Attributes, Relationships
Sub-type/Super-type relationships
Arc, Non-transferable and Redundant Relationships
Recursive Relationships
Normalisation
The Relational Model
Structure
Relational Terminology
A Relational Schema
Implementing Constraints
Implementing Sub-type/Super-type Relationships
Views
Denormalisation
Requirements:
An understanding of Information Technology concepts and computer
terms.