Back to Search Results

Training Course Summary:

Pre-Requisites:

An understanding of Information Technology concepts and computer terms.

Who Should Attend:

Delegates who require an understanding of relational databases.

Training Course Overview/Content:

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

Follow-On Courses:

SQL*Plus