Database Design

Overview

This skill focuses on designing efficient, scalable, and maintainable database schemas and data models. It covers:

OLTP Systems: Relational databases (PostgreSQL, MySQL) with normalization and transactional integrity
OLAP Systems: Data warehouses with star/snowflake schemas for analytics
NoSQL: Document stores (MongoDB), key-value (Redis), wide-column (Cassandra)
Time-Series: Specialized databases for metrics and events (TimescaleDB, InfluxDB)
Event Sourcing: Append-only event stores for audit and temporal queries
Data Pipelines: Schema design considerations for ETL/ELT workflows

This skill incorporates data modeling expertise for both operational and analytical workloads.