FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool

<- Publications

FROM Syntax to Semantics: An OER-Powered SQL Learning and Visualisation Tool

Yuyan Zhou, Dave Towey, Matthew Pike

IEEE 48th Annual Computers, Software, and Applications Conference (COMPSAC) | 2024 | View on Publisher's Website

Abstract

We introduce a web-based SQL query visualisation tool aimed at improving students' understanding of SQL query execution. The tool, available as an Open Educational Resource (OER), allows users to visualise the stages of a SQL query on an uploaded SQLite database. The web interface enables students to interactively explore each stage of the query and view results in a dynamically updated table. This initial version of the tool is intended to inspire further development and enhancement while providing educators with a valuable resource for teaching SQL concepts.