Course detail

Database Systems

FP-DBSAcad. year: 2012/2013

The course focuses especially on the following topics: History of database systems, architecture of database management systems. SQL server – general overview. Relational database system. Data types, data organization and storage, indexes, SQL language, Creation and connection of tables. Limitation of tables and normalization. Transactions, locks and saved operations. Use of databases in the internet. XML technology. Analytical services. Security.

Language of instruction

Czech

Number of ECTS credits

7

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 of and skills in the work with SQL language by means of creation of database application for relational databases in the client/server environment and in the Internet.

Prerequisites

Knowledge of data modelling, algorithmization and programming techniques as well as fundamentals of HTML language.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Teaching methods depend on the type of course unit as specified in the article 7 of BUT Rules for Studies and Examinations.

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. 45 points. 2. Presentation of semester work – max 15 points. 3. Total number of points for awarding the course-unit credit has to be higher than 50
Conditions for passing an exam: Knowledge of taught topics and its practical application.
Form of examination: Combined – a written test on theoretical topics and practical solution of the assigned task.

Course curriculum

Not applicable.

Work placements

Not applicable.

Aims

The main objective of the course is to make students familiar with the basic methods of the designing and creation of database applications. Also dealt with is the basic theory of relational database systems as well as acquirement of practical skills in creation of applications and data access including creation of database applications within Internet and database systems administration.

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

BRUST, A.J.: Mistrovství v programování SQL Serveru 2005. Brno, Computer Press 2007, 833str., ISBN 978-80-251-1607-4 (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)
VIEIRA, R.: SQL Server 2000 – programujeme profesionálně. Praha, Computer Press 2001, 1105 s., ISBN 80-7226-506-7 (CS)

Recommended reading

LACKO L.: Web a databáze. Praha, Computer Press, 2001, 247 s., ISBN 80-7226-555-5 (CS)
MORKES D.: SQL Server 2000 – tvorba, úprava a správa databází. Praha, Grada 2004, 225 s., ISBN 80-247-0732-2 (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-MIn Bachelor's

    branch BAK-MIn , 1 year of study, summer semester, compulsory

Type of course unit

 

Lecture

26 hod., optionally

Teacher / Lecturer

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

Syllabus

Topics of lectures are the following:
History of database systems, SQL server 2000
Relational database system, data types, data storage and structures of indexes
T-SQL language commands
Creation of tables, their changes, connections, limitations and normalization.
Views, saved operations
Transactions and locks
Releases
Advanced queries
Analytical services of SQL server
Data security
Creation of database applications in the Internet, creation of dynamic HTML
XML technology
New trends in database technologies

Computer-assisted exercise

26 hod., compulsory

Teacher / Lecturer

Ing. Jan Luhan, Ph.D., MSc

Syllabus

The seminars are focused on practising the lectured topics and elaboration of assigned tasks.