| 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: |
|---|
WEINBERG, Paul N., James R. GROFF, Andrew J. OPPEL a James R. GROFF. SQL, the complete reference. 3rd ed. New York: McGraw-Hill, 2010. ISBN 978-0071592550.
ALEXANDER, Michael. Access 2019 Bible. Indianapolis, IN: John Wiley, 2018. ISBN 978-1119514756. |
BELKO, Peter. Microsoft Access 2013: podrobná uživatelská příručka. Brno: Computer Press, 2014. ISBN 978-80-251-4125-0.
GROFF, James R. SQL: kompletní průvodce. Brno: CP Books, 2005. ISBN 80-251-0369-2.
LAURENČÍK, Marek. SQL: podrobný průvodce uživatele. Praha: Grada Publishing, 2018. ISBN 9788027107742. |
| Recommended Reading: |
|---|
CONNOLLY, Thomas M. a Carolyn E. BEGG. Database systems: a practical approach to design, implementation, and management. 5th ed. Boston: Addison-Wesley, 2010. ISBN 978-0-321-52306-8.
BEN-GAN, Itzik. T-SQL fundamentals. Redmond, WA: Microsoft Press, 2016. ISBN 978-1509302000. |
SHEPHERD, Richard. Access VBA: výukový průvodce. Brno: Computer Press, 2012. ISBN 978-80-251-3686-7.
LACKO, Ľuboslav. 1001 tipů a triků pro SQL. Brno: Computer Press, 2011. 416 s. ISBN 978-80-251-3010-0.
CONNOLLY, Thomas M. a Carolyn E. BEGG. Database systems: a practical approach to design, implementation, and management. 5th ed. Boston: Addison-Wesley, 2010. ISBN 978-0-321-52306-8. |
| 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 |