PTR - People, Training ResultsPeople, Training, Results

Independent Technical IT Computer Training Courses

   
Scheduled Classroom based Training Courses

Relational Database Design Course

Download PDF course outline

Course Description

This course provides an introduction to relational database concepts and terminology. Through a variety of exercises, you will learn how to model a business enterprise using the entity-relationship approach to relational database design. You will learn data normalisation techniques and how to propose, evaluate, and choose between design alternatives. In addition, you will have hands-on experience creating a database and table using the Data Definition Language of SQL.
£645

2 day course

Scheduled Dates:
12 January 2012
23 February 2012
12 April 2012
17 May 2012
28 June 2012

Location:
PTR's Training Centre
Wokingham, Berkshire.

Course pre-requisites:

None



Topics covered on the 2 day Relational Database Design course

Main steps to design a database


Entity-Relationship concepts and terminology


Entity-Relationship diagrams


Attribute specifications


Informix data types


Normalization


SQL statements for creating a database


Data integrity


Using DB-Access to create the database schema


Inserting and selecting data


Course Classification:  Technical Training Course

This is an instructor led training course taught in a classroom based environment.


Course Fee = £645   (excl.VAT)



Scheduled course dates

12 January 2012 to 13 January 2012

23 February 2012 to 24 February 2012

12 April 2012 to 13 April 2012

17 May 2012 to 18 May 2012

28 June 2012 to 29 June 2012



View full schedule of Relational Databases courses

Print / Download PDF Version of full course schedule

If you would prefer to run this course at your premises as you have several employees to place on the course perhaps, then we are also able to offer onsite Database Training and bespoke Database courses