Course detail

FP-RDAcad. year: 2020/2021

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.

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 are required.

Co-requisites

Not applicable.

Recommended optional programme components

Not applicable.

Recommended or required reading

LACKO, L. Microsoft SQL Server 2008, správa,konfigurace, programování. Brno, Computer Press 2009, 469 s., ISBN 978-80-251-2101-6
PRATT, PHILIP J.; LAST, MARY Z. A Guide to SQL, Cengage Learning, Inc 2014, 360s., ISBN 9781111527273
HOTEK, M. SQL Server 2008, krok za krokem. Brno, Computer Press, 2009, 488 s. ISBN 978-80-251-2466-6.
STEPHENS, R.K. a R.R. PLEW. Naučte se SQL za 21 dní. Brno, Computer Press 2004, 491 s., ISBN 80-722-6870-8
TURLEY, P. Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports, John Wiley & Sons Inc 2017, 816 s. ISBN 9781119258353

Planned learning activities and teaching methods

The course contains lectures that explain basic principles, problems and methodology of the discipline, and exercises that promote the practical knowledge of the subject presented in the lectures.

Assesment methods and criteria linked to learning outcomes

Course completion
Prerequisites:
Student has to obtainat least 50% of the possible maximum during the semester (20 points of 40).
If would be detected plagiarism or unauthorized collaboration on projects, or at mid-term test, credit will be granted with consideration of disciplinary proceedings.
Mid-term test - writing, (answers could be by selecting one of several posibilities, sentence answers or a combination thereof) and developing practical task by submission. There is no trial. (20 points)
Development of the project - one project by entering the appropriate documentations. The submission is presented to students in the second lecture. (20 points)
Test conditions:
Final exam - written form, a test (answers could be by selecting one of several posibilities, sentence answers or a combination thereof) and an oral examination. (60 points for the written part of the exam, the successful completion of the exam, written exam has to be written to be evaluated by at least 30 points, otherwise the test is scored 0 points with the evaluation of F.)

Course completion for students with individual study
Prerequisites:
Elaboration the project - a project by entering the appropriate documentation. The project proposition is introduced to students in the second lecture.
Test conditions:
Final exam - written test form (correct answers could be by selecting one of several sentence answers or a combination thereof) and an oral examination. (60 points for the written part of the exam; for the successful completion of the exam must be written exam developed to be evaluated by at least 30 points, otherwise the test is scored 0 points with the evaluation of F.)

Language of instruction

Czech

Work placements

Not applicable.

Aims

The main objective of the course is to make students familiar with the basic methods of relational databases, their design and development, the role of architecture in IS / ICT, implementation and skill ss query language SQL.

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

Attendance at lectures is not compulsory. Seminars with computer support is required, attendance is controled. One absence from seminars, teacher apologize. Student will replace this lack of elaboration especially given homework.

Classification of course in study plans

  • Programme BAK-MIn Bachelor's, 2. year of study, winter semester, 6 credits, compulsory

Type of course unit

 

Lecture

26 hours, optionally

Teacher / Lecturer

Exercise

26 hours, compulsory

Teacher / Lecturer

eLearning