SQL Murder Mystery (mystery.knightlab.com)

Article summary

The SQL Murder Mystery is a self-directed lesson and game that teaches SQL concepts and commands through solving a murder mystery. The game is built using SQLite and provides a database to query and solve the crime. The mystery was created by Joon Park and Cathy He and is available on the web. Players can practice their SQL skills and solve the crime by retrieving the corresponding crime scene report from the police department's database.

Main themes

• SQL learning
• Murder mystery game
• Database querying
• SQLite
• Crime solving
• Web-based learning

What commenters say

• The original link to the game was incomplete, causing confusion among players, but an alternative link provided the necessary guidance.
• Some players were able to solve the puzzle quickly, while others struggled to find the starting point without additional clues.
• The game's design allows players to learn SQL concepts while having fun solving the mystery, but some players accidentally revealed the solution by querying the database schema.
• The game is a great example of story-based learning and has inspired players to look for more tools like it.
• The database contains spoilers, including the solution, which can be revealed by querying the schema or triggers.
• Players have different approaches to solving the puzzle, with some looking at the schema and others guessing table names and relationships.
• The game has been compared to other interactive learning tools, such as TwilioQuest and Jindosh.com, and has been praised for its creativity and effectiveness.
• Providing read access to a production database can be a productive way to help non-technical team members learn SQL and become more self-sufficient.