460-2035 – Introduction to Database Systems (UDBS)

Gurantor departmentDepartment of Computer Science
Subject guarantordoc. Ing. Radim Bača, Ph.D.
Study levelundergraduate or graduate
Subject version
Version codeYear of introductionYear of cancellationCredits
460-2035/01 2011/2012 2014/2015 6
460-2035/02 2014/2015 6
460-2035/03 2015/2016 6

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.