460-2011 – Data Processing Theory (TZD)
| Gurantor department | Department of Computer Science |
| Subject guarantor | doc. Ing. Radim Bača, Ph.D. |
| Study level | undergraduate or graduate |
Subject aims expressed by acquired skills and competences
Main goal is to introduce the basic database concepts such as the relational model and the SQL language. The students who finish this course will be able to specify the conceptual model and the relational scheme of an information system and they will have a deep knowledge about the basic SQL commands according to the SQL92 standard.
Teaching methods
Lectures
Tutorials
Experimental work in labs
Summary
This course is a basic introduction into database technologies. The main topics are the conceptual modeling, the relational data model and the SQL language for data definition, manipulation and querying.
Compulsory literature:
* C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003.
* DBMS Oracle Documenation
Recommended literature:
* H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.