Terminated in academic year 2018/2019

Database Systems

Type of study	Bachelor
Language of instruction	Czech
Code	545-0117/06
Abbreviation	DBS
Course title	Database Systems
Credits	5
Coordinating department	Department of Economics and Control Systems
Course coordinator	Ing. Filip Beneš, Ph.D.

Subject syllabus

1. Introduction to databases, types of databases
2. Data types in relational databases
3. Tables + CRUD (SQL)
4. Design of relational databases - ERD models
5. Access to data, ODBC, ADO, DTS
6. Indexes
7. Stored procedures, triggers, views, cursors
8. Transaction
9. Databases safety and backups
10. NoSQL databases
11. Object databases, Caché
12. Big Data
13. Data analyses, introduction to BI
14. Transact-SQL

Literature

1. SIMSION, G.; WEST, M.; WITT, G.: Data Modeling Essential. Elsevier Science & Technology, 2004, 560 pages, .
2. BALTER, A.: Access 2013 Absolute Beginner’s Guide. Pearson Education, Inc., 2013, 388 pages, .

Advised literature

1. VINE, M.: Microsoft Access VBA Programming for the Absolute Beginner. Thomson Course Technology, 2002, 328 pages, .

back to search page