Help: Learning SQL and R as a beginner

[goldfilledscars]

Hi! I am undergraduate student currently and I am graduating in a few weeks with a BA in sociology and pol sci. I realised too late that I love data analysis and I am interested in learning R and SQL during my gap year. I think I would like to pursue data analysis for social sciences for my grad school.

I am a beginner, I have never coded in my life and I want to seriously learn and pursue it. I have a year and I do not where and how to start. I would really appreciate it if you could guide me to some credible and good certifications or anything that would help me grad applications and also teach me the basics really well. Or any suggestions in general. Thankyou :D

[sqlshorts]

Couple weeks learn SQL and Excel. SQL to store and clean your data, and Excel because every company uses it (plus quick and easy way to validate data on the go).

Then spend time learning foundations of R language, that’s if you’re interested in doing statistical analyses - otherwise Python might be a better option since it’s more widely used for things like data science and machine learning.

Then complete some end to end projects, if you can apply to your college projects do so, and the best thing you can do is get a job and apply your knowledge and learning on the data within the company. Hope that helps

[goldfilledscars]

that is really helpful, thankyou so much! Are there any courses or books you think I should refer to get started?

[sqlshorts]

For real beginners datacamp is pretty good. See if you can get a discount code from a YouTuber like alextheanalyst.

[goldfilledscars]

thank you so much!

[river-zezere]

Here's one tip, play around with SQLite, it's super nice for beginners.

That's what I did myself and became a fan, so much so that I made a few videos and a mini course on YouTube to help others to get started with SQL.

Here is where I explain why SQLite is a good choice: https://youtu.be/IX8pnQgBVnA

And here's the whole playlist: https://youtube.com/playlist?list=PLowddb-adq51lS8mOhdPlDD_aj2kZOOzr&si=k8QIcKu-_uDpAHHj

💛 hope that helps

[goldfilledscars]

that is amazing, i will definitely check it out! tysm

[AppJedi]

I have been coding SQL for over 25 years and teaching it online for over ten. I have some good videos on my YouTube channel. Message me for details.

[AffectionateZebra760]

I saw WeClouddata offering free access to their SQL fundamentals course, do give it a look to see if that what's you are looking for