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 learn the principles of good design for a database. You will consider why fields should be organised into separate tables, and how they can be related. You will look at different kinds of relationships (joins) and when to use them. 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.
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

Schedule
Booking normally opens 30 days before the course begins.
Commences Dates Time Sessions Cost Location Status
1st week Tuesday 14 October 09:15-12:15 1 5.00 IT Services, 13 Banbury Road waiting list Add to basket
1st week Wednesday 15 October 09:15-12:15 1 5.00 IT Services, 13 Banbury Road waiting list Add to basket

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

Frequency: Every term.