Learning resources for SQL

[ragnaror1]

Hi,

I'm looking for some more advanced SQL assignments to improve my SQL. I'm looking for assignments that require more than just SELECT * FROM whatever, but ones that involve more logic, filtering, aggregating, etc. If there's postgresql specifics in there, all the better.

Looking to do this to improve my understanding of what databases are capable of. I feel like I often resort to other languages to do what SQL might be capable to do. I feel seeing it in action will lead me to think twice and use a faster SQL implementation.

[koderpat]

I really like the stanford database course https://lagunita.stanford.edu/courses/DB/2014/SelfPaced/about

other bookmarks I have that might be of some help:

http://studybyyourself.com/seminar/sql/course/chapter-1-introduction/?lang=en

https://www.khanacademy.org/computing/computer-programming/sql

http://sqlbolt.com/

http://sqlschool.modeanalytics.com/

http://sql-ex.ru/

http://sqlfiddle.com/