SQL Murder Mystery is a mystery game that lets you learn SQL concepts in a playful way. The creators do not claim that you will know everything afterwards, but they do claim that it is an exciting game – even for experienced SQL users.

Conveying content in a playful way with fun is a proven didactic practice that countless learning programming games and the like now rely on . In addition to children, the target audience is increasingly adults – as is the case with SQL Murder Mystery.

What is SQL?

The acronym SQL stands for Structured Query Language. Using SQL, data structures are defined in relational databases and data stocks based on them are queried. Learning SQL is worthwhile for budding developers, for example. Or budding data scientists. Or other people who work with databases.

And that’s what it’s about

The game revolves around a murder case that you should help solve. You received a crime scene report from the police, but unfortunately you have lost it. The only thing you remember is that the murder was committed in SQL-City around January 15, 2018. All references to the murderer are in a huge database, through which you have to navigate with SQL.

If you just want to solve the case, you will find the fun at mystery.knightlab.com. If you have no previous knowledge, there is also a walkthrough that picks you up with a few introductory words and definitions. You will learn enough SQL to solve the case. SQL Murder Mystery is not designed as a comprehensive tutorial.

You start the game by reading the crime scene report the police database. From there it continues with different concepts and database queries. Before the web-based version, the game was available as a download version, but you first have to install an SQLite environment. The developers behind SQL Murder Mystery recommend SQLitestudio to beginners. For experienced SQL users there is a separate file with instructions that contain the prohibition to use anything other than the SQL environment of your choice to solve the case – notes are not allowed.

Do you like the concept? There’s more of it here

Cathy He and Joon Park were inspired by “A crime in the neighboring Terminal City “- a mystery game that aims to bring you closer to using the command line in a playful way.

Maybe also interesting:

• python-learn-1194593 / “> Six reasons why you guys should learn Python by 2021 at the latest
• With these resources children get to know programming concepts in a playful way

Most read