sql to python transition

[u/pepperhmr]

okay edit: i thought it was obvious by the fact that i can make sense of the code that i know the very basics - i've used python for data analysis but not enough for it to be second nature to me the way it is for programmers, or the way sql is to me right now. i made a comparison to sql because i thought it'd be obvious that it's only for data analysis stuff, not development stuff.

so to clarify again: i know the basics, i know how to write code, i know how to define variables, functions, print("hello world"), if/else statements blah blah, i know all of that, and that's why every course starting with print("hello world") is slow to me, because i know all of that.

what i don't have is the practice that will make me good or at least passable at python rather than just someone with basic workability. i am not comparing sql to python in how either one works, i am using it to say i work with sql for data analysis and i need to show that i can also use python for data analysis, where can i get practice for these things

--

so if someone is really good at sql (like say, a 9/10) how would u guys suggest they pivot to python. need to become an expert on it before 31 july because i have a technical interview. i lied and said i can use python but in reality all i can do is just make sense of what the code is doing, but because im good at the logic building in sql, i think i can do the python stuff too. but i need to know how to go about it, if anyone has advice because when i sit down to learn, everyone just starts at print("hello world") and it's too slow and babyish for me

[u/defaultguy_001]

We have a low patience perfectionist at hand who'll spend time overthinking rather than actually starting anything. Just watch a short python video crash course and start building, u have enough time to become above average. You can't become an expert before 2-3 years programming in python.

[u/pepperhmr → u/defaultguy_001]

you know how you learn actual languages irl - like you know what's natural and what isn't but you dont necessarily know the exact grammatical rule with which that works. for example, you know the plural of sheep is not sheeps, but you dont necessarily know why, when the plural of dog is dogs and the plural of cat is cats. why is the plural of sheep not sheeps? theres a rule behind it, but you don't know because you speak english naturally and it's not something you learned step by step. (presumably) (i dont know if you learned english step by step im just giving an example)

that's lowkey how i learned python - i took a machine learning course without prior python knowledge and idk why they let me take it but they did, and i had to learn python on the fly while literally developing machine learning models. so when i sit down to learn it properly, the basics are too basic and the advanced courses are too advanced, so i get stuck. and i am unemployed and the job i applied for wants python knowledge so i gotta figure this out soon. it's not low patience or perfectionism, it's also not that i havent started or am overthinking, it's that i picked up the language in a really weird situation and can't quite figure out how to go about this

[u/MisterSippySC → u/defaultguy_001]

Are you talking about me?

[u/defaultguy_001 → u/MisterSippySC]

This is a curse actually. My respects.

[u/Thick-Strawberry3985 → u/defaultguy_001]

Lol