Ask HN: Are there any websites for SQL puzzle games?

#1

Post by novoreorx » Thu, Feb 29, 2024, 9:32 AM UTC

As a Python programmer, I often use Django or SQLAlchemy ORM and as a consequence, my proficiency in raw SQL remains at a basic level. However, I am keen on improving my raw SQL skills, given it's sometimes superior to ORM, and because I find SQL and relational algebra surprisingly fun to think about.

Does anyone know of websites that provide SQL puzzle games that allow users to solve problems by writing SQL and validating them? I believe this would be an engaging way to enhance my SQL skills. Your suggestions are appreciated!

Re: Ask HN: Are there any websites for SQL puzzle games?

#2

Post by speedgoose » Thu, Feb 29, 2024, 2:24 PM UTC

A few of them exist. I played a bit on the SQL section of HackerRank in the past: https://www.hackerrank.com/domains/sql

Re: Ask HN: Are there any websites for SQL puzzle games?

#3

Post by Leftium » Thu, Feb 29, 2024, 2:42 PM UTC

SQL Police Department – Learn SQL while solving crimes:

- https://hw.leftium.com/#/item/23066776

Lost at SQL: The SQL learning game:

- https://hw.leftium.com/#/item/35665142

There are even more games in the comments.

Re: Ask HN: Are there any websites for SQL puzzle games?

#4

Post by novoreorx » Thu, Feb 29, 2024, 2:43 PM UTC

speedgoose wrote: post #2

A few of them exist. I played a bit on the SQL section of HackerRank in the past: https://www.hackerrank.com/domains/sql

That is an excellent source. I'll explore it a bit.

Re: Ask HN: Are there any websites for SQL puzzle games?

#5

Post by shouldnt_be » Thu, Feb 29, 2024, 5:52 PM UTC

I often use https://pgexercises.com/ to refresh my knowledge

Re: Ask HN: Are there any websites for SQL puzzle games?

#6

Post by PascLeRasc » Thu, Feb 29, 2024, 6:19 PM UTC

Select Star SQL is pretty interesting, but short - https://selectstarsql.com/beazley.html

Re: Ask HN: Are there any websites for SQL puzzle games?

#7

Post by arono » Thu, Feb 29, 2024, 7:28 PM UTC

I’ve had fun going through SQL Murder Mystery (https://mystery.knightlab.com/)

I even use it for hiring exercises.

Re: Ask HN: Are there any websites for SQL puzzle games?

#8

Post by jiehong » Thu, Feb 29, 2024, 8:34 PM UTC

Maybe less fun than others, but actually not so bad: leetcode [0]

Otherwise, in the same vein as the SQL murder mystery, you can try the Hanukkah of Data [1].

[0]: https://leetcode.com/problem-list/leetcode-curated-sql-70/

[1]: https://hanukkah.bluebird.sh

Re: Ask HN: Are there any websites for SQL puzzle games?

#9

Post by saulpw » Thu, Feb 29, 2024, 9:12 PM UTC

jiehong wrote: post #8

Maybe less fun than others, but actually not so bad: leetcode [0] Otherwise, in the same vein as the SQL murder mystery, you can try the Hanukkah of Data [1]. [0]: https://leetcode.com/problem-list/leetcode-curated-sql-70/ [1]: https://hanukkah.bluebird.sh

Creator of Hanukkah of Data here! We're working on another data puzzle game that we'll be announcing shortly, to be released in a couple of months. I think games like this are a great way to exercise SQL and other data skills.

Re: Ask HN: Are there any websites for SQL puzzle games?

#10

Post by anjakefala » Thu, Feb 29, 2024, 10:21 PM UTC

jiehong wrote: post #8

Maybe less fun than others, but actually not so bad: leetcode [0] Otherwise, in the same vein as the SQL murder mystery, you can try the Hanukkah of Data [1]. [0]: https://leetcode.com/problem-list/leetcode-curated-sql-70/ [1]: https://hanukkah.bluebird.sh

If you subscribe to the newletter here: https://hanukkah.bluebird.sh/about/ =) You'll here about our next datagame.