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.
Knowledge of data modelling are required.
Recommended optional programme components
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
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)
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
Elaboration the project - a project by entering the appropriate documentation. The project proposition is introduced to students in the second lecture.
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
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