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.
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 .
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 .
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 .