▶ Videos →

📰 Dev.to · Alex Murithi

4 articles · Updated every 3 hours · View all reads

All Articles 178,566 Blog Posts 165,046 Tech Tutorials 47,671 Research Papers 35,396 News 22,391 ⚡ AI Lessons

Data Cleaning and Analysis with SQL

Dev.to · Alex Murithi 📊 Data Analytics & Business Intelligence 18h ago

Data Cleaning and Analysis with SQL

1. Problem Statement SafariConnect is a transport booking platform handling thousands of...

SQL Window Functions Made Simple

Dev.to · Alex Murithi 📊 Data Analytics & Business Intelligence 1d ago

SQL Window Functions Made Simple

When you need to calculate averages, ranks, or totals without collapsing rows, SQL’s window functions...

Conditional Logic in SQL

Dev.to · Alex Murithi 📊 Data Analytics & Business Intelligence 1d ago

Conditional Logic in SQL

SQL isn’t just about retrieving data - sometimes you need to apply rules or handle missing values...

SQL Joins Made Simple

Dev.to · Alex Murithi 📊 Data Analytics & Business Intelligence 2d ago

SQL Joins Made Simple

Relational databases often store related information across multiple tables. To answer real-world...