Logo ČVUT
Loading...
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2011/2012

Databases 2

Login to KOS for course enrollment Display time-table
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:
Generated on 2012-7-9
For updated information see http://bilakniha.cvut.cz/en/predmet24615805.html