PV003 Relational Database System Architecture

Faculty of Informatics
Spring 2005
Extent and Intensity
2/1. 3 credit(s) (plus extra credits for completion). Recommended Type of Completion: zk (examination). Other types of completion: k (colloquium), z (credit).
Teacher(s)
RNDr. Milan Drášil, CSc. (lecturer)
RNDr. Jiří Hroza (seminar tutor)
doc. RNDr. Petr Švenda, Ph.D. (seminar tutor)
Guaranteed by
prof. Ing. Pavel Zezula, CSc.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: RNDr. Milan Drášil, CSc.
Timetable
Mon 16:00–17:50 D2
  • Timetable of Seminar Groups:
PV003/01: Tue 12:00–12:50 B311, P. Švenda
PV003/02: Tue 13:00–13:50 B311, P. Švenda
PV003/03: Thu 18:00–18:50 B311, P. Švenda
PV003/04: Thu 19:00–19:50 B311, P. Švenda
PV003/05: Wed 12:00–12:50 B311, J. Hroza
PV003/06: Wed 13:00–13:50 B311, J. Hroza
PV003/07: Thu 12:00–12:50 B311, J. Hroza
Prerequisites (in Czech)
! P003 RDBS Architecture
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
there are 18 fields of study the course is directly associated with, display
Course objectives (in Czech)
Výklad je zaměřen na relační DB systémy a dotazovací jazyk SQL.
Syllabus
  • 1. DDL - Data Definition Language SQL - standard and user data types - table definition - integrity constraints (primary, references, check) - sequential generators - synonyms - views - indexes 2. Security - basic rules - roles - user's rights 3. DML - Data Manipulation Language SQL - INSERT, UPDATE, DELETE, TRUNCATE - projection in SQL - selection in SQL - product in SQL - indexes - query execution plans - query optimalization 4. Server procedures - functions - procedures - procedure packages - triggers - events 5. Development Techniques for client applications - PRO*C
Literature
  • Definice jazyka SQL, firemní dokumentace
Assessment methods (in Czech)
Ucast na cviceni neni povinna. Pro ziskani zapoctu je treba prezentovat jednoduchy projekt a napsat pisemnou zapoctovou zkousku (prikaz select). Pro ziskani zkousky je treba navic uspesne absolvovat pisemku - test z princiou SQL, PL/SQL,PRO*C.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.
  • Enrolment Statistics (Spring 2005, recent)
  • Permalink: https://is.muni.cz/course/fi/spring2005/PV003