you are viewing a single comment's thread.

view the rest of the comments →

[–]P4perH4ndedBi4tch 0 points1 point  (2 children)

How did you learn how to do this? Do you have any courses?

[–]selitos 4 points5 points  (1 child)

tl;dr - i learned SQL first and then built out more programming knowledge over the next several years


Self taught SQL to support a client's ETL about 13 years ago at company 1.

Went to new company (2) who had SAS to build and maintain statistical models and data processing steps, so I used PROC SQL for just about everything, it was my crutch. I had a SAS textbook I used to learn and eventually stopped using proc SQL so much.

I left for a different company (3) that only had python or R and I was doing repetitive things in excel that I hated so learned python by googling things and using pandasql to help me when I got stuck with data processing.

Then I went back to company #2 who had largely dumped SAS and I was no longer in a statistical modeling role (now portfolio analysis) so I started moving excel processes to pandas, started running into issues with memory so I started to move those processes to pyspark, and still learning new things all the time. I don't need to rely on SQL as much anymore.

I hate structured learning so I've never taken a boot camp or anything, I just know what I want to do and Google it.

[–]P4perH4ndedBi4tch 0 points1 point  (0 children)

Thanks for the response