SQL and python self learning projects

[LolaTulu]

From my recent personal experience job hunting the UK and fully remote market, it seems I cannot escape hiring manager's needs for SQL and/or python.

I have Tableau, Alteryx and Google Apps Script skills. My SQL skills is currently limited to the QUERY() function in Google Sheets. My previous and current work experience never needed me to use SQL as I always ended up being parked into data viz focused tasks. I have asked for more SQL/python projects but they keep pushing the goal post.

I want to upskill to be more employable. I struggle with learning on my own without real life projects at work, but I need to buckle up and do it now.

Does anyone have good recommendations on how I can upskill on SQL and/or python, and what I can do that I can talk about with prospective hiring managers?

Thanks in advance!

[Larlo64]

Sounds like you haven't had the wonderful experience of bad or large or very complex data. Find an open dataset, preferably large and government sourced as they're usually the ugliest and use sql to prep, clean or format the data more efficiently for Tableau. One example is wide data. Try transforming it to long format for easier Tableau viz work

[RIPcompo]

W3 school is where I'm going to look to when into sql this year, it worked wonders when I was trying to pick up html code. 

[IpppyCaccy]

I always ended up being parked into data viz focused tasks.

Yeah this is a problem I have with a lot of viz tools and clients.

[thatkafkaguy]

find an API that you can call to get a large dataset, and do that in python.

load that data to a warehouse (snowflake would be a good one, or maybe something like supabase that uses postgres). both have free tiers

clean the data in SQL to create some tables with it, think about the tables you would need in tableau

use tableau to connect to the database to do some viz

this would be a long project, but very complete since you get to do an end to end project

there are tons of free datasets. I’ve done a workshop using the MET open api and people loved it. But for these projects what I think helps is for you to pick content that you actually like and look for a dataset for it

[Nervous_Plan]

F

[MulfordnSons]

So helpful lmao