N_DS Database Systems

University of Finance and Administration
Winter 2019
Extent and Intensity
2/2/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: Sat 26. 10. 8:00–9:30 S11, 9:45–11:15 S11, 11:30–13:00 S11, 14:00–15:30 S11, Fri 6. 12. 14:00–15:30 S11, 15:45–17:15 S11, 17:30–19:00 S11, 19:15–20:45 S11, J. Lánský
Prerequisites
Finished bachelor study of Applied Informatics.
Course Enrolment Limitations
The course is offered to students of any study field.
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
  • Holubová, I.: Big Data a NoSQL databáze. Praha: Grada, 2015. ISBN:978-80-247-5466-6
  • Kroenke, D. M; Auer, D. J.: Databáze, Brno: Computer Press, 2015. ISBN:978-80-251-4352-0
  • Mlýnková a kol.: Technologie XML - Principy a aplikace v praxi. Grada, Praha, 2008
  • Pokorný: Dotazovací jazyky. Karolinum, 2002.
  • Pokorný, Žemlička: Základy implementace souborů a databází, Karolinum, Praha, 2004
    recommended literature
  • Lacko: Datové sklady, analýza OLAP a dolování dat. 1. vyd. Brno : Computer Press, 2003.
  • Sack: Velká kniha T-SQL & SQL Server 2005, Zoner Press, 2007
  • Ramakrishnan, Gehrke: Database Systems Management, McGraw-Hill, 2003
  • Manning, Raghavan, Schütze: Introduction to Information Retrieval, Cambridge University Press, 2008.
  • Pokorný, Halaška: Databázové systémy, skripta FEL ČVUT, 2003
  • Halaška, Pokorný: Databázové systémy – cvičení, skripta ČVUT, 2002
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: 16 hodin KS/semestr.
The course is also listed under the following terms Winter 2008, Winter 2009, Winter 2010, Winter 2011, Winter 2012, Winter 2013, Winter 2014, Winter 2015, Winter 2016, Winter 2017, Winter 2018, Winter 2020, Winter 2021, Winter 2022, Winter 2023, Summer 2025.
  • Enrolment Statistics (Winter 2019, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/winter2019/N_DS