Undergraduate computer science majors in the database management course at Virginia Military Institute (VMI) are now having fun learning Structured Query Language (SQL), through a unique game playing approach — bypassing the traditional educational methods of memorization and passive participation.

Although mastery of SQL is recognized as a necessary skill to manage a variety of data-intensive domains, it is acknowledged that the instructional methods have not evolved to address the learning challenges found in the course materials. Thanks to George Mason’s Jacob Enfield, in the College of Visual and Performing Arts and the Virginia Serious Game Institute, and Sherif Abdelhamid at VMI — along with a 4-VA grant — students at VMI are approaching SQL education in an entirely different way, and the results are impressive.

To add in the fun factor, Enfield and Abdelhamid created a ‘murder mystery’ game. As players advance through the game, they encounter a series of questions designed to test their SQL skills. Each correctly answered question brings the player closer to solving the mystery and reinforces concepts in a practical approach. The game provides a simulated real-world context in which learners apply their skills to solve an authentic problem within the simulated context of the game world. Additionally, the game incorporates common components that enhance engagement, such as story, goals, points, and increasing levels of challenge. The scoring system introduces a competitive element among players, as players answer more questions correctly their scores increase and they can advance to the next level. “With this approach, we were able to target today’s digital-native students, accommodating their preference for interactive, feedback-rich learning environments,” explains Enfield.
Supporting Enfield and Abdelhamid in the development of the system were Mason students Swetha Annapoorna and Ajay Addike, who built the web apps.
Student evaluations show that the new learning approach is working. Students liked the system’s engaging nature, competitive elements, visual simplicity, and interactive features. In addition, students rated the game highly for reinforcing SQL concepts learned in class. All students reported interest in understanding more about SQL due to the game. Says Abdelhamid, “A large majority of the students felt that this approach taught them to manage SQL problems strategically, which is essential for learning any programming language.”
With the successful course redesign under their belt, Enfield and Abdelhamid are now in the dissemination process. The course was featured at George Mason’s Innovations in Teaching and Learning Conference and presented at the Frontiers In Education Conference.
In another result of the collaboration, the Enfield and Abdelhamid relationship has proved fruitful, as the two have already received outside funding for a different project. “This 4-VA opportunity has helped me reach out to other universities and make connections I normally would not have made,” concludes Enfield. “And we were able to deliver a great new way to teach an important skill.”