|
|
|
||
Last update: Kubová Petra Ing. (02.01.2018)
|
|
||
Last update: Jirát Jiří Ing. Ph.D. (02.01.2018)
Students will be able to: Create advanced SQL queries Optimize SQL queries |
|
||
Last update: Kubová Petra Ing. (02.01.2018)
Ramakrishnan, R., Gehrke, J. ''Database Management Systems''. McGraw Hill Higher Education, 2002. ISBN 0071230572. |
|
||
Last update: Jirát Jiří Ing. Ph.D. (02.01.2018)
Detailed coures instructions. https://edux.fit.cvut.cz/courses/BI-SQL/ |
|
||
Last update: Kubová Petra Ing. (02.01.2018)
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 |
|
||
Last update: Kubová Petra Ing. (02.01.2018)
Entry requirement: Course assumes a basic a basic knowledge of SQL language at a level of BI-DBS requirements. |
Teaching methods | ||||
Activity | Credits | Hours | ||
Příprava na přednášky, semináře, laboratoře, exkurzi nebo praxi | 1.5 | 42 | ||
Příprava na zkoušku a její absolvování | 1 | 28 | ||
Účast na seminářích | 1.5 | 42 | ||
4 / 4 | 112 / 112 |