Technical Blog
Deep dives into data engineering, cloud architecture, AI/ML, and the technologies that power modern data platforms.
Production-ready Apache Airflow setup with PostgreSQL, Celery Executor, and RabbitMQ on macOS. Covers database migration, worker scaling, Flower monitoring, and troubleshooting common distributed task queue issues.
Essential PostgreSQL SQL reference for data engineers. Covers SELECT, JOINs, aggregations, window functions (LAG, LEAD, RANK), CTEs, JSONB queries, date operations, and performance optimization with practical examples.
Hands-on PostgreSQL tutorial building a daily order analysis report. Learn aggregations, window functions (LAG, SUM OVER), running totals, calendar tables, and query optimization with EXPLAIN plans for production data pipelines.
