Archive - dat-a-man — Data with Aman

Advanced SQL Techniques: Grouping Sets, Rollups, and Self Joins”(Deep dive)

Write cleaner, smarter SQL with Grouping Sets, Rollups, and Self Joins.

Sep 30 •

August 2025

SQL Window functions deep dive

What window functions can do and what they cannot.

Aug 29 •

July 2025

Data Engineering Newsletter #35

Data Engineering News

Jul 28 •

Data Engineering Newsletter #34

Data Engineering News

Jul 22 •

Data Engineering Newsletter #33

Data Engineering News

Jul 14 •

Why LY Corporation made the big switch to Apache Iceberg

Jul 8 •

Data Engineering Newsletter #32

Data Engineering News

Jul 7 •

June 2025

Data Engineering Newsletter #31

Data Engineering News

Jun 30 •

Data Engineering Newsletter #30

Data Engineering News

Jun 17 •

Data Engineering Newsletter #29

Data Engineering News

Jun 7 •

Data Engineering Newsletter #28

Data Engineering News

Jun 3 •

Data Engineering Newsletter#27

Data Engineering News

Jun 3 •

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts