SCHNEIDER, R. D.: MySQL: oficiální průvodce tvorbou, správou a laděním databází, 2006, Praha: Grada Publishing, 372 s. ISBN 80-247-1516-3.
HERNANDEZ, M. J.; VIESCAS, J.: Myslíme v jazyku SQL: Tvorba dotazů, 2004, Praha: Grada Publishing, 378 s.
ISBN 80-247-0899-X.
GRUBER, M.: Mistrovství v SQL. 1. a 2. díl, 2002, SoftPress. ISBN 80-86497-62-3
Terminated in academic year 2020/2021
Database Query Languages
| Type of study | Bachelor |
|---|---|
| Language of instruction | Czech |
| Code | 545-0087/01 |
| Abbreviation | DDJ |
| Course title | Database Query Languages |
| Credits | 5 |
| Coordinating department | Department of Economics and Control Systems |
| Course coordinator | Ing. Filip Beneš, Ph.D. |
Subject syllabus
1. Introduction, relational databases
2. SQL language commands
3. SELECT, agregation, sorting
4. Data manipulation language - INSERT, UPDATE, DELETE
5. Transaction
6. Advaced query
7. DDL – – DROP, ALTER, CREATE, GRANT, database administration
8. VIEW
9. Triggers
10. Integrity – indexes, constraints, rules…
11. Stored procedures - basic programing concepts
12. Data access method – ODBC, ADO, RDO, …
13. Export/import from SQL server
2. SQL language commands
3. SELECT, agregation, sorting
4. Data manipulation language - INSERT, UPDATE, DELETE
5. Transaction
6. Advaced query
7. DDL – – DROP, ALTER, CREATE, GRANT, database administration
8. VIEW
9. Triggers
10. Integrity – indexes, constraints, rules…
11. Stored procedures - basic programing concepts
12. Data access method – ODBC, ADO, RDO, …
13. Export/import from SQL server
Literature
Advised literature
MySQL 5.0 - Certification Study Guide