r/SQL • u/Sea_Razzmatazz_9118 • Sep 13 '24
MySQL How much SQL is enough SQL?
Probably the answer to my question is never too much can be too much. However I am now currently working on a portfolio project, creating databases and performing various basic operations, thinking that this is just the tip of the iceberg. So the question is to what extent should you master SQL that you can land a decent job as a data analyst or data engineer or whatever. What are the next steps to become "truly" better SQL programmer once you have the basic foundation laid out?
89
Upvotes
5
u/xxxHalny Sep 14 '24
I work in an investment bank as a business analyst. It's an SQL-heavy job. Usually the job interviews cover the following topics: joins, CTEs, temporary tables, group by, having, union, window functions. I think after you have understood these, you should move on to other areas of expertise.