ORACLE Database Systems, SQL

Garant předmětu:

Lecturer:

Tutor:

Supervisor:

Department of Applied Informatics in Transportation

Synopsis:

The topic of the course is to familiarize students of SQL query language. Students create own application in the end of the term.

Requirements:

Basic computing knowledge

Syllabus of lectures:

Syllabus of tutorials:

Study Objective:

Knowledge of: DML, DDL, DCL and TCC commands of SQL, common SQL functions, creating procedures, functions and triggers (PL/SQL).

Study materials:

Halaška, Pokorný: Jazyk SQL a systém Oracle, Praha, skripta ČVUT, 1995 , Šimůnek: SQL kompletní kapesní průvodce, GRADA , Lacko L.: Oracle: správa, programování a použití databázového systému, Computer Press

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans: