4 ms·
Are you asking for examples of advanced SQL skills? In my experience, if you can grok lateral joins (aka cross apply), recursive CTEs, window functions, and fu
by veritas3241 8y ago
Are you asking for examples of advanced SQL skills?
In my experience, if you can grok lateral joins (aka cross apply), recursive CTEs, window functions, and fully understand all the join types, that's a gold star for understanding SQL!
- SamuelAdams 8y agoI would add indexes to that list. Knowing the different types and how they impact performance can be very valuable.
- veritas3241 8y agoI didn't add indexes mainly b/c for analytic warehouses that are columnar, indexes are less important / meaningless. Partitions though, that's important!