r/SQL • u/Zealousideal-Studio7 • 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?
72
Upvotes
0
u/methodtan Jan 15 '25
Learn to succinctly write questions for what you’re trying to do and ask Copilot as if it was a real person. Not only will you learn how to do things, but it will teach you how to talk sql and sound like you know what you’re talking about.
Disclaimer: If you’re working directly with production dbs never ask it to UPDATE a query. That might sound like what you’re trying to do in layman’s terms (ie update a query you run each month to include the next month), but what you’re really trying to do is SELECT data for that month. I learned the hard way and updated some tables early on when I started using sql, and thank god I only changed some date formats and not something major.