[HN Gopher] Ask HN: Are there any websites for SQL puzzle games?
___________________________________________________________________
Ask HN: Are there any websites for SQL puzzle games?
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!
Author : novoreorx
Score : 30 points
Date : 2024-02-29 09:32 UTC (1 days ago)
| speedgoose wrote:
| A few of them exist. I played a bit on the SQL section of
| HackerRank in the past: https://www.hackerrank.com/domains/sql
| novoreorx wrote:
| That is an excellent source. I'll explore it a bit.
| Leftium wrote:
| 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.
| shouldnt_be wrote:
| I often use https://pgexercises.com/ to refresh my knowledge
| PascLeRasc wrote:
| Select Star SQL is pretty interesting, but short -
| https://selectstarsql.com/beazley.html
| arono wrote:
| I've had fun going through SQL Murder Mystery
| (https://mystery.knightlab.com/)
|
| I even use it for hiring exercises.
| jiehong wrote:
| 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
| saulpw wrote:
| 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.
| jiehong wrote:
| Thanks for that!
|
| I really enjoyed doing it when it was released!
|
| Looking forward to the next one
| SJMosley wrote:
| Going through Hannukah of Data was so fun! Thanks!
| anjakefala wrote:
| If you subscribe to the newletter here:
| https://hanukkah.bluebird.sh/about/ =) You'll here about our
| next datagame.
| gabrielsroka wrote:
| Might be somewhat helpful
| https://www.khanacademy.org/computing/computer-programming/s...
| yurpree43 wrote:
| Codesignal has a fun Database "Arcade"
| https://app.codesignal.com/arcade/db
| uncharted9 wrote:
| Thanks everyone who have commented all these sites. I wanted to
| brush up SQL for interviews and these will help a lot.
| Cheezmeister wrote:
| Thanks for asking. Had a similar issue--no avenue to practice
| queries intentionally, outside of solving a real-world problem
| with all the confounding factors that entails.
|
| Nice options ITT.
| roland35 wrote:
| This SQL murder mystery is fun and helpful!
| https://mystery.knightlab.com/
| geshan wrote:
| Not a game but a great way to learn SQL is https://sqlbolt.com
| jasonpeacock wrote:
| A coworker used to solve Project Euler[1] problems using SQL
| while they waited for DB indexes to rebuild or tables to restore
| from backup in the middle of the night.
|
| [1] https://projecteuler.net/
___________________________________________________________________
(page generated 2024-03-01 23:01 UTC)