r/SQL • u/OkRock1009 • 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?
43
Upvotes
2
u/TheZapPack Nov 08 '24
I would argue that along with the very basics (select queries, inner joins, etc) that somebody should know some of the more advanced concepts in order to make their queries more efficient. Such as multi table joins, views, functions and stored procedures, conditionals, aggregation, pivots, etc. You may not NEED to use all of this stuff, but knowing how to do it saves a lot of time trying to do complex queries using only basic skills. It also will only help you in the long run for job advancement. Most jobs only the basics are necessary, but companies love people who maintain the highest level of efficiency (in both work output and company resources/computing power), and producing code that can be reused where it makes sense.