I have an onsite interview for Google in early January. One of the interviews will be on SQL. Can anyone please tell tips on preparing for the same. What kind of questions does google usually ask? The position is Revenue Analyst.
@User_824 What are the other skillsets that Google expects for business intelligence analyst?
I wish there were more analyst jobs in Seattle Google ..
I would prep by learning common ETL strategies and learn about nonrecursive / recursive CTEs
What's your background?
Degree is Computer Science. Working as a Business Analyst at Yahoo.
Why does your company say “oath”?
make sure you know how an index works and when to use it
Did you give the interview..what kind of questions were asked and how did you prepare
It won’t be difficult. You’ll get tested on joins (left/right, inner, self, etc), unions, window functions (lead/lag, etc)
You won’t get that in a sql interview
To be honest, the SQL questions on Leetcode are quite easy. The SQL questions asked in Google interviews will be tougher.