Database Detective: Minor Crimes Division

Possibly the best Detective game i have ever played! As a comp-sci student who has to learn SQL this semester this game got my attention for alllowing me to learn SQL in a fun way But then i realised that the game is so much more then that. Soon i was constantly making theories about the culprits and how to advance my cases, realised that seemingly easy cases where so so much more deep then i initially anticipated, that instead of having some fun little SQL puzzles, i have to really do detective work, read between the lines, come to conclusions, search for additional evidence and so on, and the whole SQL part, is "just" the cherry on top! Amazing game and the only little downside that just shows how incredible the game is, is that there are not 100 more cases to experience, since i have really falled in love with the game! :D

Between the dry humor and real-world application of SQL, this games a winner. Having a great time solving the issues while re-learning SQL!

This game is an absolute gem. I'm at case 8 / 10 at this stage and I've been having an absolute blast. It's very well made, the increase in difficulty with each new case is steady but always interesting and on top of that, it's hilarious. Now, sure, SQL and datasets are kind of at the heart of the game. You're going to have to use it and If you know SQL already, you'll probably finish the game quicker than what's advertised as figuring that part out is supposed to be part of the fun (the SQL manual is funny too, and really helpful). The good thing is that the SQL implementation in this game is just the right amount of features and possibilities to make it powerful enough without going too crazy in complexity. That being said, if you know SQL already, it won't mean you're going to get away easy with it either! The core mechanic of each case is as follow: starting from a narrow list of clues that are given to you at the start, you're going to have to find more and more hidden ones. Some useful, some not. It's up to you to use actual deduction and logic, as with any (non SQL-based) investigation game to figure out the case, and what the relevant information is. All this to, eventually, build a SQL query that will allow you to narrow down a number of possibilities of suspects from one or more datasets to one single row. By the way, this final step of working out your way through the dataset down to this one single possibility is incredibly satisfying and is where the dopamin peaks :D Highly recommend to anyone, but especially to those who can experience some sort of excitment when looking at spreadsheets.

Joined Minor Crimes Division as intern Dropped crime database on first day Reduced crime by 100% 10/10

Zoran isn't perfect, but who is? 4/5 my brain hurts

Kıymetli Bağlantılarım, Sektörde bulunan 1 senelik tecrübemin ardından bu oyundan kazandığım SQL bilgi ve yeteneklerini LinkedIn profilime eklemeye karar vermiş bulunmaktayım. Bilgi İşlem Uzmanı, Bilgisayar Programcısı, VKHİ gibi kadroları bünyesine katmak isteyen tüm iş yerleri ve iş verenlere duyurmaktan kıvanç duyarım. İlgi ve alakanız için teşekkürlerimi sunarım.

This is a great game so far and you can feel real passion behind it's creation. The SQL isn't that difficult but it doesn't matter since it's just one part of being a detective of minor crimes. This game has made me giggle quite a few times with so many things, the art style is great, the OS feel, everything. Even better is that is has a free demo so you can see if you would like it. Once it's over I will be sad and hopefully there will be a sql...