B_RD Relation Database

University of Finance and Administration
Summer 2020
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 17:30–18:14 S24, each even Tuesday 18:15–19:00 S24, V. Nulíček
B_RD/pAPH: each odd Tuesday 17:30–18:14 S24, each odd Tuesday 18:15–19:00 S24, V. Nulíček
B_RD/vAPH: Sat 15. 2. 14:00–15:30 E227, Sat 14. 3. 14:00–15:30 E227, Sat 18. 4. 14:00–15:30 E222, V. Nulíček
Prerequisites
B_UDS Introduction to Database Sys.
The requirement for the completion of this course is 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 and their scheduling non SQL databases, data warehouses, and cubes
Syllabus
  • This curriculum is designed for full-time study, course of instruction for part-time study is presented in a methodological study materials list (ML). Contents of lectures:
  • 1. Basic operations with tables, data definition (149-202)
  • 2. Views (243 - 262)
  • 3. Indexes (203 - 222)
  • 4. Control of flow in T-SQL (313 - 332)
  • 5. Functions in SQL server (263 - 312)
  • 6. Data modification (95 - 120)
  • 7. Transactions (121 - 148)
  • 8. Data aggregation, pivot tables (67 - 78)
  • 9. Fulltext search (223 - 242)
  • 10. Stored procedures (333 - 352)
  • 11. User-defined functions and types (353 - 380)
  • 12. Triggers (381 - 410)
  • Source - Velká kniha T-SQL SQL server 2005, Joseph Sack, 2005
Literature
    required literature
  • Joseph Sack: Velká kniha T-SQL SQL server 2005, 864 stran, Zoner Press, ISBN 978-80-806815-57-2
    not specified
  • Povinná literatura
  • Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
  • http://nb.vse.cz/~palovska/uds/tskripta.zip
  • Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
  • Doporučená literatura
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
The course is finished by credit on the basis of seminar problems and a short written test.
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: 6 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 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.
  • Enrolment Statistics (Summer 2020, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2020/B_RD