Gamifying Structure Query Language (SQL): Learning through Competitive Query-Based Challenges

Structured Query Language (SQL) is a foundational skill in database management; however, many students struggle to master it due to its abstract structure and logical complexity. While gamification has been widely recognized as an effective strategy for increasing engagement and motivation, elimination-based competition often limits participation and reduces learning opportunities for students who are removed early from play.
This study introduces a Point-Based SQL Survival Challenge designed to promote continuous participation while strengthening logical reasoning and query accuracy. Using a quasi-experimental design, undergraduate students were divided into control and experimental groups. The experimental group engaged in a team-based, turn-driven SQL challenge where correct queries earned points and incorrect queries resulted in penalties without eliminating participants. The system integrated roulette-based actions—SELECT, INSERT, DELETE, SAFE, and JOKER—to combine skill-based reasoning with strategic decision-making.
Results indicate that students exposed to the gamified approach demonstrated significantly higher gains in SQL proficiency, engagement, and collaborative problem-solving skills compared to traditional instruction. The findings suggest that point-based competitive mechanics can balance motivation with inclusivity while reinforcing logical reasoning and practical competence. This study contributes to emerging research on gamified database education and provides insights into designing inclusive competitive learning environments.

Structured Query Language, Gamification, Point-Based Learning

1. Domínguez, A., Saenz-de-Navarrete, J., de-Marcos, L., Fernández-Sanz, L., Pagés, C., & Martínez-Herráiz, J. J. (2013). Gamifying learning experiences: Practical implications and outcomes. Computers & Education, 63, 380–392. https://doi.org/10.1016/j.compedu.2012.12.020 [Google Scholar] [Crossref]

2. Deterding, S., Dixon, D., Khaled, R., & Nacke, L. (2011). From game design elements to gamefulness: Defining “gamification.” In Proceedings of the 15th International Academic MindTrek Conference (pp. 9–15). ACM. https://doi.org/10.1145/2181037.2181040 [Google Scholar] [Crossref]

3. Hamari, J., Koivisto, J., & Sarsa, H. (2014). Does gamification work? — A literature review of empirical studies on gamification. In Proceedings of the 47th Hawaii International Conference on System Sciences (pp. 3025–3034). IEEE. https://doi.org/10.1109/HICSS.2014.377 [Google Scholar] [Crossref]

4. Kapp, K. M. (2012). The gamification of learning and instruction: Game-based methods and strategies for training and education. Pfeiffer. [Google Scholar] [Crossref]

5. Marczewski, A. (2015). Even ninja monkeys like to play: Gamification, game thinking and motivational design. CreateSpace Independent Publishing Platform. [Google Scholar] [Crossref]

6. Sheldon, L. (2012). The multiplayer classroom: Designing coursework as a game. Cengage Learning. [Google Scholar] [Crossref]

7. Vassileva, J. (2012). Motivating participation in social computing applications: A user modeling perspective. User Modeling and User-Adapted Interaction, 22(1-2), 177–201 [Google Scholar] [Crossref]

• The Impact of Ownership Structure on Dividend Payout Policy of Listed Plantation Companies in Sri Lanka
• Urban Sustainability in North-East India: A Study through the lens of NER-SDG index
• Performance Assessment of Predictive Forecasting Techniques for Enhancing Hospital Supply Chain Efficiency in Healthcare Logistics
• The Fractured Self in Julian Barnes' Postmodern Fiction: Identity Crisis and Deflation in Metroland and the Sense of an Ending
• Impact of Flood on the Employment, Labour Productivity and Migration of Agricultural Labour in North Bihar