News for hackers. Stuff that matters.
Re:Ask HN: What is the best online resource to learn advance... by AlisdairO on Tuesday January 17, 2017 @12:21PM (#13419240)
[self plug]

On https://pgexercises.com I focus quite a bit on developing a mental model for SQL. I would suggest not skipping the easier exercises - even if you can do the SQL, you might find the explanations useful.

Re:Ask HN: What is the best online resource to learn advance... by mlinksva on Tuesday January 17, 2017 @07:36PM (#13422975)
I worked through many of these when discussed here 7 months ago https://news.ycombinator.com/item?id=12022953 ... really enjoyable, great refresher, and learned some things I never knew before.
Re:Ask HN: What is the best online resource to learn advance... by AlisdairO on Thursday January 19, 2017 @09:52AM (#13436198)
Thanks :-)
Re:Ask HN: What is the best online resource to learn advance... by shiny on Tuesday January 17, 2017 @02:06PM (#13420153)
Man, thank you so much for creating this. You should find some way to monetize it. I thought I had a decent grasp of SQL before, but this is what really helped me grok it ... especially the consistent 'everything is table' lesson.

Oh and I had an idea for practicing deletions/insertions/updates & other behavior that you couldn't do on web: create an Electron app that uses a local db. I'd buy that in a heartbeat.

Re:Ask HN: What is the best online resource to learn advance... by AlisdairO on Tuesday January 17, 2017 @05:45PM (#13422210)
No problem - it's really gratifying to know that it helped you. I'm not so interested in monetizing - I've received an awful lot from the wider OSS community, and I did the project as a way to give something back.

That is a really good idea on the app. I do have some ideas for making DDL and DML available via the web interface, but sadly I'm extremely short on free time in the last couple of years.

Re:Ask HN: What is the best online resource to learn advance... by afarrell on Wednesday January 18, 2017 @03:07AM (#13424868)
> extremely short on free time in the last couple of years

I wish you and the flexboxfroggy guy has a patreon account so I could pay y'all to make games/exercises that improved my mental model of things.

Re:Ask HN: What is the best online resource to learn advance... by AlisdairO on Wednesday January 18, 2017 @01:43PM (#13429036)
I'm fortunate in my career - while more money is always nice, I'm at the point now where it would have to be an awful lot to persuade me to take more time away from my (very young) family. I suspect all a patreon would accomplish would be my still producing slowly on the site but now feeling guilty about it :-).

Maintaining the site is in many ways its own reward - it gives me a great deal of joy to see how much it's used now. Improvements are actually a reasonably high priority for me, it's just that toddlers have a way of creating their own special priority levels :-).

All that said, I very much appreciate the sentiment!

Re:Ask HN: What is the best online resource to learn advance... by MistahKoala on Tuesday January 17, 2017 @06:12PM (#13422406)
I've been looking for stuff like this - thanks.

I'm trying to start a career as a BA and expect that it will be handy to know SQL, which is fine, but I haven't been able to find anything out there that simulate the kind of scenarios and tasks SQL would be used in. I suppose your site is a step closer to that.

Re:Ask HN: What is the best online resource to learn advance... by minhaz23 on Tuesday January 17, 2017 @06:18PM (#13422448)
Hows the step into BA going for ya? What kind of things besides SQL do you have to learn?
Re:Ask HN: What is the best online resource to learn advance... by MistahKoala on Tuesday January 17, 2017 @10:53PM (#13423832)
Not great! Plenty of vacancies for BAs and junior BAs alike, but they all stipulate experience. I've been looking for graduate BA vacancies, but - outside of London - they're few and far between. A few BA roles are also quite heavy on the numerate side of things, which I have to cast aside.

Aside from SQL, I've got UML and Visio on my to-do list. There's also the BABOK reference, but it sounds like it's something that only really starts to make sense when you have something to apply it to and observe.

Re:Ask HN: What is the best online resource to learn advance... by AlexAMEEE on Wednesday January 18, 2017 @04:11PM (#13430314)
You could also add some ads, I'd gladly deactivate my adblocker, a site that produces so much value should get something in return.

Great site, thanks

Re:Ask HN: What is the best online resource to learn advance... by pinouchon on Tuesday January 17, 2017 @12:37PM (#13419388)
I second this. A few months ago, I went through all the exercices (completing everything but 3 of the most advanced).

Very easy to get going and very hands-on.

Re:Ask HN: What is the best online resource to learn advance... by AlisdairO on Tuesday January 17, 2017 @05:47PM (#13422221)
Thanks, appreciate it :-)
Re:Ask HN: What is the best online resource to learn advance... by rorykoehler on Tuesday January 17, 2017 @07:00PM (#13422754)
This looks great. Exactly what I'm looking for. Thanks.
Re:Ask HN: What is the best online resource to learn advance... by AlisdairO on Tuesday January 17, 2017 @08:39PM (#13423311)
No worries - hope you find it useful.
Re:Ask HN: What is the best online resource to learn advance... by gidan on Tuesday January 17, 2017 @04:54PM (#13421705)
(Top menu broken on IOS iPad)
Re:Ask HN: What is the best online resource to learn advance... by AlisdairO on Tuesday January 17, 2017 @05:46PM (#13422217)
Thanks - I'll try to get hold of an ios device to test it on. Sadly my webdev skills are fairly lol-worthy ;-)