Terminated in academic year 2020/2021

Basics of Database Systems

Type of study	Bachelor
Language of instruction	Czech
Code	155-0331/02
Abbreviation	ZD
Course title	Basics of Database Systems
Credits	6
Coordinating department	Department of Applied Informatics
Course coordinator	Ing. Vítězslav Novák, Ph.D.

Subject syllabus

Lectures:
1) Data modeling and design of data structures.
2) Normalization of relations.
3) Microsoft Office Access.
4) SQL, Data Definition Language.
5) SQL, Data Manipulation Language, SELECT statement I.
6) SQL, Data Manipulation Language, SELECT statement II.
7) SQL, Data Manipulation Language, INSERT, UPDATE, DELETE statements.
8) Fundamentals of Visual Basic for Application I.
9) Fundamentals of Visual Basic for Application II.
10) Microsoft Access Objects, Microsoft ActiveX Data Objects.
11) Microsoft SQL Server.
12) Transaction.
13) Programmable database objects - views, stored procedures, triggers.
14) Database administration- security, backup, restore of the database.

Tutorials:
Practical training with DBMS.

E-learning

Přednášky a cvičení jsou ve formátu PDF v LMS Moodle.

Literature

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

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.

back to search page