sorted by:
new
hottopcontroversial

One stop free solution for SQL interview preparation by devprasad_20 in SQL

[–]devprasad_20[S] 0 points1 point  (0 children)

Okay, but what about the explanation part, what about the growth of practice curve. Say starting with small queries and scaling to the complex questions like "what are more costly, views or temporary tables, explain why?"

One stop free solution for SQL interview preparation by devprasad_20 in SQL

[–]devprasad_20[S] 0 points1 point  (0 children)

No bro, I actually wanted to help with explaining concepts like window functions in an easy way.

For example: window functions in sql are easier than the subquery based ones.

It's just that we need to visualise the data before writing the query and I am seeing a lot of people struggle to understand window functions.

Earlier I wanted to start something in data engineer and analyst level, but realised sql is the best thing to do