Course detail

Relational Database

FP-RDAcad. year: 2023/2024

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.

Language of instruction

Czech

Number of ECTS credits

6

Mode of study

Not applicable.

Guarantor

Ing. Jiří Kříž, Ph.D.

Department

Institute of Informatics (ÚI)

Entry knowledge

Knowledge of data modeling and a very good knowledge of MS Office, especially Excel, are assumed.

Rules for evaluation and completion of the course

Completion of the subject
Terms of credit:
During the semester, the student must obtain at least 50% of the possible maximum points, i.e. 20 points out of 40.
If plagiarism or illegal collaboration on projects or on a mid-semester test is discovered, credit will not be awarded and disciplinary proceedings may be considered.
Mid-semester test - preparation of a practical task according to the assignment. There is no correction deadline. (20 points)
Development of the project - one project according to the assignment with relevant documentation. Students are introduced to the assignment in the third lecture. (20 points)
Exam conditions:
Final exam - elaboration of a practical example and oral examination. No credit points are transferred to the exam. Successful elaboration of a practical example is a necessary condition for the oral examination. The content of the practical test is the construction of a query that returns the data set according to the input. A successfully completed practical test is one that returns the required data set, the query construction is not checked.

Completion of the subject for students with individual study
Terms of credit:
Development of the project - one project according to the assignment with relevant documentation. The minimum number of points from the project is 20, the maximum is 40. Students are introduced to the assignment in the third lecture.
Exam conditions:
Final exam - by oral examination.
Completion of the subject in distance form (applies only when objective external circumstances do not allow the study program to be carried out in accordance with the granted accreditation):

Attendance at the lecture is not mandatory. Exercises with computer support are controlled, a maximum of three absences per semester are allowed without excuse.

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

Study aids

Study supports are displayed in e-learning.

Prerequisites and corequisites

Not applicable.

Basic literature

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.

Recommended reading

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

eLearning

eLearning: currently opened course

Classification of course in study plans

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

Type of course unit

 

Lecture

26 hours, optionally

Teacher / Lecturer

Ing. Jiří Kříž, Ph.D.

Syllabus

The basic content of the lectures is as follows:
1. Conceptual database design (modeling, data types, data storage and index structures, data dictionaries, documentation, E-R diagram).
2. Logical database design (optimization of database structures, solution of various types of relational links, multiplicity).
3. Physical design of the database (creation of database and tables in the SQL language, limitations, implementation of the database scheme on the SQl server).
4. Selection of data from the database in the SQL language (selection of columns, rows, sorting, grouping, aggregation, nested queries).
5. Selecting data from multiple tables in SQL (joining tables with where and join clauses using various combinations).
6. Inserting, editing and deleting data in SQL (inserting a record into a table, inserting data from another table, inserting unique values, changing data in a table, deleting data from a table).
7. Database objects - views, transactions, triggers (transaction processing, storage and return points, procedural extensions of the SQL language, command flow control, cycles, error handling, work with triggers).
8. Database objects - stored procedures (creation of stored procedures, work with variables and parameters, nesting of stored procedures).
9. Database objects - cursors (declaration, opening, selection of data, types of cursors, problems associated with cursors).
10. SQL Server management (backup, replication, security, user permissions).
11. Integration and reporting services of SQL Server (ETL processes, creation of reports).
12. SQL Server Analytical Services.
13. New trends in database technologies.

Exercise

26 hours, compulsory

Teacher / Lecturer

Ing. Jiří Kříž, Ph.D.

Syllabus

The exercises are focused on the practical mastery of individual topics from the lectures.

eLearning

eLearning: currently opened course