Databases Design and Programming

Course guarantor:

Lecturer:

Tutor:

Supervisor:

Department of Applied Informatics in Transportation

Synopsis:

Students in this course will deepen their knowledge and skills in database design and learn the procedural extension of SQL, PL/SQL, which makes it possible to ensure data integrity on the level of the database engine.

Requirements:

basic knowledge of database terminology, relation database systems, principle of database design, basic knowledge of language SQL - language elements DML

Syllabus of lectures:

Syllabus of tutorials:

Study Objective:

Obtain skills for database design, SQL increasing knowledge and introduction to PL / SQL.

Study materials:

HERNANDEZ Michael J.: Návrh databází. Praha, Grada Publishing, 2006

GROFF James R., WINBERG Paul N.: SQL. Kompletní průvodce. Brno, Computer Press, 2005

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans: