|
Lecturer(s)
|
-
Fišer Jiří, Mgr. Ph.D.
-
Sýkorová Květuše, Mgr.
|
|
Course content
|
1. Relational databases (principles) and relational database systems (overview and classification) 2. Principles of conceptual design (entities, attributes and relational relationships, ERD) 3. Candidate keys and database normalization (normal forms) 4. DDL - commands for working with tables (CREATE, ALTER, DROP, data types and integrity constraints) 5. DML - commands for working with data (INSERT, UPDATE, DELETE) 6. Elementary SELECT statement (SELECT, FROM, WHERE, ORDER BY) 7. Relationships between tables and their representation 8. Internal joins (INNER JOIN) 9. OUTER JOIN and other types of joins 10. Grouping (GROUP BY, HAVING) and aggregation functions 11. Transactions 12. - 13. Basic programming access to databases
|
|
Learning activities and teaching methods
|
|
unspecified
|
|
Learning outcomes
|
This course provides a practical introduction to the design and basic implementation of relational databases. Students will learn about the conceptual and logical design of relational databases (including representations of relationships) and the basics of SQL Exercises will focus on the conceptual design of sample databases.
|
|
Prerequisites
|
basics of procedural programming (loops, procedures), elementary data types (numbers, string, booleans)
|
|
Assessment methods and criteria
|
unspecified
preparation and oral defense of a seminar work aimed at database design and its implementation, verification of general factual knowledge
|
|
Recommended literature
|
|