Relational Databases & Data Modelling Overview
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
2 Days
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.
Facilities
Location
Start date
Start date
Reviews
Course programme
- 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
Relational Databases & Data Modelling Overview