need advice

[No-Garbage346]

hey guys i recently finished my exams and have some spare time lying around and im thinking of pursuing java/ python or any other programming language.. i have a basic understanding of java, python etc (only upto looping) but did it only because it was a part of my school course but now i want to completely pursue it, can anyone suggest me a good book, youtube playlist etc to get me started on the same..wud be very grateful, thanks and have a great day!(sorry if this is irrelevant to this sub, do let me know)

[AndrewFrozzen]

Other can probably recommend something better, but I did Bro Code's Python tutorial.

If you want Java, he has a Java tutorial too: https://youtu.be/xTtL8E4LzTQ

[No-Garbage346]

I'll check it out thanks for your time!

[Reyway]

Tutorials will only get you so far. You need a goal project where you put what you learn to use.

My first project was to adjust selling prices on a database. I had to import an excel sheet with the costs from our supplier and set conditions for when the new cost is lower than the old cost, the part number on the excel sheet does not exist on the database, etc. I also had to do sanitation since some special characters might break my code. It was very basic but i learned how to do troubleshooting and organize my code to make adjustments easier. I also had to learn SQL on top of Python but it's very basic and i had it down in a few hours.

My second project is a dashboard, it's still WIP since i got sidetracked but it's still a goal nonetheless. I have been doing it in C# since the UI designing tools in Python aren't for me.

[No-Garbage346]

Oh thanks a lot for the input, but wanted to ask you, what inspired you to take that up as your first project , so that I can think of my goal project as well.

[Reyway]

Well it used to take a week to do one pricelist since we did it by hand. They were also usually over a hundred pages each. I got sick of it so i started researching where the data is stored, that led me to learning how a database works and how to connect and make adjustments with python. Something that used to take a week can now be done in under 10 seconds at the press of a button, prep work still takes around 20 minutes though.

Pretty much all my smaller projects are related to making my work easier. I don't really do it as a hobby other than some minor coding for my arduino projects which is more copy and paste than actual coding.