ZZyVOP·6h agoTop SQL Concepts Every Data Engineer Should KnowA practical guide to the SQL skills behind production data pipelines, from joins and window functions to MERGE, SCD2, and data quality checks.17 min read·blog.zyvop.com
MMorteza Jangjoo·Aug 12, 2025Mastering LAG and LEAD in SQL ServerWhen you need to compare values between rows — like finding the difference from the previous or next entry — SQL Server’s LAG() and LEAD() functions make it3 min read·jangjoo.hashnode.dev