AN INFORMATION SYSTEM FOR MONITORING STUDENTS’ KNOWLEDGE LEVELS THAT PROVIDES CAPABILITIES FOR CONDUCTING CLASSICAL KNOWLEDGE TESTING AND ASSESSING SQL PROFICIENCY

Zavozkin Sergey Yuryevich

In the context of digital education, the automation of learning efficiency assessment has become increasingly significant. An effective control system at all stages of education forms an essential component of the learning environment, improving the quality of professional training. Automation not only optimizes performance evaluation but also creates a productive feedback mechanism. For the Institute of Digital Technologies, one core discipline is 'Databases.' Traditional testing tools fail to provide automated assessment of SQL programming skills. To address this limitation, a proprietary information testing system was developed, enabling both conventional knowledge testing and SQL proficiency evaluation across various relational databases. This paper presents the process of developing the proposed information system. As part of the study, a comparative analysis of eight existing testing systems was conducted, system design was carried out using UML notation, implementation tools were selected, and a proprietary information system was developed and prepared for pilot deployment.

Keywords:testing of students, automated knowledge assessment, SQL, information system