Course detail

Information and Data

FP-IDAcad. year: 2013/2014

The course focuses especially on the following topics: Introduction to database systems. Relational database system. Data types, organization and storage of data, work with data, indexes, fundamentals of SQL language queries. Analytical services. Security and data protection.

Language of instruction

Czech

Number of ECTS credits

3

Mode of study

Not applicable.

Guarantor

Ing. Jiří Kříž, Ph.D.

Department

Institute of Informatics (ÚI)

Learning outcomes of the course unit

Students will acquire basic knowledge regarding database systems including up-to-date trends in the database technologies development. They will master fundamental principles and skills in the work with SQL language namely the queries creation and their interpretation. They will acquire the knowledge of the data protection with respect to the security as well as legislation, including the problems of an electronic signature.

Prerequisites

Knowledge of Windows XP operating system and competence in Microsoft Office (Word, Excel, Access, FrontPage, PowerPoint).

Co-requisites

Not applied.

Planned learning activities and teaching methods

Exercises promote the practical mastery of subject presented in lectures or assigned for individual study with the active participation of students.

Assesment methods and criteria linked to learning outcomes

Conditions for awarding the course-unit credit:
1. Active participation in the exercises and control of elaborated partial tasks in three pre-set deadlines – max. 100 points. Total number of points for awarding the course-unit credit has to be higher than 50.

Course curriculum

Topics of the workshop is as follows:
Introduction to database systems, database as an information source
Relational database management system, data types, work with data and structures indexes
The query language SQL
Simple queries, grouping queries (aggregate functions, cross queries, pivot tables, special cases of clustering tasks)
Summaries using data cubes
Presentation of the results of queries
Legislation governing the protection and security of data in the Czech legislation
Electronic Signature

Work placements

Not applicable.

Aims

The main objective of the course is to make students familiar with the basic questions related to database systems and data access. Also dealt with is the basic theory of relational database systems as well as acquirement of practical skills in data access and use of databases as a source of information. Also discussed are the topics related to the data security from the IS/IT security point of view as well as from the point of view of legal regulations valid in the Czech Republic.

Specification of controlled education, way of implementation and compensation for absences

Control of results of independent work on the assigned tasks. In case of excused absence from seminars, the teacher can set an additional condition if appropriate, usually elaboration of supplementary task.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

PÍSEK, S.: Access 2003, Praha. Grada 2004, ISBN 80-247-0787-X (CS)
SMEJKAL, V., RAIS, K.: Řízení rizik, Praha, Grada 2003, 263 s., ISBN 80-247-0198-7 (CS)
STEPHENS, R.K., PLEW R.R.: Naučte se SQL za 21 dní. Brno, Computer Press 2004, 491 s., ISBN 80-722-6870-8 (CS)
VOGLOVÁ, B.: Access v kanceláři, Praha. Grada 2002, ISBN 80-247-0321-1 (CS)

Recommended reading

ŠEBESTA, O.: Hledáme na Internetu, Praha, Grada 2001, ISBN 80-247-0011-5 (CS)
ŠIMŮNEK M.: SQL kompletní kapesní průvodce. Praha, Grada 1999, 244 s., ISBN 80-7169-692-7 (CS)

Classification of course in study plans

  • Programme BAK Bachelor's

    branch BAK-DP , 2 year of study, winter semester, compulsory

Type of course unit

 

Computer-assisted exercise

26 hod., optionally

Teacher / Lecturer

Ing. Jiří Kříž, Ph.D.

Syllabus

Topics of lectures are the following:
Introduction to the database systems, database as an information source.
Relational database system, data types, work with data and structures of indexes
SQL query language
Simple queries, aggregate queries (aggregate function, cross queries, contingency tables, special cases of aggregate tasks)
Aggregates by means of data blocks
Presentation of the query results
Data backup, filing and compression
Use of the Internet as an informatin source
Legislation in the Czech Republic governing the data protection and security
Electronic signature