There’s been a backlog of unsolved cases piling up in the Minor Crimes Division of the Los Zorangeles Police Department and we’ll need a Database Detective to help solve them.
We’ll need you to analyze clues and manipulate data using SQL, a database querying language, to figure out who perpetrated crimes from as minor as littering to as serious as not checking out of a hotel after the check-out time.
Don’t worry! This role is intended to be accessible for those without any SQL experience, so each Database Detective is given an introductory textbook when they start! This short textbook is less than 20 pages and explains everything that’s needed to solve each case.
If you still have trouble writing queries, our comprehensive error messaging system will tell you exactly where your query went wrong, making it easy to correct your mistakes.
Still not enough? Each Database Detective is assigned an assistant who’s ready to answer any questions you might have, whether they be about the case itself or the SQL queries you’ll need to write!
Understanding how to manipulate data using SQL is not the only part of being a Database Detective! Your job will also require you to piece together evidence and clues, just like a real detective! Further on in your Database Detective career, you’ll have to sleuth through the internet and piece cases together yourself.
Job benefits also include…
Fully voice acted mission briefings at the beginning of each case!
Fully hand drawn art for you to enjoy!
More than 40 websites to explore!
10 cases for you to solve, each case getting longer and more complex!
A total of around 5-6 hours of valuable work experience to add to your resume!
Hey everyone! Thanks for playing and for all the kind feedback so far! :)
This newest update should overall improve stability and make the goal of the last level clearer.
Please let me know if you have any more feedback!\n
Update Notes:
Gameplay Changes
Update evidence in level 4 to clarify which conventions the suspect went to.
[/*]Update textbook chapter 4 to clarify what is allowed when using aggregate functions.
[/*]
If more than one table is being selected, throw an error if not every table is joined together (prevent inadvertent cross joins).
[list]This technically isnt a requirement in SQL, but theres not really a reason to do a cross join in this game. Even in practical real life circumstances its rare. Plus, its really easy to build up massive queries that crash the game, which can happen if youre not careful with your join conditions.
[/*]
Remove song from music player that was causing YouTube copyright strikes
[/*]Add a couple more royalty free tracks.
[/*]Fixes
Increased audio volume from the messages panel.
[/*]Made the music player volume slider less sensitive.
[/*]Update to the newest version of Unity due to security vulnerability
[/*]Added some optimization for the loading of table panels.
[list]Table panels will now load more data once you scroll all the way to the bottom.
[/*]This isnt really relevant for the demo but in the full release some tables get really large so I want to ensure the experience stays consistent.
[/*]
Minimum Setup
- OS: Ubuntu 22.04
- Processor: Whatever you have :)Memory: 4 GB RAM
- Memory: 4 GB RAM
- Graphics: Yes
- Storage: 2 GB available space
[ 6377 ]
[ 5885 ]
[ 750 ]
[ 1993 ]
[ 415 ]
Time left:
356102 days, 22 hours, 52 minutes
Time left:
356102 days, 22 hours, 52 minutes
Time left:
7 days, 6 hours, 52 minutes
Time left:
35 days, 6 hours, 52 minutes
Time left:
38 days, 6 hours, 52 minutes
Time left:
39 days, 6 hours, 52 minutes
Time left:
12 days, 16 hours, 52 minutes
Time left:
0 days, 0 hours, 52 minutes
Time left:
1 days, 0 hours, 52 minutes
Time left:
8 days, 0 hours, 52 minutes
Time left:
14 days, 0 hours, 52 minutes
Time left:
15 days, 0 hours, 52 minutes
Time left:
20 days, 0 hours, 52 minutes
Time left:
26 days, 0 hours, 52 minutes
Time left:
2 days, 10 hours, 52 minutes
Time left:
10 days, 6 hours, 53 minutes
Time left:
12 days, 5 hours, 53 minutes
Time left:
17 days, 13 hours, 3 minutes
