155-0438/02 – Programming in Database Environment (PRGDB)
| Gurantor department | Department of Applied Informatics | Credits | 3 |
| Subject guarantor | Ing. Vítězslav Novák, Ph.D. | Subject version guarantor | Ing. Vítězslav Novák, Ph.D. |
| Study level | undergraduate or graduate | Requirement | Choice-compulsory |
| Year | 2 | Semester | winter |
| | Study language | Czech |
| Year of introduction | 2006/2007 | Year of cancellation | 2011/2012 |
| Intended for the faculties | EKF | Intended for study types | Follow-up Master |
Subject aims expressed by acquired skills and competences
Understand the fundamental principles of the relational databases.
Use commands SELECT, INSERT, UPDATE and DELETE of language SQL.
Create database applications in Microsoft Office Access.
Use the programming language Visual Basic for Application on a simple level.
Teaching methods
Lectures
Tutorials
Project work
Summary
Předmět by měl seznámit studenty hlavně se základy návrhu a tvorby relačních
databází a se základy jazyka SQL jako základního jazyka pro manipulaci s daty.
Student by se měl dále naučit vytvářet grafické uživatelské rozhraní nad
databází.
Vše bude prezentováno na databázovém systému Microsoft Access.
Compulsory literature:
Recommended literature:
... and anything else about MS Access, VBA and SQL.
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:
1) Fundamental principles of the relational databases.
2) Creating and editing tables in Microsoft Office Access.
3) Data Definition Language of the SQL.
4) Creating queries in Microsoft Office Access.
5) Command SELECT of the SQL.
6) Forms in Microsoft Office Access.
7) Reportsin Microsoft Office Access.
8) Basics of the Visual Basic for Application.
9) Microsoft Access Objects.
10) Commands INSERT, UPDATE and DELETE of the SQL.
11) Microsoft ActiveX Data Objects.
12) Finishing of a database application.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.