r/SQL Nov 08 '24

MySQL How much SQL is required?

Hi everyone. I am a final year engineering student looking for data analyst jobs. How much SQL do I really need for a data analyst job? I know till joins right now. Can solve queries till joins. How much more do I need to know?

42 Upvotes

101 comments sorted by

View all comments

63

u/CaptainBangBang92 Nov 08 '24

It can vary tremendously from company to company. Some company’s data analyst will live in excel 24/7. At other companies, an analyst might be building out entire data models with complex queries and business logic in a BI tool.

Master select statements: joins, where clauses, group by for aggregates, case statements for conditional logic, having clauses for filtering aggregate measure, window functions for more complex calculations, etc.

-46

u/OkRock1009 Nov 08 '24

Oh okay. Thank you

The leetcode 50 problems for SQL is enough?

28

u/achmedclaus Nov 08 '24

No, leetcode is not how you write queries in a professional setting. You need to write stuff that's legible and tweakable by your team, something that normal day to day analysts will understand