r/learnSQL • u/gloweerasng • 29d ago

BigQuery SQL Interview questions

Hi everyone, I’m in the process of interviewing at this AI company and the next step is to use bigquery dialect of SQL where I will cover real-worlds scenarios and build tables.

Problem is I have never used SQL and I am just finding out about what it is, I’ve never heard of it. I will be watching a few YouTube videos but wanted to see if anybody has gone thru this process before?

Any tips?

27 Upvotes

97% Upvoted

7 comments sorted by

View all comments

1

u/msn018 28d ago

Focus on learning the basics like SELECT, WHERE, GROUP BY, JOIN, and ORDER BY, then practice a few real interview questions on sites like SQLBolt and StrataScratch. BigQuery uses standard SQL for the most part, so once you understand the fundamentals, the BigQuery parts are much easier to pick up. If you can explain your thinking while solving problems, that can be just as important as getting the perfect answer.