SQL
The course is not on the list Without time-table
| Code | Completion | Credits | Range | Language |
|---|---|---|---|---|
| XE36SQL | Z,ZK | 4 | 2+2s |
- The course is a substitute for:
- The language SQL (E36SQL)
- Lecturer:
- Jaroslav Pokorný (gar.)
- Tutor:
- Jaroslav Pokorný (gar.)
- Supervisor:
- Department of Computer Science and Engineering
- Synopsis:
-
The course presumed the basic knowledges about relational database systems as they are presented in the bachelor course XE36DBS. The course starts with the discussion of individual parts of SQL language according to SQL92 standard (DML, DDL, DCL, TCL). The lectures follow with discussion of advanced SQL features which are also included in SQL99 standard (recursion, modules, etc). But the course is aimed to practical application of SQL, hence the students work with Oracle 10g during their seminars. The lectures of advanced SQL are therefore based on Oracle's SQL and PL/SQL rather then SQL99.
- Requirements:
- Syllabus of lectures:
- Syllabus of tutorials:
- Study Objective:
- Study materials:
- Note:
- Further information:
- No time-table has been prepared for this course
- The course is a part of the following study plans:
-
- Computer Science and Engineering (compulsory course)