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.

P003 Relational Database System Architecture

Faculty of Informatics
Spring 2001
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 7:00–8: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 2002.

P003 Relational Database System Architecture

Faculty of Informatics
Spring 2000
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. Jana Kuklová (lecturer)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (lecturer)
Guaranteed by
doc. Ing. Jan Staudek, CSc.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: RNDr. Jana Kuklová
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
  • Database system architecture. Query languages, SQL. Embedding SQL to host languages. Query optimalization, execution plans. Transaction processing. Multiuser environment. Authorization and security.
  • Practical training is based on Oracle database system.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is taught: every week.
The course is also listed under the following terms Autumn 1995, Autumn 1996, Spring 1998, Spring 1999, Spring 2001, Spring 2002.

P003 Relational Database System Architecture

Faculty of Informatics
Spring 1999
Extent and Intensity
2/1. 3 credit(s). Recommended Type of Completion: zk (examination). Other types of completion: k (colloquium), z (credit).
Teacher(s)
RNDr. Jana Kuklová (lecturer)
Guaranteed by
Contact Person: RNDr. Jana Kuklová
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
  • Database system architecture. Query languages, SQL. Embedding SQL to host languages. Query optimalization, execution plans. Transaction processing. Multiuser environment. Authorization and security.
  • Practical training is based on Oracle database system.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is taught: every week.
The course is also listed under the following terms Autumn 1995, Autumn 1996, Spring 1998, Spring 2000, Spring 2001, Spring 2002.

P003 Relational Database System Architecture

Faculty of Informatics
Spring 1998
Extent and Intensity
2/1. 3 credit(s). Recommended Type of Completion: zk (examination). Other types of completion: k (colloquium), z (credit).
Teacher(s)
RNDr. Jana Kuklová (lecturer)
Guaranteed by
Contact Person: RNDr. Jana Kuklová
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
  • Database system architecture. Query languages, SQL. Embedding SQL to host languages. Query optimalization, execution plans. Transaction processing. Multiuser environment. Authorization and security.
  • Practical training is based on Oracle database system.
Language of instruction
Czech
The course is also listed under the following terms Autumn 1995, Autumn 1996, Spring 1999, Spring 2000, Spring 2001, Spring 2002.

P003 Relational Database System Architecture

Faculty of Informatics
Autumn 1996
Extent and Intensity
2/1. 3 credit(s). Recommended Type of Completion: zk (examination). Other types of completion: k (colloquium), z (credit).
Teacher(s)
RNDr. Jana Kuklová (lecturer)
Guaranteed by
Contact Person: RNDr. Jana Kuklová
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
  • Database system architecture. Query languages, SQL. Embedding SQL to host languages. Query optimalization, execution plans. Transaction processing. Multiuser environment. Authorization and security.
  • Practical training is based on Oracle database system.
Language of instruction
Czech
The course is also listed under the following terms Autumn 1995, Spring 1998, Spring 1999, Spring 2000, Spring 2001, Spring 2002.

P003 Relational Database System Architecture

Faculty of Informatics
Autumn 1995
Extent and Intensity
0/0. 3 credit(s). Recommended Type of Completion: zk (examination). Other types of completion: k (colloquium), z (credit).
Teacher(s)
RNDr. Jana Kuklová (lecturer)
Guaranteed by
Contact Person: RNDr. Jana Kuklová
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
  • Database system architecture. Query languages, SQL. Embedding SQL to host languages. Query optimalization, execution plans. Transaction processing. Multiuser environment. Authorization and security.
  • Practical training is based on Oracle database system.
Language of instruction
Czech
The course is also listed under the following terms Autumn 1996, Spring 1998, Spring 1999, Spring 2000, Spring 2001, Spring 2002.
  • Enrolment Statistics (recent)