Anyone who knows Python should also strive to learn SQL, and vice versa. Tools don’t operate in isolation. Many companies have a technology stack that integrates multiple tools. This means that when they are looking for talent, they are seeking individuals who can work with a variety of tools. For those interested in working with data, both Python and SQL are essential tools to learn.
The partition example really shows where window functions shine compared to just doing a plain GROUP BY. I've seen too many people try to work around this by doing multiple separate queries or temp tables when they could've just used PARTITION BY. The running totals section is super practical too because that comes up all the time in sales dashboards and financial reports.
The partition example really shows where window functions shine compared to just doing a plain GROUP BY. I've seen too many people try to work around this by doing multiple separate queries or temp tables when they could've just used PARTITION BY. The running totals section is super practical too because that comes up all the time in sales dashboards and financial reports.
I appreciate those comments.