Language SQL, advanced
Code | Completion | Credits | Range | Language |
---|---|---|---|---|
BI-SQL.1 | KZ | 4 | 3C | Czech |
- Garant předmětu:
- Lecturer:
- Tutor:
- 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/
- No time-table has been prepared for this course
- The course is a part of the following study plans:
-
- Bachelor program Informatics, unspecified branch, in Czech, 2015-2020 (elective course)
- Bachelor branch Security and Information Technology, in Czech, 2015-2020 (elective course)
- Bachelor branch Computer Science, in Czech, 2015-2020 (elective course)
- Bachelor branch Computer Engineering, in Czech, 2015-2020 (elective course)
- Bachelor branch Information Systems and Management, in Czech, 2015-2020 (elective course)
- Bachelor branch Web and Software Engineering, spec. Software Engineering, in Czech, 2015-2020 (elective course)
- Bachelor branch Web and Software Engineering, spec. Web Engineering, in Czech, 2015-2020 (elective course)
- Bachelor branch Web and Software Engineering, spec. Computer Graphics, in Czech, 2015-2020 (elective course)
- Bachelor branch Knowledge Engineering, in Czech, 2018-2020 (elective course)
- Bachelor specialization Information Security, in Czech, 2021 (elective course)
- Bachelor specialization Management Informatics, in Czech, 2021 (elective course)
- Bachelor specialization Computer Graphics, in Czech, 2021 (elective course)
- Bachelor specialization Computer Engineering, in Czech, 2021 (elective course)
- Bachelor program, unspecified specialization, in Czech, 2021 (elective course)
- Bachelor specialization Web Engineering, in Czech, 2021 (elective course)
- Bachelor specialization Artificial Intelligence, in Czech, 2021 (elective course)
- Bachelor specialization Computer Science, in Czech, 2021 (elective course)
- Bachelor specialization Software Engineering, in Czech, 2021 (elective course)
- Bachelor specialization Computer Systems and Virtualization, in Czech, 2021 (elective course)
- Bachelor specialization Computer Networks and Internet, in Czech, 2021 (elective course)
- Study plan for Ukrainian refugees (elective course)
- Bachelor specialization Information Security, in Czech, 2024 (elective course)
- Bachelor program, unspecified specialization, in Czech, 2024 (elective course)
- Bachelor specialization Management Informatics, in Czech, 2024 (elective course)
- Bachelor specialization Computer Graphics, in Czech, 2024 (elective course)
- Bachelor specialization Software Engineering, in Czech, 2024 (elective course)
- Bachelor specialization Web Engineering, in Czech, 2024 (elective course)
- Bachelor specialization Computer Networks and Internet, in Czech, 2024 (elective course)
- Bachelor specialization Computer Engineering, in Czech, 2024 (elective course)
- Bachelor specialization Computer Systems and Virtualization, in Czech, 2024 (elective course)
- Bachelor specialization Artificial Intelligence, in Czech, 2024 (elective course)
- Bachelor specialization Computer Science, in Czech, 20214 (elective course)