Databases Design and Programming

Garant předmětu:

Lecturer:

Tutor:

Supervisor:

Department of Applied Informatics in Transportation

Synopsis:

Database design, data types, constraints, SQL statements for data definition, data manipulation, transaction management, connection management and system administration, single-row, aggregation and SQL analytic functions. PL / SQL - variables, loops, conditions, procedures, functions, triggers, packages, cursors, exceptions.

Requirements:

basic knowledge to work with PC

Syllabus of lectures:

Syllabus of tutorials:

Study Objective:

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

Study materials:

Jeřábek, M. - Kaliková, J. - Kalika, M. - Krčál, J. - Krčálová, L.: Databázové systémy pro dopravní aplikace. Praha: České vysoké učení technické v Praze, 2010.

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans: