Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2020/2021

Databases Design and Programming

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
614NDB KZ 2 0P+2C+8B Czech
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 2020/2021:
Time-table is not available yet
Time-table for summer semester 2020/2021:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2020-11-29
For updated information see http://bilakniha.cvut.cz/en/predmet4275806.html