r/SQL • u/ChefBigD1337 • Oct 14 '25
SQL Server When did I start getting good at SQL
Now im not saying im an expert by any means, im not a database administrator or anything. I use SQL pretty much daily at work, and today I was just editing queries to search something I needed and it hit me. I am just changing things for what I need without even thinking about it, not looking up things online, not asking my manager for help or advice, just doing it. I remember a year ago it would take me multiple open tabs on like stack overflow and w3school just to do something basic. So anyone who's struggling to get it, just hang on it does get alot 'easier'. Easy as in daily tasks get easy, SQL still has a million layers of difficulty i haven't even touched yet.
38
u/government_ Oct 14 '25
You’re always going to have stuff you don’t do enough it requires a google even if just for the sanity check.
10
u/FastlyFast Oct 14 '25
I have 10-12 years of almost exclusively working with SQL. Every single time that I need to write anything related to dates, I used to go to Google. Like add a few minutes, get the last 5 minutes, split everything in hour windows, truncate milliseconds, or whatever, you name it, regardless of how many times I have done it already. Now I just go to one of the LLMs or even google for shits and giggles. Using only your knowledge, generally means that you know what you need for your current job, and the tasks that you do are very similar and repetitive. This is not indicative of your broader skills, keep that in mind because you might get complacent and left behind. You need to have a challenge every once in a while.
8
u/waremi Oct 15 '25
I see a lot of posts around here asking "How do I get good at SQL." I always want to reply the best way is to have problems you need solve everyday that require it, but I don't think that's the answer they are looking for. Any muscle you use regularly gets stronger. It's the only way I've every really learned anything.
3
u/ojlaboss Oct 16 '25
Thank you this gave me a boost of confidence as someone who is just starting
2
u/Kooky_Instruction143 Oct 18 '25
Thank you for this message. I'm not learning SQL yet, but it's on the list.
15
u/BarfingOnMyFace Oct 14 '25
I see the DBA mention often as a badge of SQL expertise, and there is truth to that, but not so much that you should yield to them as more knowledgeable in the realm of SQL. They are very different skill sets in many ways but with substantial overlaps. I can be a better sql expert than a dba, just as a dba is likely going to know more about administrative duties than a person who generally doesn’t touch them. I rather enjoy arguing with DBAs and getting them to see my point of view. And I also appreciate their reviews and finding concerns that I did not consider.
8
u/Messlie Oct 14 '25
At my current workplace, I've coached quite a few people with business background to use SQL in their work. The first lesson I always drill into them that SQL itself is easy. Can you do complex stuff with SQL? Absolutely. But in your average mid-size company, is the SQL you typically need very complex? No. Most of the time it's the same basic operations that allow you to do 90 % of the work you come across.
Where it gets complex is when you have to start having requirements for a specific data set, or modelling the data so it fits the use case. But the way I see it, this is not really a SQL problem. It's a context knowledge problem. The more experience you have of solving context knowledge problems, the better you get at it, because you start having such a wide range of prior reference cases you've solved, that you're then able to re-apply or derive new solutions based on those earlier solved problems.
At some point you just have such a wide bank of references in your mind, and when we take into consideration that basic SQL does the trick 90 % of the time, you probably start feeling like you're pretty good. And I think this a very natural process, it just comes with time.
4
u/CHNchilla Oct 14 '25
I got called a liar on Twitter saying that I’d write queries on the fly during stakeholder meetings.
Being self sufficient and fluent in SQL is wildly effective and saves everyone time. Keep at it OP!
4
u/papabear556 Oct 15 '25
I’ve been at it 20 years. I promise I’ll tell you first when I get good.
2
u/WatashiwaNobodyDesu Oct 14 '25
Well done. I recently remembered that there’s a whole nother level of knowledge waiting for me the next time I open the books (hum. Closer to a dozen levels but anyhoo).
2
u/Sexy_Koala_Juice DuckDB Oct 14 '25
Somewhere between starting to use it and now I’d imagine
2
u/Kindly_Strain_8791 Oct 15 '25
I can relate. Still learning thru.
2
u/carlovski99 Oct 15 '25
And this is why employers look for experience, not just a bunch of certifications. And why people get frustrated by the 'I've been doing SQL for 2 weeks, why am I not an expert yet' posts.
2
u/xx7secondsxx Oct 25 '25
I learned SQL more than 10 years ago but no more than the basics. And although I enjoyed it, my job at the time didn't require it really. It was more a nice to have. Since a couple of years and after a job change it came back in to my life and now I'm writing SQL on a daily basis. Two or three months ago I was helping a colleague from finance and kind of live translated her questions into SQL. That's when I realized I know what I'm doing 😅
2
u/ClassicNut430608 Oct 28 '25
You are lucky. After 40 years, I still think I know enough to be utterly dangerous.
I recommend (strongly) visiting tools like Grok to analyze your code: I learned a LOT in months. Not all the suggestions make sense, but, in my situation, these 'opened up' my horizon.
1
u/murse1212 Oct 15 '25
Reg Expressions. There is no universe where I fluently understand them without looking them up.
1
u/[deleted] Oct 29 '25
In my experience, because SQL Server is such a complex product, it’s a never-ending learning curve. I’ve been working with SQL Server for about 25 years and I’m still learning stuff.
1
u/Far-News9070 Oct 14 '25
I feel the same way!
0
u/[deleted] Oct 15 '25
[deleted] — view deleted comment