|
Vyučující
|
-
Fišer Jiří, Mgr. Ph.D.
-
Sýkorová Květuše, Mgr.
|
|
Obsah předmětu
|
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
|
|
Studijní aktivity a metody výuky
|
|
nespecifikováno
|
|
Výstupy z učení
|
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.
|
|
Předpoklady
|
basics of procedural programming (loops, procedures), elementary data types (numbers, string, booleans)
|
|
Hodnoticí metody a kritéria
|
nespecifikováno
preparation and oral defense of a seminar work aimed at database design and its implementation, verification of general factual knowledge
|
|
Doporučená literatura
|
|