How advance do data science and ML interviewers expect your SQL to be, for a junior position? For example, what other topics do we need to tackle after - SELECT - Aggregates (COUNT, SUM, MIN, MAX, DISTINCT, GROUP BY, HAVING) - JOIN, UNION - Subqueries (IN, EXISTS, correlated) Is CTE, WITH important to prepare for?
It’s the analytical thinking that matters. Rest all can be googled.
Analytical / window functions are sometimes asked. Eg partition by, over
PhD?
Yes I have one
For DS just syntax of SQL... For ML rarely SQL, just LC plus AI knowledge.
Is BI the role that requires more SQL during interviews? Or is that SWE?
For BI , DE role heavy SQL is must. (LC all db problems will help). SwE you can solve the problem with any language unless the role expects you to do production level coding.
Know how to work with dates. CASE WHEN, IF, WITH etc
Ask Blinders
22h
993
Why no one cares about the lives lost in Gaza, Israel and busy in their own lives?
Tech Industry
2h
553
Brother beaten severely as a kid. Doesn’t speak to dad at all now.
Software Engineering Career
15h
1054
Why does leetcode get so much hate?
Tech Industry
21h
1661
Metamate- cringe max posts by this wannabe influencer
India
16h
908
Rahul Gandhi is poison but the people who believe in him are a lot worse
What you have listed is sufficient IF you can properly apply them to solve problems.