4 ms·

I really like your explanations. I have never been able to wrap my head around joins. You say that: "Programming is best learned by doing", but I am struggling

by dawie 8y ago

I really like your explanations. I have never been able to wrap my head around joins. 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.

geomark 8y ago
sqlzoo.net might be something you would like.
AlisdairO 8y ago
(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.
- pixelperfect 8y ago
  I learned SQL mostly by using your site, thank you for making it!
  - dwdz 8y ago
    Me too! Thanks Alisdair!
    - AlisdairO 8y ago
      pleasure, glad you both found it useful :-)
zckao 8y ago
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!
- paulrd 8y ago
  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.
  - bhrgunatha 8y ago
    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.
SmirkingRevenge 8y ago
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)
netcraft 8y ago
My favorite version of sqlfiddle is dbfiddle.uk. Lots of databases and generally fast.