Course topics
Topic 1: The Relational Model- Relational Databases
- Schema Normalization and Data modeling
- ACID
- Transaction isolation levels
- Pessimistic vs optimistic locking
- Consistency guarantees
- 2PC, 3PC
- Saga pattern
- Scalability, Performance, Availability
- Monolithic vs Microservices architecture
- Polyglot Persistence, Replication, and Partitioning
- Database design with denormalization
- SQL vs NoSQL. NoSQL properties
- NoSQL types: KV, Graph, Document, Column
- CAP theorem with SQL and NoSQL DBs
- MongoDB
- Cassandra
- Redis
- Hazelcast
- Kafka
- Zookeeper
- ElasticSearch
- Spanner
- Multi-Master Replication Solutions for PostgreSQL