DEV Community

peter muriya karanja profile picture

peter muriya karanja

Data engineer in Nairobi, Kenya. I turn messy data into tested data models, pipelines, and dashboards, and write here about what I build and learn.

Joined Joined on  github website
Subquery vs CTE in SQL: When and How to Use Each
petermuriya profile

Subquery vs CTE in SQL: When and How to Use Each

#sql #postgres #database #beginners
Comments
3 min read
Primary Key vs Foreign Key in SQL: How Tables Connect
petermuriya profile

Primary Key vs Foreign Key in SQL: How Tables Connect

#sql #postgres #database #beginners
Comments
3 min read
DDL and DML in SQL: Understanding the Two Essential Parts of Database Management
petermuriya profile

DDL and DML in SQL: Understanding the Two Essential Parts of Database Management

#backend #beginners #database #sql
Comments
3 min read
Understanding Apache Kafka: A Beginner-Friendly Guide
petermuriya profile

Understanding Apache Kafka: A Beginner-Friendly Guide

#beginners #dataengineering #distributedsystems #tutorial
Comments
2 min read
Streamlining ETL Pipelines with Docker and Docker Compose in Data Engineering
petermuriya profile

Streamlining ETL Pipelines with Docker and Docker Compose in Data Engineering

#automation #dataengineering #devops #docker
Comments
3 min read
Containerizing Apache Airflow: Building Portable Data Pipelines with Docker
petermuriya profile

Containerizing Apache Airflow: Building Portable Data Pipelines with Docker

#dataengineering #devops #docker #tutorial
1
Comments
1 min read
OLAP vs OLTP: Understanding the Backbone of Modern Data Systems
petermuriya profile

OLAP vs OLTP: Understanding the Backbone of Modern Data Systems

#data #database #dataengineering #systemdesign
1
Comments
2 min read
Automating ETL Workflows with Apache Airflow: From Python Script to Scheduled Pipeline
petermuriya profile

Automating ETL Workflows with Apache Airflow: From Python Script to Scheduled Pipeline

#dataengineering #airflow #python #programming
2
Comments 1
3 min read
ETL vs ELT: Which One Should You Use and Why?
petermuriya profile

ETL vs ELT: Which One Should You Use and Why?

#dataengineering #etl #elt #bigdata
Comments
5 min read
From Joins to Window Functions: Unlocking Powerful SQL Techniques
petermuriya profile

From Joins to Window Functions: Unlocking Powerful SQL Techniques

#beginners #database #sql #tutorial
1
Comments
2 min read
From Messy Data to Meaningful Decisions: How Analysts Turn Power BI into Business Impact
petermuriya profile

From Messy Data to Meaningful Decisions: How Analysts Turn Power BI into Business Impact

Comments
2 min read
Schemas and Data Modelling in Power BI
petermuriya profile

Schemas and Data Modelling in Power BI

#analytics #data #dataengineering #microsoft
Comments
2 min read
Introduction to Linux for Data Engineers
petermuriya profile

Introduction to Linux for Data Engineers

#beginners #dataengineering #linux #tutorial
Comments
3 min read
Beginner’s Guide to Git: Version Control, Push, Pull, and Tracking Changes
petermuriya profile

Beginner’s Guide to Git: Version Control, Push, Pull, and Tracking Changes

#github #git #githubactions
Comments
1 min read
loading...