VSFS:N_DS Database Systems - Course Information
N_DS Database Systems
University of Finance and AdministrationWinter 2018
- Extent and Intensity
- 2/1/0. 6 credit(s). Type of Completion: zk (examination).
- Teacher(s)
- doc. RNDr. Jan Lánský, Ph.D. (seminar tutor)
- Guaranteed by
- doc. RNDr. Jan Lánský, Ph.D.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková - Timetable of Seminar Groups
- N_DS/vAPH: Fri 12. 10. 17:30–19:00 S16PC, J. Lánský
- Prerequisites
- Finished bachelor study of Applied Informatics.
- Course Enrolment Limitations
- The course is also offered to the students of the fields other than those the course is directly associated with.
- fields of study / plans the course is directly associated with
- Applied Informatics (programme VSFS, N-INF) (2)
- Course objectives
- Acquire overview about advantages of database processing from the position of an information manager. At the end of the course students should be able to use technologies: SQL, XML, OLAP, Full text search.
- Learning outcomes
- Student will be able to:
- Write complex SQL statements containing multiple levels of plurality of select or group by;
- Create multiple listings with different execution plans for the query;
- Create queries over XML databases in XPath and XQuery
- Ability to create a data warehouse and use datas with rollup and cube clauses
- Ability to create a query over a full-text database - Syllabus
- 1. Query language SQL 2. Indexes and query optimization 3. OLAP, operators CUBE and ROLLUP 4. XML, DTD, XML in SQL 5. Query language XPath 6. Query language XQuery 7. Full text search 8. Transact SQL
- Literature
- required literature
- Pokorný: Dotazovací jazyky. Karolinum, 2002.
- Pokorný, Žemlička: Základy implementace souborů a databází, Karolinum, Praha, 2004
- Mlýnková a kol.: Technologie XML - Principy a aplikace v praxi. Grada, Praha, 2008
- not specified
- Manning, Raghavan, Schütze: Introduction to Information Retrieval, Cambridge University Press, 2008.
- Lacko: Datové sklady, analýza OLAP a dolování dat. 1. vyd. Brno : Computer Press, 2003.
- Pokorný, Halaška: Databázové systémy, skripta FEL ČVUT, 2003
- Ramakrishnan, Gehrke: Database Systems Management, McGraw-Hill, 2003
- Halaška, Pokorný: Databázové systémy – cvičení, skripta ČVUT, 2002
- Sack: Velká kniha T-SQL & SQL Server 2005, Zoner Press, 2007
- Teaching methods
- Lectures and seminars in full-time study, in part-time study instruction is e-learning. Theoretical knowledge will be applied to practical exercises at Microsoft SQL Server. Compulsory seminar participation is 75% in full-time study
- Assessment methods
- Four individual home works (min. 80%). Exam: Programming exercise on computer with discussion about source codes (min 65%).
- Language of instruction
- Czech
- Further comments (probably available only in Czech)
- The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 12 hodin KS/semestr.
- Enrolment Statistics (Winter 2018, recent)
- Permalink: https://is.vsfs.cz/course/vsfs/winter2018/N_DS