Database Detective: Minor Crimes Division

Love this game. Would recommend to all who enjoy clues and putting together pieces to solve a mystery. Also to all who love getting outsized justice for minor criminality. Special recommendation to people who enjoy code. Great challenges, excellent throughline, and step-by-step instruction for SQL.

Fun

This game is so much fun, I would highly recommend it even if you have no previous SQL experience! I did not know any SQL before this game, but each case does a great job with building upon the previous one, the difficulty ramp feels well designed and the community in general is great at helping out other players who get stuck!

[h3]Hard but very satisfying[/h3] The difficulty progression is great, and even though the last cases can take hours, they never feel impossible. It's also very funny.

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 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.

Это лучший способ выучить БАЗУ SQL и пройти собеседование!🔥 Не обращайте внимание на время в игре. Остальные 30 часов я провел в своей сборке, где перевел на русский язык всю инструкцию и прошёл её до последний главы. 👉 В моем профиле есть руководство, где я рассказал про перевод на русский язык и создал чат «IT через ИГРЫ». Я кручусь в IT уже 5 лет, но, как ни стыдно признать, никогда не знал SQL на достойном уровне. Так, чисто простой SELECT с двумя условиями. Но пришло время менять работу, а на собесах везде требуют SQL. Увидел эту игру в рилсах и сразу скачал. Прошел до последней главы, пошел на собеседование и впервые в жизни вообще не очковал на секции SQL. Прошел всё на изичах, без подсказок и помощников! Теперь это моя главная рекомендация для учеников. Это единственный способ выучить SQL не душным способом + научиться работать с данными, анализировать их, быть внимательным, все навыки, чтобы стать хорошим программистом. А проектирование БД и сложные концепты потом даются в миллион раз проще, потому что ты уже был ДЕТЕКТИВОВ БАЗ ДАННЫХ!