Course: SQL Database

« Back
Course title SQL Database
Course code UF/0D132
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 4
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Course availability The course is available to visiting students
Lecturer(s)
  • ZEMAN Jaroslav, Ing.
Course content
Database Systems: - Description of the systems, features, object-oriented database model. - Relational database. - Description, basic concepts, the mathematical apparatus, search engine algorithms. Database design: - The procedures for creating relational database, conceptual schema ER-diagrams, types of attributes, relational connection, database normalization. SQL syntax: - Predicates, logical connectives, handling DB, sessions, entities, projection, selection, data aggregation, transaction management, access rights management. Use SQL in othres programming languages: PERL, PHP.

Learning activities and teaching methods
Interactive lecture, Lecture supplemented with a discussion, unspecified
Recommended literature
  • Arie D. Jones, Ron Plew, Ryan K. Stephens. Naučte se SQL za 28 dní. Computer Press.
  • O'Reilly. PHP a MYSQL. Computer Press. ISBN 80-7226-760-4.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Philosophy and Science in Opava Computer Technology and its Applications (2) Informatics courses 2 Winter
Faculty of Philosophy and Science in Opava Computer Technology and its Applications (1) Informatics courses 2 Winter