Have a SQL interview with another e-commerce company tomorrow for a data analyst role. Wonder if leetcode is enough for this kind of role?
Fizzbuzz
Is it for Wayfair? 😆
He told an eCommerce company. WayFair is a dropshopper or logistics company.
She.
You cant go to Amazon. There is a NDA.
True that. This is for a small company.
SQL topics to focus on 1. Group By ( aggregation) 2. Where vs having clause 3. Inner and outer joins 4. Union vs union all 5. Nulls , and how they affect your queries 6. Sub query, depends on your experience and their requirements 7. Case statements Good luck OP. Please let us know how it goes and also what kinda questions they asked.
I see all suggestions above related to basic SQL. In a data analyst role, you’ll often require window functions and will be tested on that.
Leetcode is for algorithms, the sql on the site is very basic.
Thank you very much!
Any recommendations on a resource similar to Leetcode for SQL?