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.
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
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.
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
What engineers say
“"I had no knowledge at the start of the course and the instructions were excellent."
“"Very good"
Dates & prices
View full schedule →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.
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.