SQLBolt – Interactive lessons and exercises to learn SQL • Hacker News Board

SQLBolt – Interactive lessons and exercises to learn SQL

#1

Post by karimf » Thu, Jul 15, 2021, 6:52 AM UTC

SQLBolt – Interactive lessons and exercises to learn SQL
sqlbolt.com

Re: SQLBolt – Interactive lessons and exercises to learn SQL

#2

Post by marvel_boy » Thu, Jul 15, 2021, 7:29 AM UTC

Thanks a lot for this. It uses sqlite underneath?

Re: SQLBolt – Interactive lessons and exercises to learn SQL

#3

Post by fouc » Thu, Jul 15, 2021, 7:33 AM UTC

The exercises are great, and I like that the feedback is quick, as soon as you solve it you get a checkmark and it's already ready for you to do the next exercise.

Re: SQLBolt – Interactive lessons and exercises to learn SQL

#4

Post by Krizzu » Thu, Jul 15, 2021, 7:37 AM UTC

Great tool, definitely will come in handy

Re: SQLBolt – Interactive lessons and exercises to learn SQL

#5

Post by mohanmca » Thu, Jul 15, 2021, 7:40 AM UTC

Thanks! Immediately sent to my friends who are learning SQL!

Re: SQLBolt – Interactive lessons and exercises to learn SQL

#6

Post by karimf » Thu, Jul 15, 2021, 7:42 AM UTC

fouc wrote: post #3

The exercises are great, and I like that the feedback is quick, as soon as you solve it you get a checkmark and it's already ready for you to do the next exercise.

This might be one of the best example of Bret Victor - Inventing on Principle talk [0]. I wish there are a lot of tutorial or course with the same quality as this one.

[0] https://www.youtube.com/watch?v=8QiPFmIMxFc.

Original link on Vimeo is dead: https://vimeo.com/36579366.

Re: SQLBolt – Interactive lessons and exercises to learn SQL

#7

Post by tifadg1 » Thu, Jul 15, 2021, 7:43 AM UTC

very useful - immediate feedback indicates a fresh approach to an old problem!

Re: SQLBolt – Interactive lessons and exercises to learn SQL

#8

Post by wottan32 » Thu, Jul 15, 2021, 7:50 AM UTC

old but gold

Re: SQLBolt – Interactive lessons and exercises to learn SQL

#9

Post by blowski » Thu, Jul 15, 2021, 7:50 AM UTC

My favorite book for learning SQL is “The Art of PostgreSQL”. https://theartofpostgresql.com/

I found the combination of real-world problems, general SQL advice, and the broad range of topics to be a really good book. It took my SQL from “the database is not much more than a place to persist application data” to “the application is not much more than a way to match commands to the database”. It’s amazing how much bespoke code is doing a job the database can do for you in a couple of lines.

Re: SQLBolt – Interactive lessons and exercises to learn SQL

#10

Post by sparsely » Thu, Jul 15, 2021, 7:52 AM UTC

Nice and interactive, seems like a good place to start.

Although the second question ("Find the director of each movie") does accept "SELECT title as director FROM movies;" as an answer.