|
Lecturer(s)
|
-
Machalík Stanislav, Ing. Ph.D.
-
Drvota Zdeněk, Ing.
|
|
Course content
|
Basic concepts of databases. Relational databases. Basics of working with Microsoft Access. Creating a database. Creating tables. Relationships between tables, referential integrity. Work with data. Database server. SQL language. DDL, DML modules. Data types. Basic commands. Operators. SQL functions. NULL value. Database design phase. Session. E-R diagrams. Normal forms and normalization. Decomposition. Integrity constraints. Primary and foreign keys. SELECT statement. Projection. Restriction. Inner, outer join. Aliases. INSERT, UPDATE, DELETE. Group aggregations. Sort the query result. Nested queries. Views. Transactions. Indexes. Sequence. Data security and protection. User accounts. Authorization. Semester work, analysis, evaluation, reserve.
|
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Demonstration, Skills training
- Home preparation for classes
- 90 hours per semester
- Practical training
- 90 hours per semester
|
|
Learning outcomes
|
The main goal of course is to familiarise students with the principles of creating and using databases, to practically master the design of a database and the basics of working with the SQL language.
Students will learn the principles of creating and using databases, practically master database design and the basics of working with SQL.
|
|
Prerequisites
|
The basic knowledge of Microsoft Windows operating system and Microsoft Word and Excel, and basic knowledge of structured programming.
|
|
Assessment methods and criteria
|
Written examination, Home assignment evaluation
The condition for granting a credit is active work during the seminars, passing two tests and the submission of seminary work. The oral exam, for full-time and part-time study, is determined in accordance with the UP Study and Examination Regulations. More up-to-date information can be found in the document, which will be available for download in IS STAG.
|
|
Recommended literature
|
-
Dokumenta k databázovému softwaru.
-
Průběžně doplňované materiály z přednášek, úlohy cvičení, zveřejňované na internetu a ve studijní agendě STAG.
-
Kruczek, Aleš. Microsoft Office Access 2007 : podrobná uživatelská příručka. Brno: Computer Press, 2007. ISBN 978-80-251-1608-1.
-
Lacko, Luboslav. Oracle : správa, programování a použití databázového systému. Brno: Computer Press, 2007. ISBN 978-80-251-1490-2.
-
Oppel, Andrew J. Databáze bez předchozích znalostí : [průvodce pro samouky]. Brno: Computer Press, 2006. ISBN 80-251-1199-7.
-
Šimůnek, Milan. SQL : kompletní kapesní průvodce. Praha: Grada, 1999. ISBN 80-7169-692-7.
|