[abhishekjha]

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?

[swirepe]

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.

[wombatpm]

Database Design for Mere Mortals by Ray Hernandez. Best book I've found to give a running start.

[gordon_freeman]

https://community.modeanalytics.com/sql/tutorial/sql-data-ty...

[z3t4]

Explain the difference between INNER join and LEFT join, when you can do that you know intermediate to advanced SQL.