Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2018/2019

Language SQL, advanced

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
BI-SQL.1 KZ 4 0+3 Czech
Lecturer:
Michal Valenta (guarantor), Ivan Halaška
Tutor:
Michal Valenta (guarantor), Ivan Halaška
Supervisor:
Department of Software Engineering
Synopsis:

Module is based on knowledge obtained in BI-DBS. Students become familiar with advanced relational and non-relational features of SQL language. In particular stored program unites, triggers, recursive queries, OLAP support, object-relational constructions. Part of the course is dedicated to practical database optimization from the point of view of specialized database structures like indexes, clusters, index-organized tables, and materialized views. as well as from the point of view query optimization. Execution plan and possibilities of its. changes will be discussed. Lectures will usually discuss SQL standard, but many features will be demonstrated on Oracle DBMS. Seminars are based on Oracle DBMS and partially on PostgreSQL.

Requirements:

Entry requirement: Course assumes a basic a basic knowledge of SQL language at a level of BI-DBS requirements.

Syllabus of lectures:
Syllabus of tutorials:

1. Program of seminars, organization, structure and requirements for semester project

2. SQL review, MERGE, OLAP support

3. Consultation to semester project, the first check point

4-6 PL/SQL exercises

7. Consultation to semester project, the second check point

8-9 SQL query optimization, special tools for SQL query optimization

10. Structures for fast data access

11. PostgreSQL - SQL queries optimization basics, pgfounie script

12. Consultation to semester project

12 Object relational features, semester project evaluation

Study Objective:

Practical experiences of SQL advanced features.

Study materials:

Ramakrishnan, R., Gehrke, J. ''Database Management Systems''. McGraw Hill Higher Education, 2002. ISBN 0071230572.

Note:
Further information:
https://courses.fit.cvut.cz/BI-SQL https://edux.fit.cvut.cz/courses/BI-SQL/start https://gitlab.fit.cvut.cz/BI-SQL/bi-sql
Time-table for winter semester 2018/2019:
Time-table is not available yet
Time-table for summer semester 2018/2019:
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
roomT9:350
Halaška I.
Valenta M.

11:00–13:30
(parallel nr.101)
Dejvice
NBFIT PC ucebna
Tue
Fri
Thu
roomT9:348
Halaška I.
Valenta M.

16:15–18:45
(parallel nr.102)
Dejvice
NBFIT PC ucebna
Fri
The course is a part of the following study plans:
Data valid to 2019-04-23
For updated information see http://bilakniha.cvut.cz/en/predmet3319306.html