Course: Database Technologies 1

« Back
Course title Database Technologies 1
Course code KMI/DBT1
Organizational form of instruction Seminary
Level of course Master
Year of study not specified
Semester Summer
Number of ECTS credits 3
Language of instruction Czech
Status of course Compulsory-optional
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Opichal Stanislav, RNDr.
Course content
1. SQL Structured Query Language 2. Integrity of data and tools to maintain the integrity 3. Database transactions 4. SQL procedural extension 5. Database objects 6. Database access mechanisms

Learning activities and teaching methods
Lecture, Laboratory Work
Learning outcomes
The aim of the course is to extend knowledge about database systems theoretically as well as practically. Problems are demonstrated and practically solved using Oracle 10g Object Oriented Relational System.
2. Comprehension Recognize advanced topics and new trends in databases.
Prerequisites
unspecified

Assessment methods and criteria
Student performance

Cretit Activity at practices and completing given tasks.
Recommended literature
  • Connolly Thomas, Begg Carolyn. (2002). Database Systems: A Practical Approach to Design, Implementation and Management. Addison Wesley.
  • Johnson James L. (1997). Database Models, Languages, Design. Oxford University Press.
  • Kevin Loney, Bob Bryla. (2006). Mistrovství v Oracle Database 10g. Computer Press.
  • O'Neil Patrick, O'Nell Elizabeth. (2001). Database Principles, Programming and Performance. Morgan Kaufman.
  • Pokorný, J., Halaška I. (2003). Databázové systémy. 2. vyd. Vydavatelství ČVUT, Praha.
  • Zaniolo Carlo a kol. (1997). Advanced Database Systems. Morgan Kaufmann, San Francisco.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Science Applied Computer Science (1) Informatics courses 1 Summer
Faculty of Science Computer Science (2015) Informatics courses 1 Summer