Subscribe
Sign in
SQL Police Department
p/sql-police-departmentLearn SQL while solving crimes! Climb the ranks of SQL PD.
Start new thread
Doron Linder

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

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

Add a comment

Replies

Best
Doron Linder
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
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
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
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
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.
Max Hodges
UI is too tedious. Better if I could just type my SQL
Doron Linder
Maker
@max_hodges1 It's supposed to make it easier to construct queries on mobile. I'll see if I can give an option to use the keyboard without undermining this.
Brandon Hill
This is an interesting way to learn the basics of sql but I have to stress that it only covers the basics. It's still only beginner level sql and not worth $20. Once it covers intermediate and advanced concepts I can see it's value but for now I wouldn't recommend spending your money on it.
Doron Linder
Maker
@brandon_hill2 The guide tab in the game shows what is currently supported. Over time, additional material will be added. As an early supporter you get longer license and lower price.
Nisha Yadav
This is really cool! I have been trying to learn SQL from past one year but could not ace it. I hope this cool game will help me learn and ace the language.
Melissa Johnson

Has this been updated?

what do I get for the $20...


and is there a cheaper classroom fee if I want to use for mystudents?