+44 (0)1737 821590
Relational Database Design

Database design

A hands-on course covering relational database design, SQL fundamentals, relationships, joins and normalisation. Delegates learn to turn flat data into efficient relational structures and design databases relevant to their own work.

Relational Design SQL Queries Normal Forms Table Relationships
PDF outline:Download
Hands-on labs
Vendor independent
Small class sizes
Practical Outcomes

Course overview

Although this course mentions Microsoft Access the same course can be run with a variety of different databases. The duration of the course is dependent on the experience of the delegates.

What you will learn

  • Name and give 3 types of database structure.
  • Explain the difference between standard SQL and different flavours.
  • Use SQL statements to query databases.
  • Use SQL statements to query and define databases.
  • Describe the principles of relational database design and 3 types of relational joins.
  • Normalise a given flat file table into relational tables.

Who will benefit

  • Anyone who needs to be able to design an efficient, watertight database following the best practice of the principles of Relational Database design.

Prerequisites

  • None

Hands-on labs

1
Lab sessions
3
Days hands-on

This is a practical, lab-based course with hands-on exercises integrated throughout the programme. Rather than simply demonstrating concepts, delegates work through practical examples of relational database design, use SQL to query and define databases, normalise flat-file data into relational tables, create a database hands-on, and design on paper a relational database applicable to their own work.

Engineers working in a network lab
creation of a database

Course content

Database structure and terminology.

Principles of Relational Database Design.

Types of relationship.

Normal Forms.

Practical examples of relational database design.

Hands-on creation of a database.

On paper design a relational database applicable to the delegates work.

Where this course fits

← Step back
›
● You are here
Database design
Current course
›

What engineers say

5.0 / 5
Based on customer ratings
“

"I had no knowledge at the start of the course and the instructions were excellent."

CW
C. W. - BBC NI
“

"Very good"

FD
F. D. - BBC NI

Dates & prices

View full schedule →
Upcoming scheduled dates
11–13 January 2027
12–14 April 2027
12–14 July 2027
Delivery options & pricing + VAT
Live virtual £2,557
In person £2,697
Duration: 3 days
Reserve a place

Private & bespoke delivery for your team

We run this course exclusively for your organisation — at your site, our venue, or online. Flexible dates, tailored content, and pricing based on group size.

Request a quote

Not sure if this course is right?

Talk to one of our engineers about your environment, experience level, and goals. We’ll confirm whether this course is the right fit or suggest a better alternative.