There are a lot of courses which teach SQL but I could hardly find a website which provides beginner to advanced SQL practice questions on almost production real datasets. Any recommendations would be helpful.
I typically point folks here: <a href="https://pgexercises.com/" rel="nofollow">https://pgexercises.com/</a><p>I like it because as a beginner you can just follow the learning path. But if you just need a refresher about how to write a window function you can jump right to that section.<p>Oh, and no account sign-ups which I really appreciate.
Sqlectron [1] is a great open-source GUI SQL client that allows you to see what you're doing in real-time, which helps massively with practising.<p>You can also use it to validate what you've done using other tools. E.g. if you write some PHP or Python to interact with a database, you can open it in Sqlectron to double-check for yourself that it worked correctly.<p>[1] <a href="https://sqlectron.github.io/" rel="nofollow">https://sqlectron.github.io/</a>
hey,<p>not by itself a general resource but it's the best book on postgresql i have read recently. (i have read 2 or 3 but this stood out).<p>learning postgresql 11: <a href="https://www.amazon.com/Learning-PostgreSQL-beginners-high-performance-solutions-ebook/dp/B07NGSGBY6" rel="nofollow">https://www.amazon.com/Learning-PostgreSQL-beginners-high-pe...</a><p>i have also subscribed to the following newsletter to keep myself up to date with what is going on in the community. keep in mind that postgresql 12 has been out for a minute.<p>postgres weekly: <a href="https://postgresweekly.com/" rel="nofollow">https://postgresweekly.com/</a><p>in my mind postgresql is one of the most interesting projects out there in the open source community. and that newsletter sometimes includes articles that compares it to other big names like mysql/maria, oracle, etc. this helps expand your sql scape a little.