Advanced SQL - B500009
Title: Jazyk SQL, pokročilý
Guaranteed by: Department of Informatics and Chemistry (143)
Faculty: Faculty of Chemical Technology
Actual: from 2021
Semester: summer
Points: summer s.:4
E-Credits: summer s.:4
Examination process: summer s.:
Hours per week, examination: summer s.:0/3, MC [HT]
Capacity: unknown / unlimited (unknown)
Min. number of students: unlimited
Language: Czech
Teaching methods: full-time
Teaching methods: full-time
Level:  
For type: Bachelor's
Guarantor: Valenta Michal Ing. Ph.D.
Interchangeability : N500017
Examination dates   
Annotation -
Last update: Kubová Petra Ing. (09.01.2018)
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.
Aim of the course -
Last update: Kubová Petra Ing. (09.01.2018)

Students will be able to:

Create advanced SQL queries

Optimize SQL queries

Literature -
Last update: Svozil Daniel prof. Mgr. Ph.D. (26.03.2019)

R: J. Pokorný, M. Valenta: Databázové systémy, ČVUT Praha 2013

A: I. Holubová, J. Kosek, K. Minařík, D. Novák: Big Data a NoSQL databáze, Grada 2013

Learning resources -
Last update: Kubová Petra Ing. (09.01.2018)

Detailed coures instructions. https://edux.fit.cvut.cz/courses/BI-SQL/

Syllabus -
Last update: Svozil Daniel prof. Mgr. Ph.D. (26.03.2019)

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

13. Object relational features, semester project evaluation

Registration requirements -
Last update: Kubová Petra Ing. (09.01.2018)

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

Course completion requirements - Czech
Last update: Svozil Daniel prof. Mgr. Ph.D. (07.02.2018)

Pro zı́skánı́ klasifikovaného zápočtu je potřeba dostatek bodů z písemných testů, programovacích úloh a semestrální práce.

Teaching methods
Activity Credits Hours
Příprava na přednášky, semináře, laboratoře, exkurzi nebo praxi 1 28
Práce na individuálním projektu 1.5 42
Účast na seminářích 1.5 42
4 / 4 112 / 112