Database Systems 1

Lecturer:

Vladimír Hora (gar.)

Tutor:

Vladimír Hora (gar.)

Supervisor:

Computing Centre

Synopsis:

Relation database management systems, main principles and applications. SQL language. Multilayer architecture, client/server applications. Data models. User and programming interface to RDMS.

Requirements:

no prerequisities

Syllabus of lectures:

Syllabus of tutorials:

Study Objective:

To recognize principles and potency of RDMS, to practise creating and manipulation of databases.

Study materials:

[1] firemní manuály Oracle, DB2, PostgreSQL

Momjian, Bruce: PostgreSQL: introduction and concepts

http://www.postgresql.org

Gilfillan Ian: Myslíme v MySQL 4

Note:

Time-table for winter semester 2011/2012:

	06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon	roomTH:B-377 Hora V. 15:00–15:50 (lecture parallel1) Thákurova 7 (FSv-budova A) B377
Tue
Fri
Thu
Fri

Time-table for summer semester 2011/2012:

	06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon	roomTH:B-377 Hora V. 15:00–15:50 (lecture parallel1) Thákurova 7 (FSv-budova A) B377roomTH:B-377 Hora V. 16:00–16:50 (lecture parallel1 parallel nr.101) Thákurova 7 (FSv-budova A) B377
Tue
Fri
Thu
Fri

The course is a part of the following study plans: