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 Lynda.com).
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)

Schedule
Booking normally opens 30 days before the course begins.
Commences Dates Time Sessions Cost Location Status
10th week Monday 27 June 09:15-12:15 1 5.00 IT Services, 13 Banbury Road places available Add to basket

Can't make any of these dates? Express an interest in future dates for this course.

Frequency: Every term.