<story><title>Ask HN: What is the best online resource to learn advanced SQL?</title><text>I too often find myself getting stuck when it comes to more advanced SQL queries. I have never actively learnt SQL and realise that I don&amp;#x27;t have a great mental model of how it works. I would like to improve this as it is killing my productivity from time to time.</text></story><parent_chain><item><author>AlisdairO</author><text>[self plug]&lt;p&gt;On &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;pgexercises.com&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;pgexercises.com&lt;/a&gt; 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.</text></item></parent_chain><comment><author>mlinksva</author><text>I worked through many of these when discussed here 7 months ago &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;news.ycombinator.com&amp;#x2F;item?id=12022953&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;news.ycombinator.com&amp;#x2F;item?id=12022953&lt;/a&gt; ... really enjoyable, great refresher, and learned some things I never knew before.</text></comment>
<story><title>Ask HN: What is the best online resource to learn advanced SQL?</title><text>I too often find myself getting stuck when it comes to more advanced SQL queries. I have never actively learnt SQL and realise that I don&amp;#x27;t have a great mental model of how it works. I would like to improve this as it is killing my productivity from time to time.</text></story><parent_chain><item><author>AlisdairO</author><text>[self plug]&lt;p&gt;On &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;pgexercises.com&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;pgexercises.com&lt;/a&gt; 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.</text></item></parent_chain><comment><author>MistahKoala</author><text>I&amp;#x27;ve been looking for stuff like this - thanks.&lt;p&gt;I&amp;#x27;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&amp;#x27;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.</text></comment>