Databases Design and Programming

Lecturer:

Michal Jeřábek

Tutor:

Michal Jeřábek

Supervisor:

Department Děčín

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:

Time-table for winter semester 2021/2022:

Time-table is not available yet

Time-table for summer semester 2021/2022:

Time-table is not available yet

The course is a part of the following study plans:

• KOMBI navaz. mag. studium v 15-16 obor LA (compulsory course)
• KOMBI navaz. mag. studium v 16-17 obor LA (compulsory course)
• KOMBI navaz. mag. studium v 16-17 obor LA (skok z 1.r. do 2.r.) (compulsory course)
• KOMBI navaz. mag. studium v 17-18 obor LA (compulsory course)
• KOMBI navaz. mag. studium v 18-19 obor LA (compulsory course)
• KOMBI navaz. mag. studium v 18-19 obor LA (skok z 1.r. do 2.r.) (compulsory course)
• KOMBI navaz. mag. studium v 19-20 obor LA (compulsory course)