Databases¶
Covers Data Modeling, Operation, Performance, Scaling, and Transaction.
Topics¶
| Topic | What it covers |
|---|---|
| Data Modeling | Covers Kimball Modeling, NoSQL Modeling, and Relational Model. |
| Operation | Covers Backup and Recovery, Caching, Connection Pooling, OLTP vs OLAP, Stored Procedures and Triggers, and Views. |
| Performance | Covers Indexing, and Query Optimization. |
| Scaling | Covers Database Federation, Partitioning and Sharding, and Replication. |
| Transaction | Covers Base and Eventual Consistency, Isolation Levels, Locking and Concurrency Control, MVCC, and Transactions and ACID. |