SQL Police Department

SQL Police Department

Learn SQL while solving crimes! Climb the ranks of SQL PD.

4 followers

Visit website
SQL Police Department is an online game where you solve crimes using SQL (and learn SQL on the way). As you solve more cases, you advance in the ranks of SQL Police Department and learn more SQL.
SQL Police Department gallery image
SQL Police Department gallery image
SQL Police Department gallery image
Launch tags:Developer Tools•Tech
Launch Team
Framer
Framer
Launch websites with enterprise needs at startup speeds.
Promoted

What do you think? …

Doron Linder
SQL Police Department
Maker
I built this game to help you learn SQL in a fun and engaging way.
Ybex
Really cool way of learning SQL, congrats!
Victor G. Björklund
Haha! Epic idea! Love it.
strocolate
Good idea but the mobile site isnt working for me, the keyboard doesnt appear
Doron Linder
SQL Police Department
Maker
@strocolate1 There is no keyboard in the game. You should click on the command buttons and table / field names below to construct your query.
Jordan Rolph
Great fun! 👮
Anastasia Bogapova
Thanks! It's fun. I wanted to try your product, but the site doesn't load. Do you know what the problem is?
Doron Linder
SQL Police Department
Maker
@ann_bo The site is up. Are you trying to connect from Russia? If so, you should use a VPN. The censor there blanket blocked some cloud providers.
Anastasia Bogapova
@doron_linder thank you, it works with vpn
Ariella
@doron_linder 1. Where is the ability to Sign Up? I only see Log In. 2. Can you check your answer for "White hat hacker has sent SQLPD exposed subscribers' details of a shady site connected to various persons of interest. Please submit the top 10 subscribers' details when sorted by hashed passwords in descending order and then by usernames in descending order." I submitted an answer and it keeps saying that I have too many rows.
Doron Linder
SQL Police Department
Maker
@ariella_cg 1. On the first screen, click on the "Buy a license" link. If you're already playing click on the profile tab (rightmost) and then click on "Buy a license" link. 2. The cases are randomly generated so each time it asks for different fields. If you get the "Unexpected rows" response it means (in this specific case) that your ordering is probably off which causes LIMIT to return different rows then expected. If you'll email me the brief and your query I'll be able to assist.
John Tribe
I would say that it is a bit boring for advanced user. Maybe optimization queries would be great, like find why this query is slow (should be on TRY) . It would be great to have detective help in solving case after 10 minutes or special button to solve the case with explanation. I missing some story in background as well (but this is only my interpretation). But for new people to learn SQL this is great. Great Idea.
Doron Linder
SQL Police Department
Maker
@john_tribe Thank you for the feeback :) Guided help / explanation is a great idea! The story would become more interesting once the queries are more complex (with joins for example). Not sure yet if optimisation queries would be in scope. Maybe after all the basics are covered.
12
Next
Last