Book now

Database Design and Data normalisation, 2-Day Course

Course summary

Relational Databases & Data Normalisation Overview Training Course, 2-Day Course

Important: If booking within 7 days of the date of the course, we will confirm availability within 24hours

Course Content – Day 1

Session 1: Introduction to Relational Databases

The Database Approach
Database Management Systems
The function of a Database Management System
The Processing Architecture
The Schema Architecture
The Storage Architecture
An overview of Database System Development
An overview of general database principles

Session 2: Conceptual Data Models

Overview of Entity Models
Entities and how to identify them
Attributes and how to identify them
Relationships and their qualities
Building an Entity Relationship Diagram
Resolving many-to-many relationships
Sub-type and Super-type Relationships
Arc Relationships
Recursive Relationships
Constraints and Assumptions
Normalization to the First Normal Form (1NF)
Normalization to the Second Normal Form (2NF)
Normalization to the Third Normal Form (3NF)
Exercises: Analyzing a specification
Creating an Entity Relationship Diagram from it

Course Content – Day 2

Session 2: Conceptual Data Models(continued)

Normalization to the First Normal Form (1NF)
Normalization to the Second Normal Form (2NF)
Normalization to the Third Normal Form (3NF)
Exercises: Data Normalization producing table specifications and Entity Diagrams

Session 3: The Relational Model

Relational Structure
Relational Terminology
Domains
A Relational schema
Candidate keys and Primary Keys
Foreign Keys
Key Constraints
Attribute Constraints
Implementing Sub-type/Super-type Relationships
Views
Denormalization using Pre-joined Tables
Denormalization using Derived Data
An Introduction to Structured Query Language (SQL)
Simple Queries
Simple Updates of the Data

Book this course

Choose from the start dates and other options below. Click on each row to get more information. When you have found your ideal combination click "Book now" to proceed.

Buy a voucher
Starting How long Where Price

Thu 27th Apr
11:00am - 6:00pm

2 days
Full time
London,
WC2N 5BY
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 27th Apr
11:00am - 6:00pm

2 days
Full time
Milton Keynes,
MK9 2UB
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 27th Apr
11:00am - 6:00pm

2 Days
Full time
Portsmouth,
PO6 3EZ
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 04th May
11:00am - 6:00pm

2 days
Full time
London,
WC2N 5BY
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 04th May
11:00am - 6:00pm

2 days
Full time
Milton Keynes,
MK9 2UB
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 04th May
11:00am - 6:00pm

2 Days
Full time
Portsmouth,
PO6 3EZ
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 11th May
11:00am - 6:00pm

2 days
Full time
London,
WC2N 5BY
Map

£750.00 10% off
£675
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 11th May
11:00am - 6:00pm

2 days
Full time
Milton Keynes,
MK9 2UB
Map

£750.00 10% off
£675
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 11th May
11:00am - 6:00pm

2 Days
Full time
Portsmouth,
PO6 3EZ
Map

£750.00 10% off
£675
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Thu 18th May
11:00am - 6:00pm

2 days
Full time
London,
WC2N 5BY
Map

£750.00 10% off
£675
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher