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

Databases Design and Programming

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
14NDB KZ 2 0P+2C Czech
Lecturer:
Michal Jeřábek
Tutor:
Michal Jeřábek
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:
Time-table for winter semester 2019/2020:
Time-table is not available yet
Time-table for summer semester 2019/2020:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2019-12-06
For updated information see http://bilakniha.cvut.cz/en/predmet3995206.html