FI:PA220 DB systems for data analytics - Course Information
PA220 Database systems for data analytics
Faculty of InformaticsAutumn 2020
- Extent and Intensity
- 2/0/0. 2 credit(s) (plus extra credits for completion). Type of Completion: zk (examination).
- Teacher(s)
- doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
RNDr. Miriama Jánošová (assistant) - Guaranteed by
- doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Machine Learning and Data Processing – Faculty of Informatics
Supplier department: Department of Machine Learning and Data Processing – Faculty of Informatics - Timetable
- Tue 12:00–13:50 A320
- Prerequisites
- Knowledge of relational database systems, query and transaction processing and principles of query optimization, preferably in the scope of PA152 course.
- Course Enrolment Limitations
- The course is also offered to the students of the fields other than those the course is directly associated with.
- fields of study / plans the course is directly associated with
- Image Processing and Analysis (programme FI, N-VIZ)
- Bioinformatics and systems biology (programme FI, N-UIZD)
- Computer Games Development (programme FI, N-VIZ_A)
- Computer Graphics and Visualisation (programme FI, N-VIZ_A)
- Computer Networks and Communications (programme FI, N-PSKB_A)
- Cybersecurity Management (programme FI, N-RSSS_A)
- Formal analysis of computer systems (programme FI, N-TEI)
- Graphic design (programme FI, N-VIZ)
- Graphic Design (programme FI, N-VIZ_A)
- Hardware Systems (programme FI, N-PSKB_A)
- Hardware systems (programme FI, N-PSKB)
- Image Processing and Analysis (programme FI, N-VIZ_A)
- Information security (programme FI, N-PSKB)
- Information Security (programme FI, N-PSKB_A)
- Quantum and Other Nonclassical Computational Models (programme FI, N-TEI)
- Computer graphics and visualisation (programme FI, N-VIZ)
- Computer Networks and Communications (programme FI, N-PSKB)
- Principles of programming languages (programme FI, N-TEI)
- Cybersecurity management (programme FI, N-RSSS)
- Services development management (programme FI, N-RSSS)
- Software Systems Development Management (programme FI, N-RSSS)
- Services Development Management (programme FI, N-RSSS_A)
- Software Systems Development Management (programme FI, N-RSSS_A)
- Software Systems (programme FI, N-PSKB_A)
- Software systems (programme FI, N-PSKB)
- Machine learning and artificial intelligence (programme FI, N-UIZD)
- Computer Games Development (programme FI, N-VIZ)
- Processing and analysis of large-scale data (programme FI, N-UIZD)
- Natural language processing (programme FI, N-UIZD)
- Course objectives
- To get acquainted with the possibilities of database systems and their use for data analytics: design and implementation of data warehouses; query languages and tools for integration with external computing and analytics platforms (Apache Hive); analytical databases (Apache Impala).
- Learning outcomes
- Student will be able to: - understand the principles of data warehouses; - describe typical examples of data warehouse use-cases; - design a data warehouse; - create a solution to analytical tasks.
- Syllabus
- Introduction to data warehouses and business intelligence.
- Data modeling for data warehouses: dimensions, facts.
- Data warehouse lifecycle.
- Data warehouse creation processes: ETL.
- Data warehouse applications: sales, CRM.
- Analytical databases.
- Languages for analytical tasks.
- Big data analytics.
- Literature
- recommended literature
- KIMBALL, Ralph and Margy ROSS. Data warehouse toolkit : the definitive guide to dimensional modeling. Third edition. Indianapolis: John Wiley & Sons, 2013, xxxiv, 564. ISBN 9781118530801. info
- INMON, William H. Building the data warehouse. 4th ed. Indianapolis: Wiley Publishing, 2005, xxviii, 54. ISBN 0764599445. info
- not specified
- Microsoft Corporation. Implementing a Data Warehouse with Microsoft SQL Server 2012. 2012. info
- Oracle Warehouse Builder 11gR2getting started : extract, transform, and load data to build a dynamic, operational data warehouse. Edited by Bob Griesemer. Olton, Birmingham: Packt Pub., 2011, v, 408 p. ISBN 9781849683456. info
- Teaching methods
- Lectures.
- Assessment methods
- written exam -- includes both test questions (choice of options) and free-hand answers.
- Language of instruction
- Czech
- Further Comments
- Study Materials
The course is taught annually.
- Enrolment Statistics (Autumn 2020, recent)
- Permalink: https://is.muni.cz/course/fi/autumn2020/PA220