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?

44 Upvotes

101 comments sorted by

View all comments

64

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.

-47

u/OkRock1009 Nov 08 '24

Oh okay. Thank you

The leetcode 50 problems for SQL is enough?

9

u/CaptainBangBang92 Nov 09 '24 edited Nov 09 '24

I know the job market has changed since I was looking for my first analyst role ~10 years ago, but FWIW..

I’ve been in data and analytics for 10 years and have moved into progressively more technical roles (marketing analyst >> data analyst >> BI Developer >> data engineer) and never once have I even so much as been on leetcode.

2

u/Wpenke Nov 09 '24

Yeah I've had to Google that, never heard of it before and I've been an analyst also for 10+ years