+44 (0)1737 821590
Database design  |    A 3 day   hands on   training course

Database design training course description

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 will you 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.
Database design training course details
  • 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.

  • Duration
  • 3 days

  • Dates & prices
  • Click here

Database design training course contents

  • 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.

Learning path

Reviews

5.0

Based on customer reviews

C. W. - BBC NI

"I had no knowledge at the start of the course and the instructions were excellent."


F. D. - BBC NI

"Very good"

Training approach

This structured course uses Instructor Led Training to provide the best possible learning experience. Small class sizes ensure students benefit from our engaging and interactive style of teaching with delegates encouraged to ask questions throughout the course. Quizzes follow each major section allowing checking of learning. Hands on sessions are used throughout to allow delegates to consolidate their new skills.