Skip to main content
Skip header
Close

Searching

Databases

Databases
157-0392/01
čeština

Summary

The aim of the subject is to acquire basic knowledge and skills in the area of design and implementation of relational database applications. The subject should familiarize students with the SQL language and with basic database objects such as table, view, stored procedure or trigger. Students will verify acquired knowledge on the DBMS Microsoft Office Access and Microsoft SQL Server.

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
Language of instruction čeština
Code 157-0392
Abbreviation DBS
Course title Databases
Coordinating department Department of Systems Engineering and Informatics
Course coordinator Ing. Vítězslav Novák, Ph.D.