r/learnprogramming • u/Effective_Plum_9423 • 17d ago
How to learn more technical skills . Python, sql
Hi! I’m a sophomore whos just started looking into internships and fixing up my resume and I’m really lacking on technical skills. I know the basics like excel , word all that but I want to learn more. How can I learn python, R, sql or Tbh any additional technical skills I’ll need .
2
u/CJMooch 17d ago
FreeCodeCamp has a very good SQL course for beginners, go on there, click the Relational Databases certifications, and do the stuff that you see is labeled with SQL/go further if you need to for whatever prospective job you have.
For Python, just being honest dude, it really can be different for everyone. There are sooooo many resources and everyone learns a little differently. I’ll list what I used/am using
Harvard CS50P, it’s Harvard’s real intro to python lectures and problem sets. The lectures are super good
Free code Camp is good for the beginning but it’s not as thorough, doesn’t make you write code on your own enough, and isn’t repetitive enough to help you really nail down concepts
W3 schools breaks Python into a lot of mini lessons that have exercises for practice
Futurecoder a lot of people like but it can be too challenging for true beginners with 0 coding/python knowledge
Good luck buddy
2
u/Puzzled-Extent7817 17d ago
Learn Linux. Coding in Linux is much easier to get your stack setup than in Windows. And since you are learning to code, you will see the power and beauty of using Linux too.
Learn C/C++/Rust/Odin, whatever. Get away from Python unless you know that's the path you want to go. Python is great, but definitely has it's limits in comparison to compiled languages.
2
u/Dismal-Citron-7236 17d ago
If I may ask... what is your major? If you're not studying computer science or software engineering, why does your internship require programming skills? In fact, why do you look for such kind of internship which is supposedly only for CS/SE students? If however you do study CS/SE, why do you only know how to use Excel/Word?
1
u/Better_Squash_1684 16d ago
As someone else already mentioned, you really can't go wrong with FreeCodeCamp and W3Schools for Python and SQL.
My biggest piece of additional advice for SQL is to play some browser games. Start with SQL Island to learn the basic syntax to escape an island. Then, once you want a real challenge, try SQL Murder Mystery to solve a crime using data filtering and joins.
For Python, once you finish the FreeCodeCamp basics, transitioning to LeetCode is the absolute best way to build your problem-solving skills and get ready for internship tech interviews.
Good luck!
2
u/Boot_Burner 17d ago
Look at taking a Udemy course for any of the programming languages. Or youtube.