☕️ 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:
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.
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.