AUTOMATION OF CHECKING SQL TASK SOLUTIONS

Abstract

The ability to create correct SQL queries is a fundamental skill that many software developers need. Mastering this skill is a complex process that requires considerable effort and practice. Automating the process of checking skills for correct query writing significantly improves the effectiveness of such training. Despite a number of proposed solutions, there are currently no unified approaches to solving the problem of building automated knowledge control systems, as well as requirements for their software implementation.

This article offers an approach to automate checking the result of SQL queries based on the use of DML (Data Manipulation Language) instructions, with the opportunity to check the solution of the same task on different DBMS implementations.