Learn about SQL Databases in a Fun Way with SQL Murder Mystery

Databases are an indispensable part of our digital age. They enable us to store, organize, and retrieve large amounts of information. In this ongoing series, our two developers, Sven and Holger, who have extensive database experience, will introduce you to the world of databases using an exciting murder mystery as an interactive example. They will pay particular attention to the query language SQL (Structured Query Language), which enables databases to be searched and edited efficiently.

Playful Murder Hunt: Collect Data and Use the Database

The actual manhunt begins. Sven and Holger introduce us to the interactive website https://mystery.knightlab.com/, where we can follow the latest information on a fictional murder case. The date, location, and other relevant data are presented. But there are gaps and ambiguities in the information. This is where databases come into play. The developers explain how they organize the collected data in a database and fill in the missing information. They show how databases help to link different data points and create a more comprehensive picture.

Of course, protecting the collected information is of utmost importance. Individual data points do not seem to contain much information on their own. However, when linked with other data, a timeline with location history can be created. In the worst case, this could lead to a situation where all our data is available online and every person becomes “transparent.” But that’s not the only problem the developers encounter during their search for the killer.

Has the Murderer Been Caught yet?

In their thrilling search for the murderer, Sven and Holger use the database to collect, organize, and analyze information. In doing so, they not only investigate questions such as the completeness of the database, but also its susceptibility to errors. In the process, they unexpectedly encounter the story of Alice in Wonderland. But is the white rabbit pointing them in the direction of the murderer, or are they simply being led astray?
The hunt is not that easy, even for our experienced developers, because the sheer volume of data records easily leads them down a few dead ends. They explain the approaches they are pursuing to track down the murderer in an understandable way and also show how to proceed if the previously established theory has not brought the expected success or if the required data is not available.

CoP on Demand: A New Episode Every Two Weeks

The “SQL Murder Mystery” series offers an entertaining and educational way to learn the basics of database usage. Our developers demonstrate how databases can be used in real-world scenarios to manage, analyze, and protect information. This series is suitable for both database beginners and those who are curious to learn more about the world of databases.

You can watch our six-part CoP on Demand series on YouTube. Every two weeks, there is a new episode that takes you on a journey to find the murderer. Start with the first episode, which you can watch here.

Would you like to join the hunt for the murderer? Then simply visit https://mystery.knightlab.com/.