Where to learn advanced SQL coding
Read questions on sites like this one, Stackoverflow or other DBMS forums.

Then try to solve those problems. 

Solving real world problems is still the best practice you can have.