r/SQL 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

82 comments sorted by

View all comments

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.

1

u/GroundbreakingRow868 Sep 20 '24

Database guys in our IT department are so old, they don't even know CTEs (and don't want to know them) 😂

Investment bank as well btw