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

SQL Applications

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
18SQL Z 2 0+2 Czech
Lecturer:
Jaromír Kukal
Tutor:
Jaromír Kukal
Supervisor:
Department of Software Engineering
Synopsis:

Practical realization of database system according to general principles of database analysis.

Requirements:

Passing of 18DATS

Syllabus of lectures:
Syllabus of tutorials:

1 Databse platforms, interface, script, DDL, DML.

2 Creation of table and index in DDL.

3 Update, projection and restriction in DML.

4 Sorting, aggregation and second restriction in DML.

5 NULL value in table, expression and restriction.

6 Set of values and nested querry.

7 View as virtual table and its creation in DDL.

8 Realization of integrity constrains in DDL.

9 Joining of data sources and hierarchical views.

10 Querry optimization and fast set operations.

11 Creation of procedures in DDL, branching and loop.

12 Table returning procedure and exceptions.

13 Events in database system and triggers.

14 Layer of views and procedures between data and client.

Study Objective:

Knowledge:

Exercise DDL SQL, DML SQL and PL/SQL on various examples. General rules of DB system realization and independency on platform of DB server are the main aims.

Abilities:

Orientation in given subject and ability to solve real tasks in SQL and PL/SQL.

Study materials:

Key references:

Groff J.R., Weinberg P.N.: SQL - The Complete Reference, Mc Graw Hill, 2002.

Recommended references:

Kriegel A., Trukhonov B.M.: SQL Bible, John Wiley and Sons, 2008.

Note:
Time-table for winter semester 2020/2021:
Time-table is not available yet
Time-table for summer semester 2020/2021:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2021-03-01
For updated information see http://bilakniha.cvut.cz/en/predmet24906005.html