| Course Unit Code | 155-0306/03 |
|---|
| Number of ECTS Credits Allocated | 5 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | First Year |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| NOV21 | Ing. Vítězslav Novák, Ph.D. |
| DAN11 | Ing. Roman Danel, Ph.D. |
| 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. |
| Learning Outcomes of the Course Unit |
|---|
| 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. |
| Course Contents |
|---|
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. |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
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.
VYSTAVĚL, Radek. Databáze a SQL pro začátečníky. Ondřejov: Radek Vystavěl, 2021. ISBN 978-80-908144-0-0.
POKORNÝ, Jaroslav a VALENTA, Michal. Databázové systémy. 2. přepracované vydání. Praha: Česká technika - nakladatelství ČVUT, 2020. ISBN 978-80-01-06696-6. |
| Recommended Reading: |
|---|
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. |
LAURENČÍK, Marek. Excel 2016 a 2019: pokročilé nástroje : funkce, databáze, kontingenční tabulky, prezentace, příklady. Průvodce (Grada). Praha: Grada Publishing, 2020. ISBN 978-80-271-2471-8.
BEN-GAN, Itzik. T-SQL Fundamentals (Developer Reference. Redmont, Microsoft Press, 2023. ISBN 978-0138102104.
CORORNEL, Carlos and MORRIS, Steven. Database Systems: Design, Implementation, & Management (MindTap Course List). 14th Edition. Boston: Cengage Learning, 2022. ISBN 978-0357673034. |
| Planned learning activities and teaching methods |
|---|
| Lectures, Experimental work in labs, Project work |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Credit and Examination | Credit and Examination | 100 (100) | 51 |
| Credit | Credit | 45 | 23 |
| Examination | Examination | 55 | 28 |