Booking options
£2,367
£2,367
Delivered Online or In-Person
You travel to organiser or they travel to you
Redhill
3 days
All levels
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
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.