Development of an interactive web-based platform for SQL learning and skill enhancement

Ho, Yin Kin (2025) Development of an interactive web-based platform for SQL learning and skill enhancement. Final Year Project, UTAR.

PDF Download (6Mb)

Abstract

This project outlines the creation of SQL Quest, an interactive platform that aims to assist in learning SQL through gamification. SQL, or Structured Query Language, is essential for data management and analysis, however, most online learning platforms are not engaging, lack personalized feedback, or do not provide real-world relevance. SQL Quest seeks to provide a solution by integrating conventional content into interactive practices coupled with real-time feedback, an XP progress tracker, and challenges to motivate learners. The system is built with HTML, CSS, and JavaScript alongside web development software such as Node.js and MySQL. These components structure the platform using the Prototyping model which allows for iterative refinement. The platform boasts a few features including lesson modules with quizzes, practice SQL editors, multi-tiered challenges, dashboards, and a progress tracker. Users are also enabled to bookmark lessons, track lessons they have completed, and earn XP which unlocks badges. SQL comprehension and user engagement preliminary results indicate that user functionality and performance meet SQL Quest’s objectives. The project has value in responsiveness, scalability, and user-centered design principles applied to SQL and computer science education. Further development five aims to incorporate a SQL Smart assistant for suggestion and correction tasks to enhance interactivity and incorporate industry-specific SQL application scenarios.

Actions (login required)