|
Lecturer(s)
|
-
Borkovcová Monika, Ing. Ph.D.
|
|
Course content
|
1. Introduction to database systems, database models, basic relational operations on data in tables 2. Database design phase, conceptual modeling. 3. Logical database design, 4. Normalization. 5. Physical database design. 6. Database modelling in practice. 7. SQL language, DDL, DML statement groups. Data types. Basic syntax of Select, Insert commands, Update, Delete. 8. Internal and external joins of tables. 9. Logical operators. Aliases, sorting the result. 10. Summary and group queries. Aggregation, 11. Views. Nested queries. Set operators. 12. Functions, working with strings, NULL value, date and time. 13. Sequences, indexes.
|
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Work with text (with textbook, with book), Demonstration, Projection, Skills training
- Contact teaching
- 8 hours per semester
- Home preparation for classes
- 70 hours per semester
- Preparation for an exam
- 30 hours per semester
- Term paper
- 42 hours per semester
|
|
Learning outcomes
|
The aim of the course is to practically deal with the design of a database model, to get the basics of working with the SQL language, including joining tables, working with functions and views. Upon completion of the course, the student demonstrates knowledge of the fundamentals of working with SQL in a database system, can design a database model, create database objects, work with data in SQL.
Design a relational database from conceptual modeling through normalization and physical implementation to practical database modeling, while mastering SQL for data definition and manipulation, including complex queries with table joins, aggregations, views, functions, and advanced elements such as sequences and indexes.
|
|
Prerequisites
|
unspecified
|
|
Assessment methods and criteria
|
Written examination, Home assignment evaluation, Self project defence
To obtain the credit, students must successful defense and proper completion of the credit project (min. 70%). The exam is written and tests the student's practical and theoretical knowledge and understanding of the material covered (min. 70%). For successful completion of the course, student participation and preparation for exercises is recommended.
|
|
Recommended literature
|
-
Chhanda Ray. Advanced Database System. 2020. ISBN 979-8691380891.
-
Marek Laurenčík. SQL - Podrobný průvodce uživatele. 2018. ISBN 978-80-271-0774-2.
-
Pokorný Jaroslav, Valenta Michal. Databázové systémy. Praha, 2020. ISBN 978-80-01-06696-6.
-
Radek Vystavěl. Databáze a SQL pro začátečníky. 2021. ISBN 978-80-908144-0-0.
|