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.