PeterI think a problem I have with the idea that you can teach yourself stuff in IT through personal, private study is that yeah, you can, but if you don't use it, you forget it. can I learn window functions in SQL? sure! and I can spend a couple weeks doing exercises and maybe even a project. but then when I move on to learning PySpark and BigQuery and asychio and whatever else, within a couple months I don't remember how to do window functions.
Jonathan Joelson@peter All the Haskell, Lisp, an C that I wrote in college is not directly related to my career, but learning those languages still helped develop my understanding of many software concepts.
Yes, you will not be able to sit down 3 years from now and immediately bang out a query with window functions, but your brain has still learned the *concept* and you will recognize parallels when encountering similar things in the future.