M8DBR Database systems and R for data science

Faculty of Science
Spring 2026
Extent and Intensity
1/2/0. 3 credit(s) (fasci plus compl plus > 4). Type of Completion: zk (examination).
In-person direct teaching
Teacher(s)
RNDr. Veronika Eclerová, Ph.D. (lecturer)
Guaranteed by
doc. PaedDr. RNDr. Stanislav Katina, Ph.D.
Department of Mathematics and Statistics – Departments – Faculty of Science
Supplier department: Department of Mathematics and Statistics – Departments – Faculty of Science
Timetable
Mon 16. 2. to Fri 22. 5. Thu 16:00–16:50 MP2,01014a
  • Timetable of Seminar Groups:
M8DBR/01: Mon 16. 2. to Fri 22. 5. Thu 17:00–19:50 MP2,01014a, V. Eclerová
Prerequisites
Basic knowledge of algebra (relations and properties of relations), basic descriptive statistics, basics of programming.
Course Enrolment Limitations
The course is offered to students of any study field.
Abstract
The aim of the course is (i) to familiarize students with the SQL language, (ii) to teach students the principles of creating relational databases and applying these principles in the creation of data warehouses, (iii) to teach students how to work with data warehouses through connection to the R-studio environment (creation of basic descriptive statistics, reports).
Learning outcomes
The student will be able to:
Build a simple data warehouse (in MSSQL)
Retrieve data from the data warehouse using SQL
Connect the data warehouse to the R-studio environment
Key topics
  • Introduction to database systems
  • Database design, mathematical foundations of database systems
  • SQL language – basic syntax and commands, data filtering, aggregation, relations and table joins, creating views, stored functions, and procedures
  • Using relational databases to create data warehouses
  • Data analysis and reporting in R
Study resources and literature
    recommended literature
  • Databáze, David M. Kroenke David J. Auer, 2015, Computer Press
  • Databases using R, Ruiz E., Dostupné z https://db.rstudio.com/
  • Database concepts. KROENKE, David M., et al. Upper Saddle River, NJ: Prentice Hall, 2010.
Approaches, practices, and methods used in teaching
Practical seminars on computers supplemented by theoretical explanations. Change in the organisation of instruction for the spring semester of 2026—instruction will not take place throughout the entire semester, but will begin approximately in mid-March. The weekly number of hours will be increased proportionally.
Method of verifying learning outcomes and course completion requirements
Project (homework during the semester) 80 points, oral exam 20 points
Grading:
• A: 91–100 points
• B: 81–90 points
• C: 71–80 points
• D: 61–70 points
• E: 51–60 points
• F: 50 or less than 50 points
Language of instruction
Czech
Further comments (probably available only in Czech)
The course is taught annually.
Teacher's information
Participation in the exercises is mandatory (3 unexcused absences are tolerated). In case of prolonged illness, attendance at least half of the exercises is required. The exercises and lectures are scheduled as a single block, and participation in the entire block is recommended.
The course is also listed under the following terms Spring 2022, Spring 2024, Spring 2025.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/sci/spring2026/M8DBR