Database Detective: Minor Crimes Division

[h1]A Fun and Clever Introduction to SQL[/h1] [b]Database Detective: Minor Crimes Division[/b] is an entertaining puzzle game that does a great job of teaching you key aspects of SQL. I am a huge fan of educational gamification, and this balances learning and gameplay really well. [h2]First Impressions[/h2] I initially tried the demo and finished the first two levels, which was enough to convince me instantly. I have put about an hour into the game so far and fully intend to play much more. If you are on the fence, I highly recommend giving the demo a go! [h2]Highlights[/h2] [list] [*] [b]Tone & Style:[/b] Goofy graphics and silly, light-hearted storylines. [*] [b]Puzzles & Difficulty:[/b] Offers a genuine challenge, particularly when deciphering what is required and learning SQL queries completely from scratch. [*] [b]Learning Curve:[/b] Makes database querying approachable and engaging without feeling like a dry textbook. [/list] [hr][/hr] [b]Verdict:[/b] Highly recommended for anyone who enjoys logic puzzles or wants a fun, practical way to learn SQL.

Хорошая детективная игра. Забавный, местами сатирический юмор. Ожидал головоломки на знание/изучение SQL, так и было по началу. Но после 6-го уровня - начинается жёсткий и местами даже душный детектив, где больше играет роль сбор информации, сопоставление найденных данных и так далее, а SQL необходим уже на финальном этапе уровня для фильтрации найденных данных. Игру рекомендую, но не думаю, что многие пройдут её до конца.

Just a disclaimer, I am not a coder, so this game is my introduction to SQL and coding in general. But this game is a good way to learn and I learned my way from 0 to being able to solve the cases. So don't worry if you have no experience in SQL. What you need is an open mind and a willingness to learn. That said, it's a fun experience solving the cases with SQL. Most of my playtime is spent mostly on figuring out how to do the coding. I can say that the coding itself is part of, if not the main puzzle-solving aspect of the game, as there are too many tables and data values to do things the usual pen-and-paper-notes way with the usual deduction games, so you really have no choice but to use SQL for it. I've never done so much typing and cross-referencing just to get the name of 1 suspect! For me, this is still a must-buy for anyone who likes deductive or puzzle games. The humor, voice acting and storyline (yes, there is lore!) carried me through it! It's definitely a different experience and gameplay loop puzzle game-wise, and I highly recommend it if you're looking for something different! If you're still on the fence, try the demo first and see if you like it before committing to the full game!

Esta bueno el juego, si bien te pide saber algo de sql no es nada terrible, tambien trae un manual que explica todo lo que necesitas saber para hacer consultas y se entiende bien. El juego esta en ingles pero no es muy complejo, se puede entender

Funny and clever game. The type of hand-made game that makes you feel grateful for finding it.

very cool game. Really cheezy humor and a little flawed around the edges but really charming and FUN. If you like obra dinn, golden idol, zachtronics this is right up your lane. I've played programming based puzzle games before and have been disappointed but this game has a very satisfying learning curve with interesting puzzles.

It would be nice if the developer would remove the artificial constraints, and allow all features of the database that backs this game. Apparently this is SQLite. So please don't stop us from using Cross joins, recursion, CTEs, Full outer joins, natural joins, window functions like LAG and LEAD. And please use the date data type, instead of using integer for dates. Apart from that, it is a fun game. But being artificially constrained is not fun.