Course Details and Schedule

This module 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.

See below for course schedule

Key topics
  • Relational database terminology
  • The problems with storing a database in Excel
  • Creating a data model to represent your database
  • Organizing your data into tables - normalization
  • Creating relationships
  • Testing your data model
  • Implementing your database design
Course information
Intended audience Anyone who is about to design a database and is not sure how to go about it
Prior knowledge No prior knowledge required
Resources A course book must be purchased when you attend the course (see the Cost below)
Software No specific software used
Format Presentation with practical exercises
Further information We will also be using a text book which will be loaned to you during the class.
Where next? Access: Fundamentals of using a database, Access: Database structure

Course provider: IT Learning Programme

Schedule

Frequency: 9 notesonly