Course: Database Systems 2

« Back
Course title Database Systems 2
Course code KMI/ODBS2
Organizational form of instruction Lesson
Level of course Bachelor
Year of study 2
Semester Summer
Number of ECTS credits 3
Language of instruction English
Status of course Optional
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Remeš Radim, Mgr. Ph.D.
  • Beránek Ladislav, prof. Ing. CSc., MBA
Course content
1. - Introduction into data mining 2. - Data sources. Relational DB. OLAP. Data warehouses. 3. - Fundamentals of statistics and 4. - Statistics. Pivot tables. Regression analyzes. Clustering. 5. - Data preparing 6. - Machine learning. 7. - Decision trees. 8. - Association rules. 9. - Decision rules. 10. - Neural networks, Bayesian classification. 11. - Result evaluation. 12. - Data mining software systems overview.

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Demonstration, E-learning
  • Preparation for credit - 20 hours per semester
  • Preparation for classes - 18 hours per semester
  • Semestral paper - 20 hours per semester
  • Class attendance - 26 hours per semester
Learning outcomes
The course is based on practical programming of database applications - creating of database models and connection of relational databases with object-oriented programs. Students are introduced to procedures of analysis, modeling and implementation of complex projects based on manipulation with data.
Student will be familiarized with the steps of the knowledge discovery process, and with techniques, algorithms and tools used in the process od knowledge discovery in databases. Student will be able to solve simple practical data mining tasks.
Prerequisites
The subject Database systems 1 (DBS1)
KMI/CDBS1
----- or -----
KMI/DBS1
----- or -----
KMI/KDBS1
----- or -----
KMI/ODBS1

Assessment methods and criteria
Test, Seminar work

Credit Requirements: Programming partial short tasks, creating a project application. Global success rate minimally 65%.
Recommended literature
  • N. Jukic, S. Vrbsky, S. Nestorov. Database Systems: Introduction to Databases and Data Warehouses. Prentice Hall, 2013. ISBN 978-0132575676.
  • P. Atkinson, R. Vieira. Beginning Microsoft SQL Server 2012 Programming. Wrox, 2012. ISBN 978-1118102282.
  • R. Mistry, S. Misner. Introducing Microsoft SQL Server 2014. Microsoft Press, 2014. ISBN 978-0735684751.
  • SHOEMAKER, M., L. UML Applied: A .NET Perspective. Apress, 2004.
  • THOMSEN, C. Database Programming with C#. Apress, 2002.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Economics Study plan (Version): Engineering and Informatics (1) Category: Economy 2 Recommended year of study:2, Recommended semester: Summer