What about your SQL skills ๐Ÿ˜ˆ

โ˜•๏ธ Can I wake you up and you write me a LAG Window function barely awake?

I could not do thatโ€ฆ

I asked some weeks ago for good SQL learning resources. Souheil Ben Slimane got back to me with the udacity SQL course:
https://www.udacity.com/course/sql-for-data-analysis–ud198

This is based onย Modeย SQL course and it is a great resource for getting started with SQL or fresh up some parts. Short and well done lessons. Best way to get started.

For everyone looking for more complex and actionable lessons. I have found something at the place I mostly find stuff: Youtube.

https://www.youtube.com/channel/UCW8Ews7tdKKkBT6GdtQaXvQ

Nate from StrataScratch is showing how to solve interview question from big tech companies for data science or analyst positions. These are perfect examples to see how to work with sub-queries (I still prefer CTEs), different window functions, case statements โ€ฆ and much more stuff.

This helped me a lot to get some new SQL skill.