3 ms·
Any recommendations of a place for sharing "extremely advanced" SQL skills? Asking from wanting to make use of such a place, and haven't seen anything like it.
by justinclift 8y ago
Any recommendations of a place for sharing "extremely advanced" SQL skills?
Asking from wanting to make use of such a place, and haven't seen anything like it. So, probably need to bootstrap one instead (etc).
- veritas3241 8y agoAre 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!
- andy_boot 8y agoI made this: https://www.windowfunctions.com https://www.windowfunctions.com
- CRConrad 8y agoAre you asking for “sharing skills” as in something like StackOverflow, but for SQL? I would think there already is a Stack Exchange for SQL, possibly several (for different RDBMSes/ dialects); go have a look there, if this is what you meant.