Architect Overview

20 labs · PostgreSQL + ClickHouse + Kafka + MongoDB + DynamoDB + More · Docker-verified

Design distributed data systems at enterprise scale — CAP theorem, global architectures, compliance, vector databases, and full capstone projects.

---

Labs

#	Lab	Topics
01	CAP Theorem & Distributed Systems	CAP, PACELC, consistency models, Jepsen testing
02	Distributed Transactions	2PC, Saga pattern, outbox pattern, compensating transactions
03	Event Sourcing & CQRS	event store, projections, aggregate root, read models
04	Database Migrations — Flyway	versioned migrations, undo, checksums, CI/CD integration
05	AWS RDS Architecture	Multi-AZ, read replicas, RDS Proxy, Aurora, parameter groups
06	Amazon DynamoDB	single-table design, GSI/LSI, DynamoDB Streams, DAX
07	MongoDB Atlas — Global Clusters	global writes, zone sharding, Atlas Search, Atlas Trigger
08	Data Warehousing	star schema, Kimball methodology, ETL/ELT, dbt
09	Time-Series Databases	TimescaleDB, InfluxDB, retention policies, continuous aggregates
10	CockroachDB — NewSQL	distributed SQL, geo-partitioning, serializable, survivability
11	Kafka & Change Data Capture	Debezium CDC, Kafka Connect, schema registry, stream processing
12	Database Observability	Prometheus exporters, Grafana dashboards, SLOs, alerting
13	Multi-Region Database Architecture	active-active, active-passive, conflict resolution, latency
14	Zero-Downtime Migrations	expand-contract, blue-green, feature flags, schema compatibility
15	Data Governance & Compliance	GDPR, HIPAA, SOC2, PII detection, RLS, audit logging
16	Database Cost Optimization	RDS sizing, reserved instances, gp3, compression, DynamoDB
17	Vector Databases & pgvector	embeddings, cosine similarity, IVFFlat, HNSW, semantic search
18	Database Security Architecture	defense-in-depth, TDE, column encryption, SQL injection, DAM
19	Global Data Platform	OLTP + ClickHouse + Elasticsearch + Redis + Kafka architecture
20	Capstone — Enterprise Fintech Data	full fintech architecture, PCI-DSS, fraud detection, compliance

---

Start here → Lab 01: CAP Theorem & Distributed Systems