Hey Blinders, I have a interview call from Amazon for BIE, which is initially phone interview round for now. But I am looking for tips to study for DE interview in FANG. I have completed all the levels of SQL question on leetcode so far. Anything else you recommend for SQL? What all do you suggest to prepare for coding round? What topics and resources should I refer? Any tips would be very helpful, thanks in advance! P.S looking to make a next move in FAANG
SQL. Find the top x in list.
Anything else? Like CUBE ROLL UP write procedure, Quote and sort of?
Window functions are popular if the interviewer is extra cranky that day. Haven't seen a roll up question Inna while. You'll get a few basic questions on db optimization (index, different types of joins). Olap vs oltp
Have you checked Glassdoor Qs and rooftopslushie.com?
I did check GQ.. Never used rooftopslushie.com
Does someone have a good resource to practice the Sql questions there are likely asked for these kind of role by companies ?
Sqlzoo
Practice Gaps and Islands SQL problem
Thanks! Any other problems?
You have python exp too?