Stop learning SQL through Leetcode! Be a better data engineer!

[mayank]

sorry but writing a correct sql query is step 1. followed by writing a performant query. And Leetcode is best place to grind your sql skills of writing a query. From my own experience, I solved all medium and hard leetcode questions and it gave me better avenues to think about approaching a problem and thinking what route to take that will be performant.

[aaronvaughn]

Thanks for the tips. I'm a newbie that understands very little of what you said, but am writing notes to learn more about these concepts.

[mbaklengs]

I love the vibe of learning the fundamentals!!

[gregorywpower]

I'd choose Universal Star Schema modeling over Data Vault. I can understand why most folks do One Big Table...it's easy, but sometimes you gotta normalize to get better performance.

[LuboBali]

Thanks for sharing let’s make it big 💪

[michaurbanski]

Why are columnstore indexes skipped so often - they are used pretty often in olap

[SNGSTAR]

Where can I learn all of this? I just secured a new job as a data engineer and have no idea

[rl]

Are sql column indexes unique to certain companies? My previous DE team I was on, was spark only where sql was used lightly