Modern DBMS (4th semester)

Course: Computer Systems and Networks Engineering

Structural unit: Faculty of Radiophysics, Electronics and Computer Systems

Title
Modern DBMS (4th semester)
Code
ВБ 2.5
Module type
Вибіркова дисципліна для ОП
Educational cycle
First
Year of study when the component is delivered
2023/2024
Semester/trimester when the component is delivered
4 Semester
Number of ECTS credits allocated
3
Learning outcomes
The student must know: architectural features of modern relational DBMS of the most widely used platforms; basic properties of processing large data sets using the declarative SQL query language; basics of the ANSI standard in developing software tools for interacting with DBMS: methods of analyzing performance and debugging software applications based on executing SQL scripts; principles of building effective client-server software applications focused on interacting with relational DBMS. The student must be able to: develop SQL scripts for creating and administering databases and ensuring effective access to data in a variety of ways; interfaces and API modules of modern DBMS for developing client software applications on modern platforms; analyze the efficiency and productivity of client-server software applications for their compliance with technical specifications, with their subsequent optimization.
Form of study
Full-time form
Prerequisites and co-requisites
The academic discipline "Modern DBMS" is a mandatory part of the block of disciplines for the specialization "System Administrators" and uses the results of studying the mandatory disciplines "Discrete Mathematics", "Programming", "System Programming", "Computer Systems" and "Computer Networks". Prerequisites: 1. Be able to test and debug peer-to-peer computer networks. 2. Know the basics of program development and tracing. 3. Have the skills to analyze exceptional situations of software products.
Course content
Studying the discipline "Modern DBMS" allows you to understand the architecture of modern database management systems (DBMS), the conceptual features of the declarative SQL query language and its role in database administration and the development of client-server applications focused on relational databases. The course introduces the basic provisions of the ANSI standard and the basics of Codd's theory. The course focuses on studying approaches and methods for designing, creating, configuring, and administering front-end and back-end parts of modern distributed software tools aimed at performing and supporting automated processes in any subject area. The student acquires basic skills in analyzing data structures and relationships in terms of optimal DBMS operation, as well as applying modern developments in relational theory to solve practical applied problems.
Recommended or required reading and other learning resources/tools
1. Jonathan Lewis Oracle Core Essential Internals for DBAs and Developer.: Copyright © by Jonathan Lewis, 2015. - 372 p: pct., ISBN 978-1-4302-3954-3 2. Thomas Kyte Darl Kuhn. Expert Oracle Database Architecture, Third Edition.: APress, Berkeley, Copyright © 2014 by Thomas Kyte and Darl Kuhn, 2014 - 960 p.: pct., ISBN 978-1-4302-6298-5 3. James Groff, Paul Weinberg, Andrew Oppel, SQL: The Complete Reference, Third Edition.: McGraw-Hill Companies, Copyright © 2010 - 960 p.: pct., ISBN 978-0-07-159255-0 4. Paul Dubois, MySQL.:© New Riders Publishing, 2000 - 816 p.: pct., ISBN 0-7357-0921-1 5. Helen Borrie The Firebird Book: A Reference for Database Developers.: - Copyright © 2002 by Apress LP.-1104 p.: pct., ISBN 1-59059-279-4 6. Robert Vieira, Beginning Microsoft SQL Server 2005 Programming.:Copyright © 2006 by Wiley Publishing, Inc., Indianapolis, Indiana - 832 p.: pct., ISBN 0-7645-8433-2
Planned learning activities and teaching methods
Lectures, laboratory work, written module tests, independent work of students.
Assessment methods and criteria
The academic semester has two content modules. The overall assessment during the semesters is carried out based on the sum of the results of laboratory work. It is mandatory for admission to the credit to complete laboratory work of each module with a total score of at least 15 points (out of 30). The final test is an exam-interview, with a score of at least 24 points.
Language of instruction
Ukrainian

Lecturers

This discipline is taught by the following teachers

Serge Valentynovych Olszewski
Department of Radiotechnique and radioelectronics systems
Faculty of Radiophysics, Electronics and Computer Systems

Departments

The following departments are involved in teaching the above discipline

Department of Radiotechnique and radioelectronics systems
Faculty of Radiophysics, Electronics and Computer Systems