Browsing Tag
sql
114 posts
Using dbt to Transform OpenSky Flight Data
Building an OpenSky Flight Data Pipeline with dbt Core Recently, I built an OpenSky Flight Data Pipeline that…
SQL Basics Explained: DDL, DML, Filtering, and CASE WHEN
Learning SQL can feel overwhelming at first, especially when you’re staring at a blank query editor wondering where…
Compilable and Executable Pseudocode (spec) Solves AI Coding Hallucinations
The AI-generated SQL – no one dares to say they fully “understand” it First, look at the following…
PostgreSQL 22036 Error: Causes and Solutions Complete Guide
PostgreSQL Error 22036: non numeric sql json item PostgreSQL error code 22036 (non numeric sql json item) occurs…
PostgreSQL 22027 Error: Causes and Solutions Complete Guide
PostgreSQL Error 22027: Trim Error — Causes, Fixes, and Prevention PostgreSQL error code 22027 (trim_error) occurs when the…
I built a free SQL practice game where you work at a fictional Singapore bank
I’ve been frustrated with SQL learning resources for a while. Most are either: Dry reference docs Toy exercises…
Debugging PostgreSQL Performance
Let’s chat about performance, optimization, and debugging a PostgreSQL database. Can you read EXPLAIN ANALYZE output fluently? Do…
Stop Naming Your Healthcare Columns Wrong — ISO-11179 Explained
If you’ve ever inherited a healthcare database with columns named DOB, PatientID, or CLAIM_NUMBER — this guide is…
SQL Subquery and CTEs( Common Table Expressions)
What is a subquery? Subquery is a query nested inside another query statement. It allows the query to…
Coding Cat Oran Ep3, Five Tables Changed Everything
Oran spent two weeks doing something that felt like not working. He sat with the warehouse team during…
