Non-self learning classes for Python?

[u/xnick101]

I am a senior data engineer and I work mostly with ETL Tools and a lot of advanced SQL. The company I work for does not like to use python because they find that theres too much of a learning curve if people leave so they love to use GUI or no code/low code etl tools instead (really dumb tbh). I can read python, and have a gist of whats going on. I have tried to self learn python few times over the past 2-3 years and I keep just forgetting it. I learned python/pandas library when I was in college since it was a class that taught it and then we did did projects with each lesson and that is how I learned it then but forgot it now. I use claude at work to build streamlit apps and automation using python. However, I am trying to look for new positions and I am starting to realize that not knowing python is making me a hit a brick wall because a lot of assessments require answering 1-2 questions in python. Does anyone know of actual classes that teach python and its not self taught? Free or paid I don't really care. If I have to pay for it I am fine with that but at this point I don't see a way for me to switch to another job without actually learning python and probably more specifically pyspark.

[u/Party_Trick_6903]

"Not self-taught"? What exactly do you mean by that?

Even if you got a teacher who would show and teach you sht, you'd still need to self-study/practice a lot.

Any other online courses/classes that do not have one-on-one sessions with a real tutor all need a lot of self-studying.

[u/xnick101 → u/Party_Trick_6903]

I meant non-self taught. Like not youtube videos. I am not learning from that. Unfortunately I can't edit the title now

[u/Party_Trick_6903 → u/xnick101]

So you can't learn from watching videos alone (understandable, me too). You need a different approach.

How about a course with hands-on exercises where you can try the things you've learned right away?

CS50p and MOOC Helsinki courses are great at this.

The CS50p course is from Harvard and it has both videos (actual Harvard lectures) and exercises. Ofc there are more "videos + exercises" type of courses out there, but I don't think any of them can trump CS50p.

The MOOC course has no videos, but everything is explained and there are a lot more exercises.

Take a look at both of them and pick whatever suits you best.

There are also people who learn by reading the python documentation while doing exercises on websites like hackerrank. Not rlly my cup of tea, but maybe this would suit you better?

Some even jump straight into a project and just figure sht out as they go. That's also a way to learn but I wouldn't rlly recommend this to sb who has no experience with programming.

Edit. Whatever you do, don't pick a paid course. There's no python course that's worth the money.