Re:Show HN: Select Star SQL, an interactive SQL book
by AlisdairO on Monday September 03, 2018 @10:26PM
(#17906187)
(self plug) pgexercises.com provides something like this.
The code is open source, anyone is welcome to fork and populate with new data like this.
Re:Show HN: Select Star SQL, an interactive SQL book
by pixelperfect on Monday September 03, 2018 @10:46PM
(#17906249)
I learned SQL mostly by using your site, thank you for making it!
Re:Show HN: Select Star SQL, an interactive SQL book
by dwdz on Tuesday September 04, 2018 @07:46AM
(#17908312)
Me too! Thanks Alisdair!
Re:Show HN: Select Star SQL, an interactive SQL book
by AlisdairO on Tuesday September 04, 2018 @11:04AM
(#17909521)
pleasure, glad you both found it useful :-)
Re:Show HN: Select Star SQL, an interactive SQL book
by SmirkingRevenge on Monday September 03, 2018 @11:26PM
(#17906405)
One option is to learn on bigquery (a google cloud service) - its "pre-loaded" with all kinds of public datasets that you can just start querying, with a web interface for doing sql.
Its pretty easy to stay within the free tier (1TB of data per month)
Re:Show HN: Select Star SQL, an interactive SQL book
by zckao on Monday September 03, 2018 @10:32PM
(#17906208)
All the blue boxes are actually interactive code editors. You can run arbitrary queries against the dataset in them. I changed some of the wording to make it clearer. Hopefully that helps!
Re:Show HN: Select Star SQL, an interactive SQL book
by paulrd on Monday September 03, 2018 @11:03PM
(#17906302)
I was wondering what you were talking about. What blue boxes? Then I saw the problem. The boxes showed up in Chromium but not Firefox.
Re:Show HN: Select Star SQL, an interactive SQL book
by bhrgunatha on Tuesday September 04, 2018 @12:07AM
(#17906563)
Same here - the front matter page mentions web components - perhaps the support is different /disabled in Firefox?
The <sql-exercise data-question...> elements aren't visible in Firefox at all.
You say that: "Programming is best learned by doing", but I am struggling to do anything...
It would be great if there was some online area like SQL Fiddle with the data loaded, so I can run queries and see results in my browser without having to set anything up or am I missing something.