B_RD Relation Database

University of Finance and Administration
Summer 2024
Extent and Intensity
1/1/0. 3 credit(s). Type of Completion: z (credit).
Teacher(s)
Ing. Vladimír Nulíček, CSc. (seminar tutor)
Guaranteed by
Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková
Timetable of Seminar Groups
B_RD/cAPH: each even Tuesday 14:00–14:44 E228, each even Tuesday 14:45–15:30 E228, V. Nulíček
B_RD/pAPH: each even Tuesday 12:15–12:59 E228, each even Tuesday 13:00–13:45 E228, V. Nulíček
B_RD/vAPH: Fri 12. 4. 17:30–19:00 E304, 19:15–20:45 E304, Fri 26. 4. 14:00–15:30 E304, 15:45–17:15 E304, Sat 27. 4. 14:00–15:30 E304, 15:45–17:15 E304, V. Nulíček
Prerequisites
B_UDS Introduction to Database Sys.
The requirement for the completion of this course is a successful completion of the course B_UDS.
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives
Learning outcomes of the course unit The aim of the course is to build on the knowledge gained in the Introduction to DBS in terms of advanced relational database functions. Students get acquainted with the creation of views, triggers, stored procedures. We will also deal with transaction issues and their planning and scheduling. Students will also get acquainted with non-SQL databases, data warehousing, data cubes etc.
Learning outcomes
After completing the course the student will understand
- problems of stored procedures, functions and triggers
- creation of views
- indexing in databases
- transactions programming and scheduling
- basics of the non SQL databases, data warehouses, and cubes
Syllabus
  • Content of lectures:
  • 1. Repeating SQL
  • 2. Database transactions
  • 3. Transaction Schedules
  • 4. Views
  • 5. Advanced objects - stored procedures, functions, triggers
  • 6. Indexing of
  • databases 7. DCL commands
  • 8. Debugging SQL statements
  • 9. Rationalization of SQL statements
  • 10. Introduction to Business Intelligence
  • 11. Data warehouses
  • 12. no-SQL database
Literature
    required literature
  • KROENKE, David a David J. AUER. Databáze. Brno: Computer Press, 2015. ISBN 978-80-251-4352-0.
  • Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
    recommended literature
  • Joseph Sack: Velká kniha T-SQL SQL server 2005, 864 stran, Zoner Press, ISBN 978-80-806815-57-2
  • HOLUBOVÁ, Irena, Jiří KOSEK, Karel MINAŘÍK a David NOVÁK. Big Data a NoSQL databáze. Praha: Grada, 2015. Profesionál. ISBN 978-80-247-5466-6.
Teaching methods
Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject
Assessment methods
Subject ending method:
The subject is completed with a credit based on the processing of semester assignments, possibly. a short written test (as a compensation for not processing or incorrectly processing semester assignments)
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.
The course is also listed under the following terms Summer 2008, Summer 2009, Summer 2010, Summer 2011, summer 2012, Winter 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2017, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2025.
  • Enrolment Statistics (Summer 2024, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2024/B_RD