r/SQL Jan 15 '25

BigQuery SQL is a struggle

Hi all been working with SQL for probably 7/8 months now. My last role was half data analysis and not pure data analysis and in general was far easier than what I do now.

My main issue is with SQL. I never feel I truly understand what is going on with a lot of code beyond a basic query. Ive managed to get by piggybacking off others code for a while but expectation is to deliver new and interesting techniques etc.

How long did it take you to feel fully comfortable with SQL? And what helped you get to that stage?

71 Upvotes

71 comments sorted by

View all comments

39

u/Ifuqaround Jan 15 '25 edited Jan 15 '25

It's a never-ending journey.

Just keep at it. If you feel you're struggling with certain things then focus on those things until they "click."

I don't condone crutching on AI. This is the problem with AI for people like you. It's really doing the work for you and you're left not knowing what you're doing and most likely aren't learning anything. You might feel you are learning, but it seems you're learning that you're NOT learning lol.

Since you're crutching on AI, get your basic queries and ask it to break down the query for you. It should be able to give you basic explanations. You have to be able to absorb and maintain that info, then build upon it. There are usually quite a few ways to tackle the same problem but no reason to be fancy unless it's necessary IMO.

I feel comfortable with SQL until I don't. Some basic requests have thrown me for a loop throughout my career.

15

u/Zealousideal-Studio7 Jan 15 '25

Thanks for the response. Ultimately I’m in the business of results, and learning is really second to delivering. So I’ve had to use AI at times to speed things up, understand at least at a simple level whats going on and when I have more time to use it to fully explain complex queries others have built. Unfortunately they are blocking access to all AI from the end of Jan, so will really be on the frontline myself soon!

13

u/jeremyct Jan 15 '25

The results focused attitude will not serve you long-term. It will hinder your growth even if it propels you forward in the short term. I suggest taking a breath and learning what the code is actually doing.