Course Details and Schedule

This course takes you through the steps required to create a good relational database design, from concept to implementation. A relational database is one where data is organised into tables by subject, related by common fields. Before even starting to build, it is essential to work out a design which properly models your project. You will learn to analyse scenarios, choosing suitable fields where data can be stored. You will consider why fields should be organised into separate tables, and how they can be related. The course includes plenty of worked examples and practice activities. The course does not use any particular software, so it will help you create a well-designed database structure which you can build later using the database software of your choice.

See below for course schedule

Key topics
  • What is a database?
  • What is a relational database?
  • How to design a database
  • How do joins work?
  • A workflow for database design
Course information
Intended audience Those who need to create a new database, designing the structure for a data collection and analysis project. Also those who need to work on an existing database, revising the structure for changing requirements.
Prior knowledge No previous experience of database design or building is required. No software knowledge is required. Watch these videos to prepare for this course (requires an Oxford University account with
Resources Notes and resources will be available online
Software Suitable for building a database using a range of software
Format Presentation, practical exercises and some group work
Where next? Databases: Building a database using Access
Taught using:
Windows 7

Course provider: IT Learning Programme

What you will need:

No computer is needed. You can bring your own device for note taking (read our guidance first)


Frequency: Every term. Express an interest in future dates for this course.