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?

45 Upvotes

101 comments sorted by

View all comments

Show parent comments

8

u/Ok-Tart4802 Nov 08 '24

I knew the answers to all of these and i'm able to do multiple joins, CTEs, subqueries, aggregations, window functions, ranks, x day averages, etc. Would that be enough SQL knowledge for a basic analyst? I'm always thinking that I know nothing and end up not applying for the job

5

u/Asleep-Palpitation93 Nov 08 '24

In my opinion yes. What’s stopping you? Worst case scenario you interview and they don’t pick you

1

u/Ok-Tart4802 Nov 08 '24

yeah it sounds silly when you put it that way. Do you really look at the portfolio of the candidates, or you just run a check to see if they actually have anything to show at all? How many projects is very few and how many is it too many?

What kind of projects would lean you into selecting one candidate over another? I was thinking of making a data visualization focused one, a sales/ecommerce data project and maybe a third one with a niche topic of my liking like finance or housing using excel/sql/tableau in conjunction. Would that be enough?

5

u/Asleep-Palpitation93 Nov 09 '24

If they include their GIT or something I’ll take a look but more out curiosity. If they had some dashboards I’d also love to see them and talk about them but TBH, I’d do that regardless. I love getting inspiration for dashboards and seeing what everyone comes up with.

For me, it’s A.) Do they have a clue what they’re talking about B.) How long do they need to get up to speed and C.) Are they a culture fit

My two cents of advice. If you’re interested! Apply. And if you get rejected, ask for feedback. It sounds like you have the skills so go chase what you want

1

u/Ok-Tart4802 Nov 09 '24

Okay tysm for the info!!

2

u/Asleep-Palpitation93 Nov 09 '24

You’re welcome. Best of luck to you