Skip to main content
Skip header
Close

Searching

Databases

Type of study Bachelor
Language of instruction Czech
Code 157-0392/01
Abbreviation DBS
Course title Databases
Credits 6
Coordinating department Department of Systems Engineering and Informatics
Course coordinator Ing. Vítězslav Novák, Ph.D.

Subject syllabus

1. Data modeling and design of data structures.
2. Relationships' normalization.
3. Creation of tables in the design view of MS Access.
4. SQL - Data Definition Language.
5. Selection queries in the design view of MS Access.
6. SQL - SELECT command.
7. Built-in SQL functions and views.
8. GUI creation in Access - forms and reports.
9. SQL - INSERT, UPDATE, DELETE commands.
10. Transactions.
11. Programmable SQL objects - user functions, stored procedures and triggers.
12. Creating a database application in MS Access.

E-learning

Students have all presentations, assignments and exercises data in LMS Moodle.

Literature

CORORNEL, Carlos and MORRIS, Steven. Database Systems: Design, Implementation, & Management (MindTap Course List). 14th Edition. Boston: Cengage Learning, 2022. ISBN 978-0357673034 .
KOROL, Judita. Access 2021 / Microsoft 365 Programming by Example. Herndon, Mercury Learning and Information, 2022. ISBN 978-1683928416 .
BEN-GAN, Itzik. T-SQL Fundamentals (Developer Reference. Redmont, Microsoft Press, 2023. ISBN 978-0138102104 .

Advised literature

DEBARROS, Anthony. Practical SQL: A Beginner's Guide to Storytelling with Data. San Francisco, No Starch Press, 2022. ISBN 978-1718501065 .
GEORGE, Nathan. Mastering Access 365: An Easy Guide to Building Efficient Databases for Managing Your Dat. Redmond, GTech Publishing, 2022. ISBN 978-1916211391 .
SYVERSON, Bryan and MURACH, Joel. Murach's SQL Server 2022 for Developers. Fresno: Mike Murach and Associates, 2023. ISBN 978-1943873067 .


back to search page