Back to Publications
2024

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

Zhou, Yuyan, Towey, Dave, and Pike, Matthew

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.

Keywords

Computer scienceSyntaxProgramming languageSemantics (computer science)SQLVisualizationNatural language processingArtificial intelligence