545-0087/01 – Database Query Languages (DDJ)
| Gurantor department | Department of Economics and Control Systems | Credits | 5 |
| Subject guarantor | Ing. Filip Beneš, Ph.D. | Subject version guarantor | Ing. Filip Beneš, Ph.D. |
| Study level | undergraduate or graduate | Requirement | Compulsory |
| Year | 2 | Semester | winter |
| | Study language | Czech |
| Year of introduction | 2015/2016 | Year of cancellation | 2020/2021 |
| Intended for the faculties | HGF | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
The course introduces students to the basics of working with relational databases through SQL structured and develops their skills in analysis, design, construction and subsequent management of relational database applications.
In practice lessons students learn the practices of working with relational databases in MySQL and Microsoft SQL Server via SQL. At the end of the semester students elaborate projects aimed at implementing a simple relational databases and manipulate data using SQL.
Teaching methods
Lectures
Individual consultations
Tutorials
Summary
Compulsory literature:
Recommended literature:
MySQL 5.0 - Certification Study Guide
Additional study materials
Way of continuous check of knowledge in the course of semester
E-learning
Other requirements
Student has to elaborate individual programs.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
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
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction