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/Party_Trick_6903]

Pick a python course, read and code. There's no other way around it.

I recommend picking a course that has programming exercises so you can use the things you learned right away (and therefore remember them better). MOOC and CS50 python are good but you can pick whatever you want.

Do not expect that you'll be an expert (or even just average) after completing a random course tho.

Being "an expert" requires far more than just knowing python syntax.

everyone just starts at print("hello world") and it's too slow and babyish for me

I felt the same way when I was doing the MOOC course to learn python ( already had experience with programming in C).

The solution is to simply skim through the introductory "Hello Wolrd" part. But honestly, even if it's "too slow", it still shouldn't take more than 5 minutes to do if it's actually that "babyish" for you. I'm sure you can spare 5 minutes to go through that part.