Czech

Not applicable.

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.

Knowledge of data modelling are required.

Not applicable.

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.

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.)

Not applicable.

Not applicable.

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.

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.

Not applicable.

Not applicable.

HOTEK, M. SQL Server 2008, krok za krokem. Brno, Computer Press, 2009, 488 s. ISBN 978-80-251-2466-6.
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

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