Learn SQL normalization from scratch. Covers 1NF, 2NF, 3NF, and BCNF with step-by-step table examples, anomaly fixes, and when to denormalize.

Master SQL GROUP BY and aggregation functions — COUNT, SUM, AVG, MIN, MAX, HAVING, and ROLLUP with real query examples and common pitfalls explained.

Understand SCD Types 0, 1, 2, 3 and 6 in data engineering. Covers implementation strategies, SQL examples, and when to use each in modern data warehouses.

Set up a full Arr media stack on Raspberry Pi 5 with Docker. Covers Sonarr, Radarr, Prowlarr, qBittorrent, and Jellyfin for a complete self-hosted setup.

A complete data warehousing guide for data engineers covering architecture, ETL vs ELT, schema design, BigQuery, and modern warehouse best practices.

A beginner-friendly guide to DBMS fundamentals covering keys, normalization, transactions, ACID properties, and SQL basics with clear examples.

Understand star and snowflake schemas in plain English. Learn key differences, when to use each, and how they power data warehouse design decisions.

A quick reference Git cheatsheet covering setup, config, branching, staging, and essential commands for developers and sysadmins. Bookmark-worthy.

Understand the CAP theorem (Consistency, Availability, Partition Tolerance) in layman's terms. Master distributed database tradeoffs for your next data engineering interview.

Understand ACID properties (Atomicity, Consistency, Isolation, Durability) in layman's terms. Master database transactions for data engineering interviews.