WIP: Beyond the Classroom - Mystery Games as a Portal to SQL Proficiency

This research-to-practice WIP paper outlines the development and implementation of an educational project to enhance SQL (Structured Query Language) learning through a series of mystery cases. The initiative underscores a novel approach to engaging undergraduate students in mastering SQL by integrating game-based learning within the curriculum. The the-oretical frameworks underpinning this project are grounded in constructivist learning theories and the application of game-based learning in education. These frameworks suggest that learners construct knowledge more effectively when actively engaged in the learning process and when the learning is contextualized within meaningful and enjoyable activities. Unlike traditional methods of teaching SQL, which often emphasize memorization and passive learning, the SQL Mystery Game provides a dynamic platform for students to apply SQL concepts in a practical, engaging, and contextually rich setting. Students use their SQL skills to search for clues, filter out unwanted pieces of evidence, link data from multiple sources, and generate information from given data to solve different mysteries. The project builds on previous preliminary non-digital activities demonstrating positive student reception and instructor observations, suggesting that game-based learning can effectively enhance students' application of SQL concepts. Furthermore, the effectiveness of the new online game is evaluated using a user study that involved a multi-faceted survey designed to evaluate the game from various angles. The study results validated the efficacy of enhancing SQL learning through the SQL Mystery game and showed that it significantly improved students' engagement, interest, and understanding of SQL concepts. This research has significant implications for educational practice, particularly for engineering and computing education. It demonstrates the potential of game-based learning to transform passive learning environments into active ones, making complex subjects more accessible and enjoyable for students. This project offers valuable insights into designing engaging learning experiences that prepare students for real-world challenges and equip them with the skills necessary to thrive in data-intensive industries.