B_RD Relation Database

University of Finance and Administration
Summer 2018
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 odd Tuesday 12:15–12:59 E307, each odd Tuesday 13:00–13:45 E307, V. Nulíček
B_RD/pAPH: each even Tuesday 12:15–12:59 E307, each even Tuesday 13:00–13:45 E307, V. Nulíček
B_RD/vAPH: Fri 16. 3. 17:30–19:00 E307, Fri 6. 4. 15:45–17:15 E303PC, 17:30–19:00 E303PC, 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
At the end of the course the student should have practical knowledge and skills in the area of relational databases. A substantial part is devoted to creation of own database project.
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
Course completion: Credit is awarded on the basis of semester work: own database project (from conceptual design to SQL code). The test is subject to a credit and is 50% based on the semester work and 50% to written test of the theory.
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 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.
  • Enrolment Statistics (Summer 2018, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2018/B_RD