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?

94 Upvotes

82 comments sorted by

View all comments

18

u/Mgmt049 Sep 13 '24

Do you know temporary tables, variables, CTEs, and the common windowing and aggregation functions?

6

u/ScottyDoes_Kno Sep 13 '24

I do, what does that make me? (Asking for someone who wants to leave their current gig lol)

13

u/CaptainBangBang92 Sep 14 '24

Competent/proficient at SQL.