Raasika Mageshwaran·Feb 11Joins in SQL — DE From Scratch SeriesIn real-world data systems, information almost never resides in a single table. Instead, data is intentionally distributed across multiple…
Raasika Mageshwaran·Feb 9SQL Basics — DE From Scratch SeriesIn today’s data-driven world, almost every application, whether a mobile app, website, or enterprise system relies on databases to store…
Raasika Mageshwaran·Jan 24Data Modeling 101 (Article:02) — DE from Scratch Series — Normalization for OLTP DatabasesThis article explains how normalization structures OLTP databases to prevent anomalies through an e-commerce database example.
Raasika Mageshwaran·Jan 23Data Modeling 101 (Article:01) — DE from Scratch SeriesIf you’ve ever wondered why dashboards don’t match, why SQL queries become messy, or why databases feel hard to maintain as data grows —…