Course: Databases and data mining

» List of faculties » FP » MTI
Course title Databases and data mining
Course code MTI/DDS
Organizational form of instruction Lecture + Lesson
Level of course Master
Year of study not specified
Semester Winter
Number of ECTS credits 5
Language of instruction Czech
Status of course unspecified
Form of instruction Face-to-face
Work placements Course does not contain work placement
Recommended optional programme components None
Lecturer(s)
  • Špánek Roman, Ing. Ph.D.
Course content
unspecified

Learning activities and teaching methods
Monological explanation (lecture, presentation,briefing), Independent creative and artistic activities, Lecture
  • Home preparation for classes - 40 hours per semester
  • Class attendance - 56 hours per semester
  • Preparation for exam - 34 hours per semester
  • Preparation for credit - 20 hours per semester
Learning outcomes
Couse delivers basic principles of creation and management of (vast) data sets in a computer. Conceptual modelling as well as overview on current trends in a data storage and management (relational model, NoSQL and object model) will be covered. Student will have a hands on principles of data processing in relational databases (by using SQL) as well as optimization of relational and NoSQL databases. More over the course will cover topics related to datamining techniques (preprocessing of data and results visualization). During seminars students will have hands on examples of design of relational database conceptual model as well as a design and implementation of a complex database system.
Students will acquire experience in creation of database information systems with a special emphasis on pragmatic approaches in realization of the server as well as client site of the application. Dataminig will be also covered.
Prerequisites
Basics programming skills; computer data/files management methods

Assessment methods and criteria
Written exam

Active participation on seminars. Oral presentation of the student's project at the end of semester.
Recommended literature
  • NoSQL, Database for Storage & Retrieval of Data in Cloud.
  • CICHOSZ. Data Mining algorithms - Explained Using R.
  • HOLUBOVÁ, I., KOSEK, J., MINAŘÍK ,K.,NOVÁK, D. Big Data a NoSQL databáze.. Grada Praha, 2015. ISBN 978-80-247-5466-6.
  • Pokorný J. Databázová abeceda, Science, 1998.
  • Šešera L. a kol. Datové modelování v příkladech. Grada.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester