Can you help me to become a SQL Guru (yes, I mean guru, Jedi master, this kind of level)?

Because of dbt or dataform more stuff which I did with python is now moving to SQL. And I need to level up my game.

I really looking into PRO source. Books, Videos, Courses… 

So, how to do crazy things with window functions, how to build complex MRR models?