Background Information
Learning to write SQL queries is a key part of two major database courses at TU/e. Until now, these skills have been taught primarily through pen-and-paper exercises, which limit students' ability to receive immediate feedback and hampers hands-on practice. Although students can install their own databases, this process is often too complex and distracting from the core learning goals. Moreover, while online SQL tutorials exist, they typically lack well-integrated theory, structured progression, and tailored feedback.
To address these issues, the Database Group at TU/e is developing a new web application called SQL Valley. This tool provides a structured and interactive learning environment for SQL through a modular "Skill Tree" format. Each node in the tree corresponds to a specific skill and is supported by a short knowledge clip, a theory page, a visual summary, and adaptive practice exercises. This setup allows students to learn in ways that suit their preferences, track their progress, and follow personalized learning paths. The app includes optional gamification features, such as a storyline inspired by "Silicon Valley," to enhance engagement. A prototype is already functional, and the project team aims to expand it with additional content and features in the coming academic year.
Aim of the project
The goal of the SQL Valley project is to develop and pilot a web-based learning tool that supports student-centered, competency-based SQL instruction. The platform is designed to allow students to master individual SQL skills through small, focused learning units and to visualize their progress via an interactive skill tree. This approach encourages ownership of learning, provides clarity about course structure, and supports diverse learning needs.
The application includes features that combine theory, practice, and feedback in an integrated way. Students will be able to explore concepts through videos, summaries, and guided exercises, and then test their understanding with automated feedback. The skill tree helps them identify what they’ve already learned and what’s next, reinforcing the sense of progress and control. Additionally, an optional storyline component adds a narrative layer to the learning experience, further motivating users through game-like elements.
Initially, SQL Valley will be offered as an optional supplement to existing course materials. After testing and evaluation through surveys, interviews, and exam analysis, it may eventually replace standard exercises. The tool is designed with scalability in mind and could be adapted for other courses or institutions, contributing to broader educational innovation in digital learning environments.