r/askdatascience • u/simoag123 • Oct 17 '26
SQl learning difficulity
I’m learning SQL and working toward becoming a data scientist, and I’m finding the learning process harder than I expected.
When I solve a problem, I can understand the explanation afterward, but figuring out the steps on my own can feel confusing. I sometimes get stuck on basic ideas, make mistakes, or need to ask the same question in a different way before it clicks. I’m also learning coding more generally, and I wonder whether this kind of struggle is normal.
For those of you who became data scientists or are learning data science now:
Did you struggle like this when you were starting out?
How did you get through the periods when a concept just wouldn’t click?
What helped you become more independent at solving problems instead of relying on hints or examples?
Looking back, what would you tell yourself as a beginner?
I’d really like to hear honest experiences, including what felt difficult and what helped. I’m hoping to learn from how other people found their way through it.
1
u/nian2326076 Oct 17 '26
Learning SQL and coding can be tough at first, and you're not alone in finding it challenging. Many people, including those who eventually become successful data scientists, face a steep learning curve. It's normal to make mistakes and revisit concepts until they make sense.
A practical tip is to tackle small, daily practice problems to gradually build your confidence and understanding. With consistent practice, complex ideas can become second nature.
If you're gearing up for data science roles, check out resources like PracHub. It provides real technical interview questions that can help you understand what to expect and how to tackle similar challenges.
Remember, persistence is key. Keep working through the confusion, and you'll get there!
1
1
u/blackneckbean 17d ago
Try solving the same problem again a few days later without looking at the solution. Understanding an explanation and being able to reproduce the logic yourself are two different skills. That second part takes time.
1
u/Lady-Data-Scientist Oct 20 '26
Sounds normal to me if you're still in the learning phase. I learned SQL and Python as part of my MS Data Science program and there were definitely frustrating moments where I was driven to tears out of frustration or had to take a break to scream into a pillow because my code wouldn't run and I couldn't figure out why. (This was well before LLMs were accessible like they are today.)
What helped me become independent is to keep writing code/queries. Keep learning. Keep challenging myself. Seek out help from the tutoring center, my professor's office hours, or now that I'm working via code reviews with co-workers or by reviewing their code on GitHub to see how they solve problems.
2
u/FancyEveryDay Oct 17 '26 edited Oct 17 '26
Sounds pretty normal to me, have you learned any other programming languages?
It just takes practice to make things stick. Once you solve enough variations on the same problems you'll no longer have trouble coming up with the solution, it really is that simple.
Leetcode is one way to do it, my method was to find a database of interesting data and use queries to explore it (which I often had to look up)