Why Direct Lake Isn’t the Magic Bullet Everyone Promised: A Senior BI Post-Mortem
By Harsh Gupta Continue reading on Medium » By Harsh GuptaContinue reading on Medium » Read More Sql on Medium #sql
200 SQL Interview Questions Later, I Realized I Had Been Learning SQL Backwards
I could explain indexes, joins, transactions, isolation levels, and execution plans. Continue reading on Production Engineering Playbook » I could explain indexes, joins, transactions, isolation levels, and execution plans.Continue reading…
SQL for Data Analysts: Full Outer and Cross Join with Examples
Hello! I’m Cavid, an aspiring data analyst. Today, we are going to continue our series on SQL JOINs. In my previous article, We talked… Continue reading on Medium » Hello!…
SQLite Tutorial #04 — Sort Results with ORDER BY
We’ve learned to read data with SELECT and filter with WHERE. Now let’s talk about sorting — because getting the right data is one thing… Continue reading on Medium »…
Your AI Wrote Valid SQL. That Doesn’t Mean It’s Right.
The most dangerous query is the one that runs Continue reading on Medium » The most dangerous query is the one that runsContinue reading on Medium » Read More Sql…
Ternyata Mengolah Data Bisa ada Tabel-Tabelnya: DataFrame dan SQL di PySpark
Setelah sebelumnya kita mencoba PySpark, rasanya agak percuma kalau kita belum benar-benar mengolah datanya. Jadi di artikel kali ini kita… Continue reading on Medium » Setelah sebelumnya kita mencoba PySpark,…
Pattern #015: Percentiles & Median in SQL — Why the Average User Is Often a Lie
Your average customer spends $42. But does that mean a typical customer spends $42? Continue reading on Medium » Your average customer spends $42. But does that mean a typical…
SQL Window Functions — Explained Simply | SQL Interview Series #6
A simple guide to ROW_NUMBER(), RANK(), DENSE_RANK(), LAG(), LEAD() and PARTITION BY. Continue reading on Medium » A simple guide to ROW_NUMBER(), RANK(), DENSE_RANK(), LAG(), LEAD() and PARTITION BY.Continue reading…
Data Science Yolculuğu #5: Python’a Giriş
Önceki bölümlerde verileri,KPI’ları,metrikleri, SQL kısmına bir giriş yapmıştık. Bunlar tabiki de 4 bölümle sınırlı değil fakat kalan… Continue reading on Medium » Önceki bölümlerde verileri,KPI’ları,metrikleri, SQL kısmına bir giriş yapmıştık.…
Data Science Yolculuğu #6: Listeler,Dictionary
Merhabalar tekrardan serinin 6.bölümüne hoş geldiniz. Önceki bölümde Python’a bir giriş yaptık şimdi listeler,sözlükler,setler ile biraz… Continue reading on Medium » Merhabalar tekrardan serinin 6.bölümüne hoş geldiniz. Önceki bölümde Python’a…
The SQL Optimization Techniques That Made My Queries Run Faster Without New Hardware
I Kept Thinking the Database Needed More Resources Until I Realized My Queries Were the Real Bottleneck. Continue reading on ILLUMINATION » I Kept Thinking the Database Needed More Resources…
LIMIT 1 in PostgreSQL: The Simple Query Optimization That Can Save Millions of Rows from Being…
When your application needs exactly one row, why ask PostgreSQL to find every matching row? Continue reading on Medium » When your application needs exactly one row, why ask PostgreSQL…
Windowing in Stream Processing: Tumbling, Hopping, Session & Global Windows
A stream never ends, and that single fact breaks every aggregation you learned on batch data. You cannot run SUM, COUNT, or AVG over an… Continue reading on Medium »…
Master Data Management (MDM) for Data Engineers: Golden Records & Survivorship Rules
master data management is the discipline of taking the same real-world thing — one customer, one product, one supplier — as it appears… Continue reading on Medium » master data…
An Engineer Left ddl-auto=update in Staging. Production Ended Up With Two Columns Instead of One.
The deployment window was Sunday night specifically because it was supposed to be quiet, the lowest-traffic slot in the week, the safest… Continue reading on Level Up Coding » The…
One Table to Rule Them All: How We Adapted a Document Schema in MySQL
We had a product catalogue with fifty attribute sets across twenty product types. The traditional approach meant twenty tables, fifty… Continue reading on Level Up Coding » We had a…
Why DuckDB Is Becoming a Big Deal for Python Developers
SQL, analytics, and massive datasets without immediately reaching for a distributed cluster. Continue reading on Python in Plain English » SQL, analytics, and massive datasets without immediately reaching for a…
TThe Role of SQL in Data Analytics: Features, Uses, and Top Tools
Picture this. A fresher walks into a data analyst interview in Bangalore. Continue reading on Medium » Picture this. A fresher walks into a data analyst interview in Bangalore.Continue reading…
Migrating From MySQL to PostgreSQL: A Practical Checklist for Small Production Sites
What a real three-minute migration teaches us, plus the gotchas that break most first attempts Continue reading on Medium » What a real three-minute migration teaches us, plus the gotchas…
SQLite in Go: WAL, Locking & Production Patterns
SQLite works remarkably well inside a Go service when the connection pool respects its locking model. This guide compares current drivers… Continue reading on Code Your Own Path » SQLite…