Main page | Study Branches/Specializations | Groups of Courses | All Courses | Roles                Instructions

A course is the basic teaching unit, it's design as a medium for a student to acquire comprehensive knowledge and skills indispensable in the given field. A course guarantor is responsible for the factual content of the course.
For each course, there is a department responsible for the course organisation. A person responsible for timetabling for a given department sets a time schedule of teaching and for each class, s/he assigns an instructor and/or an examiner.
Expected time consumption of the course is expressed by a course attribute extent of teaching. For example, extent = 2 +2 indicates two teaching hours of lectures and two teaching hours of seminar (lab) per week.
At the end of each semester, the course instructor has to evaluate the extent to which a student has acquired the expected knowledge and skills. The type of this evaluation is indicated by the attribute completion. So, a course can be completed by just an assessment ('pouze zápočet'), by a graded assessment ('klasifikovaný zápočet'), or by just an examination ('pouze zkouška') or by an assessment and examination ('zápočet a zkouška') .
The difficulty of a given course is evaluated by the amount of ECTS credits.
The course is in session (cf. teaching is going on) during a semester. Each course is offered either in the winter ('zimní') or summer ('letní') semester of an academic year. Exceptionally, a course might be offered in both semesters.
The subject matter of a course is described in various texts.

BIK-SQL.1 Language SQL Extent of teaching: 13KP+4KC
Instructor: Valenta M. Completion: KZ
Department: 18102 Credits: 4 Semester: L

Annotation:
Course 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.

Lecture syllabus:
1. Introduction, SQL overview, command MERGE, OLAP support
2.-6.  Stored program units, Language PL/SQL
7.-8.  SQL query tuning, execution plan
9.-10.  Specialized structures for fast data access
11. Recursive queries
12. -13Object relational features of SQL

Seminar syllabus:
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

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

Requirements:
Course is based on a basic knowledge of SQL language at a level of BI-DBS requirements.

Informace o předmětu a výukové materiály naleznete na https://courses.fit.cvut.cz/BI-SQL/

The course is also part of the following Study plans:
Study Plan Study Branch/Specialization Role Recommended semester
BIK-IB.21 Information Security 2021 (in Czech) V Není
BIK-SPOL.21 Unspecified Branch/Specialisation of Study V Není
BIK-PV.21 Computer Systems and Virtualization 2021 (in Czech) V Není
BIK-PS.21 Computer Networks and Internet 2021 (in Czech) V Není
BIK-SI.21 Software Engineering 2021 (in Czech) V Není
BIK-SPOL.2015 Unspecified Branch/Specialisation of Study V Není
BIK-BIT.2020 Computer Security and Information technology V Není
BIK-WSI-SI.2015 Web and Software Engineering V Není
BIK-BIT.2015 Computer Security and Information technology V Není


Page updated 29. 3. 2024, semester: L/2021-2, Z,L/2023-4, Z/2021-2, Z/2020-1, Z/2019-20, L/2020-1, Z,L/2022-3, L/2019-20, Send comments to the content presented here to Administrator of study plans Design and implementation: J. Novák, I. Halaška