Databases Design and Programming

Course Code:
14NDB
Academic Degree:
master
Study Programme:
Technology in Transportation and Telecommunications (N 3710)
semesterlanguagestudy field / specialization
3czechLA Logistics and Transport Processes Control - 3708T046
Form of Study:
full-time and part-time
Credits:
2
Number of Hours:
0 + 2 hours per week - in full-time study
8 hours per semester - in part-time study
Type of Course:
obligatory
Course Completion:
classified credit
Course Tutor:
 
roh  Training Course:
Ing. Mgr. Michal Jeřábek, Ph.D.
roh  Part-time Study:
Ing. Mgr. Michal Jeřábek, Ph.D.
Supervising Department:
Department of Applied Informatics in Transportation (16114)
Keywords:
database, database design, SQL, PL / SQL
Abstract:
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.
Objectives:
Obtain skills for database design, introduction to SQL and PL / SQL.