Přístupnostní navigace
E-application
Search Search Close
Course detail
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
Number of ECTS credits
Mode of study
Guarantor
Department
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 subjectTerms 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 studyTerms 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
Basic literature
Recommended reading
Elearning
Classification of course in study plans
Lecture
Teacher / Lecturer
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
The exercises are focused on the practical mastery of individual topics from the lectures.