easyfundamentalsnosqlSQL vs NoSQLWhat is the difference between SQL (relational) and NoSQL databases?▾
mediumschemadesignNormalization (1NF, 2NF, 3NF)What is normalization and what do 1NF, 2NF, and 3NF mean?▾
mediumperformanceindexingIndexes and when to use themWhat is a database index? When should you add one, and what are the costs?▾
mediumtransactionsconcurrencyTransaction isolation levelsWhat are the standard SQL isolation levels and what anomalies do they prevent?▾
harddistributedtheoryCAP theoremWhat is the CAP theorem and how does it affect distributed database design?▾
harddistributedscalingSharding vs ReplicationWhat is the difference between sharding and replication?▾