Need help & guidance for a SQL interview at Amazon!! I have a SQL interview for the role of business analyst at Amazon. My interview will be focused on SQL for technical competency for the Business Analyst role. From what I have been told, the hiring manager will be assessing my SQL knowledge as a Business Analyst II. There will also be a live coding part. How do I prepare for it? #tech
Agreed on hackerrank and also LC or leet code has some great SQL stuff. Brush up on queries, order of operation, keys, functions, CTEs or closed table expressions, various joins, windows functions, data types etc.
Also.. the good old 'talking through your thought process', asking questions etc is always needed.. don't just write the query right away.. build it with them.. Exp from Stripe int..not from Amazon.. sorry in adv..
LC and hacker rank Easy-medium on LC I heard
Are you the owner of this ?
I just had mine for BA 2 role 2 days ago. It was really simple. They asked me questions for 15 min - basic sql theory and then 2 queries based on agg functions and 1 query based on window functions
Also gave me a data set and asked my insights on the dataset and what more I would need to make better decisions .
Check MentorColor for mock interviews
Working Parents
Yesterday
550
What do you think is wrong with a kid who got rejected by 9 colleges?
Tech Industry
Yesterday
2035
Quitting this Slave life
India
Yesterday
736
Who are these retards asking for dictatorship in India?
Work Visa
Yesterday
435
450k unique applications for H-1B this time. Did Telugus play spoilsport again?
Tech Industry
Yesterday
1616
The end of Backdoor Roth?!
HackerRank has awesome SQL tutorials. Try completing them + try to get good enough to pass the certification quizzes.