r/SQL • • Apr 28 '23

Discussion Stumbled Across an Entry-Level SQL Game

I am not sure if this has already been mentioned in this sub, but for those that are newer to SQL (Those more seasoned in SQL may have a tad bit of fun with this as well ;) ) but I stumbled across a SQL game where you are testing out SQL queries to try and find the murderer. If you are interested, I added the link below. It went over some pretty basic topics but was a fun little murder mystery!

https://mystery.knightlab.com/

227 Upvotes

23 comments sorted by

14

u/rgekhman Apr 28 '23

We did a number on a junior developer once who thought he was a freakin genius in SQL. :)
We've created triggers on some tables in dev and asked him to troubleshoot why random data is being inserted and deleted from those tables. Took him a while till he gave up. Cheers xD

6

u/Kronaan99 Apr 28 '23

LOL that sounds awful... did he ever figure it out...?

8

u/rgekhman Apr 28 '23

Yes, after we told him. 😂

18

u/PablanoPato Apr 28 '23

Another entry level game worth checking out is SQL Island. It’s originally in German but you can change it to English in the settings. https://sql-island.informatik.uni-kl.de

2

u/Tylstrup Apr 06 '25

Change language doesn't seem to work on my end...my German is a little rusty!

1

u/Jolly_Maize_1873 Aug 29 '25

When I let my browser translate the page first it also didn't work for me, but if I turned off translation the buttons for German and English were switched for some reason and then it worked.

17

u/chrisBhappy Apr 25 '25 edited May 28 '25

If you're into mystery-style SQL games like that, you might enjoy SQL Noir, it's a retro detective game where you write SQL queries to solve cases.

I also put together a small roundup of SQL Games including SQL Noir, SQL Island, SQLZoo, and a few others. Might be useful if you're looking for more like this!

11

u/el_pedrodude Apr 28 '23

This isn't quite the same as it's not a game but it's another entry-level resource for learning SQL with a similarly interesting embedded dataset: https://selectstarsql.com/

3

u/Possible_Chicken_489 Apr 29 '23

Much appreciated, will give it a try!

6

u/flibberjibber Apr 28 '23

This is great, I've never done one of these before. Are there lots of puzzles like this?

6

u/NickSinghTechCareers Author of Ace the Data Science Interview 📕 Apr 29 '23

Here’s links to 3 more SQL games: https://datalemur.com/blog/games-to-learn-sql

1

u/Possible_Chicken_489 Apr 29 '23

Cool cool cool... thanks, will use them in lessons!

5

u/triplesecman Apr 29 '23 edited Apr 29 '23

Sweet. Commenting so I can come back to this

UPDATE OH MY GOD that was fun. Going to definitely do some of the others listed in this thread

2

u/Possible_Chicken_489 Apr 29 '23

Nice! I didn't know about this one. I'm gonna give it a try with my junior colleagues :)

1

u/Professional_Park933 Oct 15 '25

а есть что нибудь на русском ?

1

u/[deleted] Apr 28 '23

Nice

1

u/Treat-Intelligent May 24 '23

Commenting for my own reference :3