Skip to main content
Skip header

Basics of Database Systems

Summary

The aim of the course is to obtain basic knowledge and skills in the design and implementation of the database applications. The course should introduce students to the SQL and Visual Basic for Applications languages and to the basic database objects such as table, view, stored procedure, or trigger. Students will practice their knowledge with help of the DBMS Microsoft Office Access and Microsoft SQL Server.

Literature

GROH, Michael R. Access 2010 bible. 1st Ed. Indianapolis, IN: Wiley Publishing, 2010. ISBN 978-0470475348 .
ROCKOFF, Larry. The Language of SQL: How to Access Data in Relational Databases. Boston, MA: Cengage Learning, 2010. ISBN 978-1435457515 .

Advised literature

HARRINGTON, Jan L. Relational database design and implementation: clearly explained. 3rd ed. Boston: Morgan Kaufmann/Elsevier, 2009. ISBN 978-0-12-374730-3.
CONNOLLY, Thomas M a Carolyn E BEGG. Database systems: a practical approach to design, implementation, and management. 5th ed. London: Addison-Wesley, 2010. ISBN 978-0-321-52306-8.


Language of instruction čeština, čeština, čeština
Code 155-0331
Abbreviation ZD
Course title Basics of Database Systems
Coordinating department Department of Applied Informatics
Course coordinator Ing. Vítězslav Novák, Ph.D.