The game for hobby detectives who want to learn SQL

March 6th, 2021, 12:00 p.m.

No time right now?

Note: We have used commission links in this article and marked them with “*”. If an order is placed via these links, t3n.de receives a commission.

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.

Communicating content in a playful way is a tried and tested 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 all 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 around January 15, 2018 in SQL-City. All clues to the killer are in a huge database that you have to navigate through with SQL.

If you just want to solve the case, you’ll find the fun at mystery.knightlab.com. If you have no previous knowledge, there is an additional one Walkthroughthat picks you up with some introductory words and definitions. You will learn enough SQL to solve the case. However, SQL Murder Mystery is not intended to be a comprehensive tutorial.

You start the game by retrieving the crime scene report from 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 beginners SQLitestudio. For experienced SQL users there is a separate file with instructionswhich includes the prohibition on using 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:

Most read