Home / Courses / Software Development & Programming / Relational Database Design

Relational Database Design

Name: Relational Database Design
Availability: InStock
Rating: 4.6 (5878 reviews)

Together with your trainer you will work out the basics, implementations and applications of relational database techniques and DWH structures

4.6 out of 5 rating
Last updated : 23/07/2026
English

Available as Instructor Led Training, Live Online & In Person at your Offices or Ours.

Enquire Now

Download Overview

Duration:

16.00 hours

13.0 CPD hours

Overview:

Together with your trainer you will work out the basics, implementations and applications of relational database techniques and DWH structures

Description:

Motivation

Basic terms and DB concepts

Data dictionary and meta databases

Data integrity

- Data consistency
- Data protection
- Data security
- Transactions
Overview: models

- Hierarchical model
- Network model
- Relational model
- Object-oriented models
Normalize

- From the 1st to the 3rd normal form
- BCNF, 4th, 5th normal form
Overview: Design Methods

- Objectives, principles of design methods
- Method according to Zehnder
- ERD from Chen
The Entity Relationship Diagram (ERD)

- Formation of entity sets and relationships between entity sets
- Normalizing an ERD and mapping the ERD to data structures
- Identification keys, foreign keys, global and local attributes
Definition of consistency conditions

- Inherent, external consistency conditions
- Classes of consistency conditions
Reproduction of transactions

Outlook, trend of DBMS and trends

- Distributed database structures
- Graph databases (NoSQL)
- Document databases (NoSQL)
- Typical cloud data structures

Available Delivery Options for Relational Database Design

Live Instructor Led Classroom Online (Live Online)
Traditional Instructor Led Classroom training (TILT/ILT)
Delivery at your offices in United Kingdom
Private dedicated course for your staff

How many CPD hours does Relational Database Design provide?

The 2 day Relational Database Design course gives you up to 13.0 CPD hours/structured learning hours.

Who is the correct audience for Relational Database Design?

DB users who want to get into database creation. Users who want to optimize their queries. People who want to understand and evaluate databases.

Do you provide training for Relational Database Design?

Yes, we provide corporate training, dedicated training and closed classes for Relational Database Design. This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of Relational Database Design?

The Relational Database Design training takes place over 2 day(s), with each day lasting approximately 16.00 hours including breaks.

What other terms do people search for?

Popular related searches include: Relational Database Design, SQL, SQL03

Why are Nexus Human the best provider for Relational Database Design?

Nexus Human are recognised as one of the best training companies. Our trainers have won awards including Small Firms Best Trainer, national training partner of the year for Ireland, and global top 30 instructor awards in 2012, 2019 and 2021.

Is there a discount code for Relational Database Design?

Yes, the discount code PENPAL5 is currently available for Relational Database Design training. Only one discount code can be used per booking.

DURATION 16.00 Hours

No scheduled classes available at this time.

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable.

To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.