Building Individual Educational Routes for Learning SQL Queries

Due to how prevalent the usage of database technologies is in everyday life and related professional fields, the insufficient qualifications of specialists in relevant positions becomes an issue. The aim of this paper is to show the importance of forming individual educational routes as a factor inf...

Full description

Bibliographic Details
Main Authors: Anton Govorov, Marina Govorova, Helen Slizen, Sergey Ivanov
Format: Article
Language:English
Published: FRUCT 2019-11-01
Series:Proceedings of the XXth Conference of Open Innovations Association FRUCT
Subjects:
Online Access:https://fruct.org/publications/fruct25/files/Gov.pdf
Description
Summary:Due to how prevalent the usage of database technologies is in everyday life and related professional fields, the insufficient qualifications of specialists in relevant positions becomes an issue. The aim of this paper is to show the importance of forming individual educational routes as a factor influencing the effectiveness of training and the ability of a specialist to develop skills in professional activities. In learning SQL queries, repeatedly performing typical tasks, seeing the results, and adjusting queries accordingly, is necessary. Therefore, computer training simulators can be considered the most effective tool for learning SQL queries. This paper proposes a method for building an individual educational route for fulfilling tasks meant to train professional skills in compiling SQL queries. The task and learner models are described within the method. The A* algorithm is modified based on the proposed models, and the conditions of using it for creating an optimal individual educational route are described. Based on the theoretical study results, a computer simulator for training professional skills in writing SQL queries is implemented using the method of building individual educational routes for fulfilling tasks meant to train professional skills in writing SQL queries. Based on the analysis of the results of a test run, the conclusion is that the usage of the proposed method and the algorithm implemented in a computer simulator can be considered effective.
ISSN:2305-7254
2343-0737