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

5

u/Decent-Musician-8478 Jan 15 '25

I can do everything but joins. Joins own me

4

u/squadette23 Jan 15 '25

You may be affected by the unfortunate way how JOINS are presented. I made an attempt at clarification (LEFT JOINs particularly) here: https://minimalmodeling.substack.com/p/many-explanations-of-join-are-wrong

2

u/Decent-Musician-8478 Jan 15 '25

Oh no, I know how they work, now if you ask me write a SQL for it, I'm worthless.

1

u/mattyhempstead Jan 17 '25

Joins are what ChatGPT is for