Databases 2
Code | Completion | Credits | Range | Language |
---|---|---|---|---|
818DB2 | Z | 2 | 0+2 | Czech |
- Lecturer:
- Dana Majerová (gar.)
- Tutor:
- Dana Majerová (gar.)
- Supervisor:
- Synopsis:
-
Database languages, SQL. Manipulation of tables: CREATE, ALTER, DROP. Manipulation of data: INSERT, UPDATE, DELETE. Queries (SELECT). Relational algebra. Aggregate functions. GROUP BY in queries. VIEW and PROCEDURE creating. Optimization of SQL queries.
- Requirements:
-
Credit of 818DB1 course.
- Syllabus of lectures:
-
1. database languages (DDL, DML, DCL), SQL and its properties
2. database system as set of tables and integrity constraints (domain, entity and referential integrity), basic data types
3. DDL - working with domains and tables
4. DML - data insert, update and delete
5. operators and their usage
6. DML - queries, SELECT statement
7. relational algebra, table join
8. sets, aggregation
9. views I
10. views II
11. procedures I
12. procedures II
13. database realization of selected E-R model
- Syllabus of tutorials:
-
1. database languages (DDL, DML, DCL), SQL and its properties
2. database system as set of tables and integrity constraints (domain, entity and referential integrity), basic data types
3. DDL - working with domains and tables
4. DML - data insert, update and delete
5. operators and their usage
6. DML - queries, SELECT statement
7. relational algebra, table join
8. sets, aggregation
9. views I
10. views II
11. procedures I
12. procedures II
13. database realization of selected E-R model
- Study Objective:
-
Knowledge of SQL.
Ability to realize any database given by E-R diagram in any relational database system supporting SQL (eg. Firebird, MySQL).
- Study materials:
-
Key references:
[1] Císař, P. InterBase/FireBird. Brno: Computer Press, 2003.
[2] Pokorný, J., Halaška, J. Databázové systémy. Praha: ČVUT, 1998.
[3] Pokorný, J., Halaška, J. Databázové systémy: vybrané kapitoly a cvičení. Praha: ČVUT, 1997.
Recommended references:
[4] Šimůnek, M. SQL - kompletní kapesní průvodce. Praha: GRADA Publishing, 1999.
[5] Chudějová, E. SQL - Strukturovaný dotazovací jazyk a jeho implementace v databázovém systému PROGRESS. Praha: VŠE, Fakulta informatiky a statistiky, 1997.
- Note:
- Time-table for winter semester 2011/2012:
- Time-table is not available yet
- Time-table for summer semester 2011/2012:
- Time-table is not available yet
- The course is a part of the following study plans: