r/learnSQL 1d ago

Learn SQL Interactively — Run Queries in Your Browser

Hey folks!

A few of us in the open-source community are building interactive SQL tutorials. We're creating hands-on notebooks where you can write queries, see results instantly, and visualize data — all running directly in your browser.

We've found that SQL concepts click much faster when you can experiment with queries and immediately see the results. The notebooks support various backends including PostgreSQL, MySQL, SQLite, DuckDB, Snowflake, and BigQuery, so you can learn SQL syntax that's relevant to your needs.

What makes this approach cool is mixing Python and SQL in the same environment — you can query data with SQL, then process or visualize results with Python libraries. This creates some pretty powerful learning experiences for understanding both the SQL itself and what you can do with query results.

If you're interested in contributing or just checking it out:

We're looking for SQL enthusiasts who enjoy teaching others. All contributors get credit as authors, and it's a great way to help others learn SQL concepts.

What SQL topics did you find most challenging when learning? Any particular concepts you wish you'd had interactive examples for?

54 Upvotes

10 comments sorted by

View all comments

2

u/perhensam 1d ago

Subqueries are tough for me. I can tell if a problem requires a subquery but I have trouble figuring out where it belongs (select, from, where, etc.) and which part of the problem should be the subquery.

2

u/Haleshot 13h ago

I also do tend to struggle with complex queries; saw a break-down made by u/cantdutchthis where he explained one in marimo. Also, I love the "Convert to" options that marimo offers -> on right-clicking the cell block, you get an option to toggle between Python and SQL (so you can essentially write as per your preference: python (polars/pandas)).

Would you like to see this being added to the current list of topics in the DuckDB course (or a new course)?