Infopaket

SQL

ОК 13

Обов’язкова дисципліна для ОП

Second

2023/2024

3 Semester

4

The learning outcome is the formation of knowledge about relational database management systems. As a result of studying the academic discipline, the student should learn different types of requests to relational data, basic data types and functions defined on them, principles of query optimization, be able to write operators for adding and modifying information in the database; on the basis of the analysis of the task being developed, choose the most rational query operators that ensure the effective implementation of the task. The student must have the knowledge and skills to perform relation filtering operations by condition, connection of relations. The student should be able to perform multiple-theoretic operations on relations, write queries for grouping data, sort query results by various criteria, be able to work with uncertain information, combine queries in transactions.

Full-time form

The discipline is based on knowledge, skills and practical skills acquired by students during the study of the disciplines "Basics of Programming", "Algorithms and Data Structures", "Introduction to Object-Oriented Programming".

The SQL discipline consists of two meaningful modules. The first module covers topics such as what is a database management system, what is a relational database, what is a relation, data types, constraints, data description language, data manipulation language. In the second substantive module are studied relational algebra, creation of analytical queries, stored functions and procedures, and transactions.

1. Mulesa O. Yu. Information systems and relational databases. Training manual. Electronic edition. 2018. 118 p. .— Access mode: https://dspace.uzhnu.edu.ua/jspui/bitstream/lib/19776/1/Мулеса_БД.pdf 2. Bardus I. O. Databases in schemes (based on the fundamental approach): ed. manual Kharkiv: "Disa plus" edition. 2017.133 p. 4. Mulesа O.Yu. Basics of the SQL query language. Electronic edition. 2015. 48 p.— Access mode: https://dspace.uzhnu.edu.ua/jspui/bitstream/lib/8868/1/sql.pdf 5. Bulatetska L. V. The language of SQL queries: the text of the lectures of the normative educational discipline "Databases and distributed information and analytical systems". Lutsk: Lesya Ukrainka SNU, 2018. – 92 p. 6. Ramakrishnan R., Gehrke J. Database Management Systems. New York: McGraw-Hill Higher Education. 2003. 1098 p.

Lectures, practical activities, individual work

The level of achievement of all planned learning outcomes is determined by the results of the defense of practical work and individual tasks of independent work. Semester assessment of students is carried out during the semester for all types of work. The total score is formed as a weighted sum of points earned by the student for various types of work. The maximum number of points that a student can receive for work in a semester does not exceed 100 points. The final evaluation form is an exam. A student is not admitted to the exam if he scored less than the recommended 36 points during the semester. For students who during the semester did not reach the minimum cut-off grade level, a final semester comprehensive test is conducted, the maximum grade of which cannot exceed 40% of the final grade (up to 40 points on a one-point scale). The condition for receiving a positive final grade for a discipline is to achieve at least 60% of the maximum possible number of points - 60 points.

Ukrainian