FP-DBSAcad. year: 2019/2020
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, algorithmization and programming techniques as well as fundamentals of HTML language are required.
Recommended optional programme components
Recommended or required reading
VIEIRA, R.: SQL Server 2000 – programujeme profesionálně. Praha, Computer Press 2001, 1105 s., ISBN 80-7226-506-7 (CS)
ŠIMŮNEK M.: SQL kompletní kapesní průvodce. Praha, Grada 1999, 244 s., ISBN 80-7169-692-7 (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.: Naučte se SQL za 21 dní. Brno, Computer Press 2004, 491 s., ISBN 80-722-6870-8 (CS)
BRUST, A.J.: Mistrovství v programování SQL Serveru 2005. Brno, Computer Press 2007, 833str., ISBN 978-80-251-1607-4 (CS)
LACKO L.: Web a databáze. Praha, Computer Press, 2001, 247 s., ISBN 80-7226-555-5 (CS)
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.)
Language of instruction
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
- 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
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.
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.