Course




IT



Database design and SQL

Course description



Title

Database design and SQL

Goal

To give the participants a competence to design efficient databases. The participants will have an introduction to SQL and learn to write simple SQL programs.

Targetgroup:

Persons implementing databases and have to use SQL.

Required background:

The participants must have some programming experience.

Duration:

1-5 days á 5-6 hours, as needed. See timeplan

Number of participants:

Maximum 10 persons per class.

Course form:

One person per computer. There is a mix of classroom teaching and individual solution of exercises.
1-2 lessons and rehearsals per day.

Course description:

The customer may select a set of modules from the Time plan.

Exercises:

Design and architecture of databases. SQL insertion of data and queries

Preparation:

We suggest, that before the course take place, there is meeting to discuss the detailed content, so that the course will get the maximum relevance for the participants.
We will normally use the database MySQL and the web server APACHE with PHP. Other databases supplied by the customer may be used. Choose further between Teradata, Oracle, Access, MySQL, PostgresSQL, SAS. Other databasesystems on request..
For datawarehouse we propose Microstrategy.

Course language:

Danish or  english

Necessary equipment:

PC and projector(XGA) for Powerpoint presentations. Blackboard or whiteboard. Overhead projector. Some limited photocopying may be needed.
Server with database and PC's for the participants.

Price:

See Pricelist
Course material 175 € per participant.

All prices are without VAT.

Telit IT ApS

Troels-Lunds Vej 32, DK-2000 Frederiksberg, Telephone + 45 28 14 55 64