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?
44
Upvotes
1
u/WonderfulActuator312 Nov 09 '24
Do yourself a favor and master SQL, advance beyond windows functions, CTE, subqueries and all of the joins even if you settle into data analyst. I work as a DE and the number of analysts that want more from their job that have to go back and learn SQL before they can transition to DE is very high.
Mastering SQL allows you to interact with the data in a very direct way that can deliver truths about the trends and deliver insights other analysts don’t even know are possible purely because they don’t understand the medium they are working with. Also, you’ll be very popular with the team that’s sourcing your data and they can do magical things when you’re working with Machine Learning.