Learning SQL with my Mother-in-Law

Abstract

SQL instruction predominantly relies on passive teaching techniques, failing to incorporate strategies that enhance student motivation and involvement.  Conversely, active teaching methodologies, including videos, practical exercises, and educational digital games, have demonstrated efficacy by promoting more dynamic and expressive learning experiences.  This article is technical-descriptive research that elucidates the development process of the educational game "Learning SQL with My Mother-in-Law," which aims to impart the fundamental concepts of the SQL language, with a focus on DQL commands.  The development process encompassed the utilization of the Unity engine, C# programming, the SQLite database, the Entity-Component System architecture, and top-down pixel art aesthetics.  The game was structured in phases, each intended to demonstrate the principal DQL ideas in a practical and engaging manner, enabling the player to advance through the narrative by accurately executing the specified instructions.  Consequently, an engaging, dynamic, and accessible environment was established to promote practical SQL learning.