Databases Design and Programming
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 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)