4 ms·
Yeah but boy can SQL be frustrating! When learning you have to balance rewarding activities with valuable knowledge and skills. Excel maybe isn't so frustrating
by odonnellryan 6y ago
Yeah but boy can SQL be frustrating! When learning you have to balance rewarding activities with valuable knowledge and skills. Excel maybe isn't so frustrating (unless you're trying to do stuff like, short-circuit "or" statements .. )
I much prefer to take the data into a language -- like Python -- and do analysis on it. Sometimes (actually, 1/10 times in my experience) this is not actually possible, so SQL is a great skill to have.
I know of three fortune 100 companies that run 100+ person departments entirely from Excel. Massive Excel files.
- tasuki 6y agoI'll take SQL over Excel anytime.
- spacemanmatt 6y agoSQL was frustrating to me when I did not know it very well. Taking the time to learn SQL (especially analytical flavored queries) and relational algebra changed not just how I write software, but how I analyze other developers. RA is one of those can't-be-unseen tools that I think everyone either learns directly or spends effort/years doing poorly.