Relational Databases & Data Modelling Overview

Course Code : ORD


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.

Desktop Applications Professional Development Project Management Technical IT new! - Datrix Training Books