Resources
WARNING
There are many free resources of learning each of these sections. The problem is that there are too many of them. Some good, some bad and some outright detrimental to your motivation ...and worse they are being promoted as good resources by friends/collegause on linked in without understanding the content.
What happens when you see a free coursera course with good ratings and you start learning. Since either the instructor is bad. Or the content they are coering is bad. Or both! What happens is you think you can not do it and your motivation dies down. May be you think SQL is very complicated or may be you think python is really difficult to understand.
Remember languages or any software are just tools which are made humans. so anyone can learn it quickly. To fix this problem this page is here. Each of the resources here have personal tested. I am not listing any of these resources because they are my friend or colleague. It happened with me. For the first time i started learning python it was during covid and some website e had made their courses free. The result i picked a python course and the instructor was so bad that i almost puked! I tried to learn pyton for a week and gave up! This is what happened when you stumble on a bad course. I later picked up python from Udemy's $10 course! I even refer to this course from time to Time.
Tricks
Note that you do not have to finish each course or book. Also you do not necesarily need to get these books. Since at hackds, my main aim is for my readers to get the job they want quickly without learning the fluff which is not needed.
that is why for each of the courses and books I have listed the chapters or sections to do rather than the whole course.
SQL
There is a reason you see SQL is at the top since this is the most tested section in data analyst and data scientist interviews.
How to prepare:
Websites to learn SQL:
Websites to practice SQL:
Python
Courses:
Product SENSE
Courses:
A/B Testing
Courses:
StatisTICS
Courses:
PROBABILITY
Courses: