|
Lecturer(s)
|
-
Remeš Radim, Mgr. Ph.D.
-
Beránek Ladislav, prof. Ing. CSc., MBA
|
|
Course content
|
1. - Basic terms 2. - Conceptual ER model 3. - Relative algebra, relational calculus 4. - Relational Model, Transformation of E-R Scheme into RMD 5. - SQL - creating queries 6. - SQL - more complex queries, definitions, and data updates 7. - Functional dependencies 8. - Normalization of databases 9. - Advanced features of SQL, procedures, trigger 10. - Transactions 11. - Principles of database administration - eg MS SQL, Posgre SQL 12. - Distributed DBS, Post-Relational DBS, NoSQl Database - Features
|
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing), Demonstration, E-learning
- Preparation for credit
- 14 hours per semester
- Class attendance
- 16 hours per semester
- Preparation for exam
- 14 hours per semester
- Semestral paper
- 40 hours per semester
- Preparation for classes
- 28 hours per semester
|
|
Learning outcomes
|
The course is aimed to introduce students basic theory of database technology. The course includes an overview of basic database models (E-R conceptual model, relational DB model, object DB model), rules of database normalization process, relational algebra, query language SQL, transaction and concurrent access to databases.
The students are able to design, develop and manage relational database applications for personal use even for school or small firm use. Student can orientate in problematics of database design, creating and optimalizating SQL queries.
|
|
Prerequisites
|
The course has no prerequisities.
|
|
Assessment methods and criteria
|
Combined exam
Credit Requirements: Programming partial short tasks, creating a project application. Global success rate minimally 65%. Examination Requirements: Students will demonstrate complex knowledge of creating and designing databases.
|
|
Recommended literature
|
-
CONOLLY, T., BEGG, C., HOLOWCZAK, R. Mistrovství - Databáze. Computer Press, 2009.
-
HERNANDEZ, M., J. Návrh databází. Grada, 2006. ISBN 80-247-0900-7..
-
HOLUBOVÁ, Irena, Jiří KOSEK, Karel MINAŘÍK a David NOVÁK. Big Data a NoSQL databáze. Praha: Grada, 2015. ISBN 978-80-247-5466-6.
-
KROENKE, David a David J. AUER. Databáze. Brno: Computer Press, 2015. ISBN 978-80-251-4352-0.
-
LACKO, L. 1001 tipů a triků pro SQL. Brno: Computer Press, 2011, 416 s., 2011. ISBN 978-80-251-3010-0.
-
LAURENČÍK, Marek. SQL: podrobný průvodce uživatele [online].. Praha: Grada Publishing, 2018. ISBN 978-80-271-0774-2.
-
POKORNÝ, Jaroslav a Michal VALENTA. Databázové systémy. Praha: České vysoké učení technické v Praze, 2013. ISBN 978-80-0105-212-9.
-
ROCKOFF, Larry. The language of SQL. Boston, MA: Course Technology Cengage Learning, c2011, xiv, 239 p., 2011. ISBN 978-143-5457-515.
|