P003 Relational Database System Architecture

Faculty of Informatics
Spring 2002
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)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (seminar tutor)
Guaranteed by
prof. PhDr. Karel Pala, CSc.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: RNDr. Milan Drášil, CSc.
Timetable
Mon 16:00–17:50 D1
Prerequisites (in Czech)
Podmínkou je předchozí absolvování P002 nebo P502.
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
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
Language of instruction
Czech
Further comments (probably available only in Czech)
The course is taught annually.
The course is also listed under the following terms Autumn 1995, Autumn 1996, Spring 1998, Spring 1999, Spring 2000, Spring 2001.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/fi/spring2002/P003