Course: Database systems for Administration

« Back
Course title Database systems for Administration
Course code UI/AI016
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 6
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)
  • MARČEK Dušan, prof. Ing. CSc.
  • MENŠÍK Marek, Mgr. Ph.D.
  • LANGER Miroslav, RNDr. Ph.D.
Course content
1. Introduction to data base systems 2. Database management systems 3. The architectures of databases 4. Components of database systems 5. Date description language 6. Date manipulation language 7. Models of databases 8. Relational database model 9. Programming in MySQL 10. Practical design of relational databases Activities None Guarantors and Lecturers * Guarantors: Prof. Ing. Dušan MARČEK, CSc. * Lecturer: RNDr. Miroslav LANGER, Ph.D. * Tutorial lecturer: RNDr. Miroslav LANGER, Ph.D. Literature * Basic: MARČEK, M.: Technologie zpracování dat, databázové zpracování. SU, FPF, Ústav informatiky, Opava, 2008 , ISBN: 978-80-7248-480-5. * Further literature: HOFFER, Jeffrey A., Ramesh VENKATARAMAN a Heikki TOPI. Modern Database Management. 10. vyd. Upper Saddle River: Prentice Hall, 2011. ISBN 978-0-13-608839-4. HOTEK, Mike. Microsoft SQL Server 2008 krok za krokem. Brno: Computer Press, 2009, ISBN 978-80-251-2466-6. GROFF, James R. a Paul N. WEINBERG. SQL : kompletní průvodce. Brno: CP Books, 2005, ISBN 80-251-0369-2. * Recommended: WALTERS, Robert E. Mistrovství v Microsoft SQL Server 2008 : [kompletní průvodce databázového experta]. Brno: Computer Press, 2009, ISBN 978-80-251-2329-4. Prerequities None Other requirements 1 ongoing test, combined exam

Learning activities and teaching methods
Interactive lecture, Lecture with a video analysis
Recommended literature
  • GROFF, R. James a Paul N. WEINBERG. SQL kompletní průvodce. Brno, CP, 2005. ISBN 80-251-0369-2.
  • HERNANDEZ, Michael J. Myslíme v jazyku SQL: tvorba dotazů. Praha: Grada, 2000. ISBN 80-247-0899-X.
  • MARČEK, M. Technologie zpracování dat, databázové zpracování. Opava, SU FPF, UI, 2008. ISBN 978-80-7248-480-5.


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 Applied Computer Science (1) Informatics courses 2 Winter