Database Technologies
| Type of study | Bachelor |
|---|---|
| Language of instruction | English |
| Code | 545-0237/02 |
| Abbreviation | DBT |
| Course title | Database Technologies |
| Credits | 4 |
| Coordinating department | Department of Economics and Control Systems |
| Course coordinator | doc. Ing. Filip Beneš, Ph.D. |
Osnova předmětu
1. Introduction to Database Technologies: History, importance, types of databases, ranking, and leading database providers.
2. Database Systems (DBMS): Functions and architectures of database management systems.
3. Database Modeling: ER diagrams and UML class diagrams.
4. Relational Database Design: Functional dependencies, keys, and normalization.
5. Relational Data Model and Querying, Data Types in Databases: Overview, internal data storage formats, relational algebra, and SQL.
6. SQL: Basic operations (CRUD), queries, JOIN operations, and stored procedures.
7. Indexes, Query Optimization, and Database Performance.
8. Transactions: Properties (ACID) and management.
9. NoSQL Databases: Types and differences from relational databases.
10. Graph and Vector Databases, Large Language Models.
11. Database Security and Backup: Approaches, encryption, authentication, authorization, and fault-tolerant solutions.
12. Big Data and Cloud Databases: Introduction, architecture, and applications.
13. Data Analysis and Business Intelligence: Data warehouses and an introduction to BI tools.
2. Database Systems (DBMS): Functions and architectures of database management systems.
3. Database Modeling: ER diagrams and UML class diagrams.
4. Relational Database Design: Functional dependencies, keys, and normalization.
5. Relational Data Model and Querying, Data Types in Databases: Overview, internal data storage formats, relational algebra, and SQL.
6. SQL: Basic operations (CRUD), queries, JOIN operations, and stored procedures.
7. Indexes, Query Optimization, and Database Performance.
8. Transactions: Properties (ACID) and management.
9. NoSQL Databases: Types and differences from relational databases.
10. Graph and Vector Databases, Large Language Models.
11. Database Security and Backup: Approaches, encryption, authentication, authorization, and fault-tolerant solutions.
12. Big Data and Cloud Databases: Introduction, architecture, and applications.
13. Data Analysis and Business Intelligence: Data warehouses and an introduction to BI tools.
E-learning
For communication beyond in-person lectures and exercises, the Moodle learning management system (lms.vsb.cz) is used. This platform facilitates communication not only between the instructor and students but also among students themselves.
Povinná literatura
MORABITO, Vincenzo. Big data and analytics: strategic and organizational impacts. Cham: Springer, [2015]. ISBN 978-3-319-10664-9.
SCIORE, Edward. Database design and implementation. Data-centric systems and applications. Cham, Switzerland: Springer, [2020]. ISBN 978-3-030-33835-0.
OLSZAK, Celina M. Business intelligence and big data: drivers of organizational success. Boca Raton: CRC Press, Taylor & Francis Group, 2020. ISBN 978-0-367-37394-8.
LAKSHMAN, Bulusu a ABELLERA, Rosendo. AI meets BI: artificial intelligence and business intelligence. Boca Raton: CRC Press, Taylor & Francis Group, [2021]. ISBN 978-0-367-33260-0.
SCIORE, Edward. Database design and implementation. Data-centric systems and applications. Cham, Switzerland: Springer, [2020]. ISBN 978-3-030-33835-0.
OLSZAK, Celina M. Business intelligence and big data: drivers of organizational success. Boca Raton: CRC Press, Taylor & Francis Group, 2020. ISBN 978-0-367-37394-8.
LAKSHMAN, Bulusu a ABELLERA, Rosendo. AI meets BI: artificial intelligence and business intelligence. Boca Raton: CRC Press, Taylor & Francis Group, [2021]. ISBN 978-0-367-33260-0.
Advised literature
DECKLER, Greg a POWELL, Bret. Mastering Microsoft Power BI: expert techniques to create interactive insights for effective data analytics and business intelligence. Second edition. Expert insight. Birmingham: Packt, [2022]. ISBN 978-1-80181-148-4.
SANTOS, Maribel Yasmina a COSTA, Carlos. Big data: concepts, warehousing, and analytics. River Publishers series in information science and technology. Gistrup, Denmark: Rever Publishers, [2020]. ISBN 978-87-7022-184-9.
SKYRIUS, Rimvydas. Business intelligence: a comprehensive approach to information needs, technologies and culture. Progress in IS. Cham, Switzerland: Springer, [2021]. ISBN 978-3-030-67031-3.
LABERGE, Robert. The data warehouse mentor: practical data warehouse and business intelligence insights. New York: McGraw-Hill, c2011. ISBN 978-0-07-174532-1 .
SANTOS, Maribel Yasmina a COSTA, Carlos. Big data: concepts, warehousing, and analytics. River Publishers series in information science and technology. Gistrup, Denmark: Rever Publishers, [2020]. ISBN 978-87-7022-184-9.
SKYRIUS, Rimvydas. Business intelligence: a comprehensive approach to information needs, technologies and culture. Progress in IS. Cham, Switzerland: Springer, [2021]. ISBN 978-3-030-67031-3.
LABERGE, Robert. The data warehouse mentor: practical data warehouse and business intelligence insights. New York: McGraw-Hill, c2011. ISBN 978-0-07-174532-1 .