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.

Prerequisities are the knowledge of data modeling, algorithms and programming techniques.

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.

Prerequisites:
Student has to obtain at 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.)

Topics of lectures is as follows:
- History of Database Systems
- Relational database management system, data types, data storage and index structures
- Language commands T-SQL
- Creating tables and their changes, mergers, restrictions and normalization
- Views, Stored Procedures
- Transactions and Locks
- Triggers
- Advanced queries
- SQL Server Analysis Services
- The practical part of the training is done in MS SQL Server.
- Backup and data replication
- Data Security
- XML Technology
- New trends in database technology

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.

Seminars with computer support are focused on teaching features and tools of MS SQL Server including query language SQL. During the semester, steudent writes semester test for maximum of 20 points. For this semester test is no trial. If a student has a well-documented and excused absence for the semester test by teacher, he/she can sign on an alternative date.

In the second lecture is given separate project for a maximum of 20 points to students. To accept this project, student has to obtain min. 10 points. The project student submits in the credit week.
Students who have an individual learning plan (ie. they do not go into lectures) must prepare and submit a special individual project for the credit. For this particular project can get 30 points.

The course ends with a written exam for a maximum of 60 points. Participation in the test is mandatory.

Not applicable.

Not applicable.

BRUST, A.J.: Mistrovství v programování SQL Serveru 2005. Brno, Computer Press 2007, 833str., ISBN 978-80-251-1607-4 (CS)
MORKES D.: SQL Server 2000 – tvorba, úprava a správa databází. Praha, Grada 2004, 225 s., ISBN 80-247-0732-2 (CS)

STEPHENS, R.K., PLEW R.R.: Naucte se SQL za 21 dní. Brno, Computer Press 2004, 491 s., ISBN 80-722-6870-8 (CS)
VIEIRA, R.: SQL Server 2000 – programujeme profesionálne. Praha, Computer Press 2001, 1105 s., ISBN 80-7226-506-7 (CS)