Database Query Languages

Database Query Languages
545-0087/01
čeština

Course aims

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.

Literature

SCHNEIDER, R. D.: MySQL: oficiální průvodce tvorbou, správou a laděním databází, 2006, Praha: Grada Publishing, 372 s. ISBN 80-247-1516-3.
HERNANDEZ, M. J.; VIESCAS, J.: Myslíme v jazyku SQL: Tvorba dotazů, 2004, Praha: Grada Publishing, 378 s.
ISBN 80-247-0899-X.
GRUBER, M.: Mistrovství v SQL. 1. a 2. díl, 2002, SoftPress. ISBN 80-86497-62-3

Advised literature

MySQL 5.0 - Certification Study Guide

back to search page

Language of instruction	čeština
Code	545-0087
Abbreviation	DDJ
Course title	Database Query Languages
Coordinating department	Department of Economics and Control Systems
Course coordinator	Ing. Filip Beneš, Ph.D.