SQL Police Department

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

4 followers

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

4 followers

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.

Launch tags:Developer Tools•Tech

Launch Team

Thanks! It's fun. I wanted to try your product, but the site doesn't load. Do you know what the problem is?

Report

6yr ago

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.

Report

6yr ago

@doron_linder thank you, it works with vpn

Report

6yr ago

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

Report

6yr ago

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.

Report

6yr ago

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?

Report

1yr ago

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.

Report

6yr ago

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.

Report

6yr ago

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.

Report

6yr ago

SQL Police Department

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.

Report

6yr ago

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.

Report

4yr ago

SQL Police Department

Maker

I built this game to help you learn SQL in a fun and engaging way.

Report

6yr ago

Really cool way of learning SQL, congrats!

Report

6yr ago

1 2

Reviews