I’m working on a new tool that’s designed to help people learn SQL. Just like my last project, the focus is on learning through visualization. I’m hoping that watching how SQL manipulates data will help the concepts “click” where it might not have in a traditional tutorial.
The title that I’ve come up with is SQLAcademy. My goal is to build up a series of SQL challenges, with each challenge having an introduction that explains the concepts you’ll need to solve it.
Here’s a preview of what I’m working on.
Imagine in this example you’re asked to write a query that filters the rows down to Reddit posts that have greater than or equal to 1.5k upvotes. Assuming you wrote the correct query, this is the animation you’d be presented with.
This is a pretty simple example, but from here you’d build up to more complex queries, with each new concept having an accompanying animation.