155-0331/01 – Basics of Database Systems (ZD)
| Gurantor department | Department of Applied Informatics | Credits | 3 |
| Subject guarantor | Ing. Vítězslav Novák, Ph.D. | Subject version guarantor | doc. Ing. Ludmila Kalužová, CSc. |
| Study level | undergraduate or graduate | Requirement | Choice-compulsory |
| Year | 3 | Semester | winter |
| | Study language | Czech |
| Year of introduction | 2003/2004 | Year of cancellation | 2008/2009 |
| Intended for the faculties | EKF | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
Understand the fundamental principles of the relational databases.
Design relational databases.
Use commands SELECT, INSERT, UPDATE and DELETE of language SQL.
Create database applications in Microsoft Office Access and SQL Server.
Use the programming language Visual Basic for Application on a simple level.
Teaching methods
Lectures
Tutorials
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.
Compulsory literature:
Recommended literature:
Way of continuous check of knowledge in the course of semester
E-learning
Other requirements
No other requirements.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
Bude doplněno ..................
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.