📰 Medium · Programming

Find duplicate records in a table Continue reading on Medium »

You have sat through a talk that made you feel embarrassed for still using SQL. Continue reading on Medium »

In real-world work, data is often scattered across multiple Excel files — sales reports split by month, employee information organized by… Continue reading on M

The Hidden Cost of a Fragmented Data Stack Continue reading on Medium »

Tools come and go. Architectural principles stay forever. Continue reading on Medium »

Halo! Saya Atalla, calon mahasiswa Business Analytics yang memiliki latar belakang Rekayasa Perangkat Lunak dan Teknik Komputer. Beberapa… Continue reading on M

DuckDB vs PostgreSQL: a no-BS comparison from someone who actually tested both. When to use each, when to combine them, and why “the right… Continue reading on

When interviewers ask how you’d build a real-time leaderboard over massive datasets, they’re rarely testing your SQL skills. They’re… Continue reading on Medium

You have used groupby() several times already in this series. Now let’s master it properly. Continue reading on Medium »

When creating instructional spreadsheets, dashboards, or annotated reports, cells alone are often insufficient for accommodating lengthy… Continue reading on Me

The engineering decisions that make modern local analytics feel almost unfair. Continue reading on Medium »

Over the past few days, I’ve explored different types of Linked Lists — from Singly Linked Lists to Doubly Linked Lists. Each one… Continue reading on Medium »

For twenty years the cloud pretended to weigh nothing and now the most physical machine ever built is landing on the towns that said yes to Continue reading on

Tables often contain too many rows to understand one at a time.At some point, you stop asking: What is in each row? Continue reading on CodeX »

Custom IDs make more sense when the database counter lives outside the table that stores the final row. Sequence objects return numeric… Continue reading on Med

Data science is one of the most sought-after careers alongside the development of technology and the fast-changing educational sector… Continue reading on Mediu

Foto oleh Markus Spiske di Unsplash Continue reading on Medium »

Alright, listen up, data aficionados and fellow tech geeks!  Have you, like, really noticed what’s been brewing in the data engineering… Continue reading on Me

Hi everyone, I am Trends 24/7 and in this blog I want to share what actually happened during my last job search, not the polished version… Continue reading on M

Before you build any model or draw any conclusion, you need to actually understand what you are looking at. This is how professionals do… Continue reading on Me

A practical decision framework for identifying fact tables and dimension tables — plus exactly how to explain your reasoning when someone… Continue reading on M

Most Medallion tutorials quietly assume a batch world — a nightly job reads yesterday’s files and rebuilds a table. That model breaks the… Continue reading on M

SQL Joins Explained with Real Examples Continue reading on Medium »

Time-series data refers to data that is related to date and time. In Pandas, there are well-structured concepts and functions for working… Continue reading on M