| Course Unit Code | 155-0331/03 |
|---|
| Number of ECTS Credits Allocated | 6 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 course is to obtain basic knowledge and skills in the design and implementation of the database applications. The course should introduce students to the SQL and Visual Basic for Applications languages and to the basic database objects such as table, view, stored procedure, or trigger. Students will practice their knowledge with help of the DBMS Microsoft Office Access and Microsoft SQL Server. |
| Learning Outcomes of the Course Unit |
|---|
Understand the fundamental principles of the relational databases.
Design relational databases.
Use commands SELECT, INSERT, UPDATE and DELETE of language SQL.
Create database applications in Microsoft Office Access and SQL Server.
Use the programming language Visual Basic for Application on a simple level. |
| Course Contents |
|---|
Lectures:
1) Data modeling and design of data structures.
2) Normalization of relations.
3) Microsoft Office Access.
4) SQL, Data Definition Language.
5) SQL, Data Manipulation Language, SELECT statement I.
6) SQL, Data Manipulation Language, SELECT statement II.
7) SQL, Data Manipulation Language, INSERT, UPDATE, DELETE statements.
8) Fundamentals of Visual Basic for Application I.
9) Fundamentals of Visual Basic for Application II.
10) Microsoft Access Objects, Microsoft ActiveX Data Objects.
11) Microsoft SQL Server.
12) Transaction.
13) Programmable database objects - views, stored procedures, triggers.
14) Database administration- security, backup, restore of the database.
Tutorials:
Practical training with DBMS. |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
GROH, Michael R. Access 2010 bible. 1st Ed. Indianapolis, IN: Wiley Publishing, 2010. ISBN 978-0470475348.
ROCKOFF, Larry. The Language of SQL: How to Access Data in Relational Databases. Boston, MA: Cengage Learning, 2010. ISBN 978-1435457515. |
KRUCZEK, Aleš. Microsoft Access 2010: podrobná uživatelská příručka. Brno: Computer Press, 2010. 392 s. ISBN 978-80-251-3289-0.
HOTEK, Mike. Microsoft SQL Server 2008 krok za krokem. Brno: Computer Press, 2009. 488 s. ISBN 978-80-251-2466-6. |
| Recommended Reading: |
|---|
HARRINGTON, Jan L. Relational database design and implementation: clearly explained. 3rd ed. Boston: Morgan Kaufmann/Elsevier, 2009. ISBN 978-0-12-374730-3.
CONNOLLY, Thomas M a Carolyn E BEGG. Database systems: a practical approach to design, implementation, and management. 5th ed. London: Addison-Wesley, 2010. ISBN 978-0-321-52306-8. |
PÍSEK, Slavoj. Access 2010 : podrobný průvodce. Praha: Grada Publishing, 2011. 160 s. ISBN 978-80-247-3653-2.
WALTERS, Robert E. Mistrovství v Microsoft SQL Server 2008: [kompletní průvodce databázového experta]. Brno: Computer Press, 2009. 864 s. ISBN 978-80-251-2329-4.
SHEPHERD, Richard. Access VBA: výukový průvodce. Brno: Computer Press, 2012. 397 s. ISBN 978-80-251-3686-7.
|
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials |
| 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 | 25 |
| Examination | Examination | 55 | 10 |