On a related note, Mode's SQL tutorial is the best comprehensive introduction to the language that I've come across. If you go through all of it you can get from zero knowledge to 95% of the SQL skills you'll need as a data analyst.
I am trying to learn intermediate to advanced SQL as my employer wants me to but apart from the the most basic keywords I don't see a lot of difference between Basic to Intermediate SQL. Or maybe by intermediate it means designing a good data model which shouldn't be concerned with SQL. My question is, if someone asks me to learn the advanced SQL constructs, where do I go? What do I look for?
I found that the book SQL Antipatterns helped me figure out some advanced SQL constructs. It presents a problem, shows the naive solution, takes apart that solution, and shows a better way.
Impressive tutorial! their advanced level tutorial is pretty awesome and helps someone who wants to brush up SQL skills before having analyst interviews. They even have Python tutorial too which I want to try as well.
This can't be overstated enough. Finding people who understand SQL is difficult enough, but finding people who intuitively "get" data is nearly impossible. And lately anyone who completed a few tensorflow tutorials thinks they're a Data Scientist and every single data question can be answered accordingly. Reminds me of the hadoop craze a decade ago.