Relational databases, replication, and in-memory caching.
| Topic | Description | Path |
|---|---|---|
| SQL | Basics: databases, queries, relations, joins, normalization (WIP) | sql/ |
| MariaDB | Replication setup | mariadb/ |
| MySQL | Configuration, benchmarking, InnoDB tuning | mysql/ |
| PostgreSQL | Install and restore | postgresql/ |
| Redis | Install and Python client usage | redis/ |
Practical SQL learning path (PostgreSQL-leaning examples). See sql/README.md.
| Guide | Path |
|---|---|
| Databases | sql/01-databases.md |
| Tables | sql/02-tables.md |
| SELECT | sql/03-select.md |
| Aggregates | sql/04-aggregates.md |
| DML | sql/05-dml.md |
| Keys & Relations | sql/06-keys-relations.md |
| Joins | sql/07-joins.md |
| Normalization | sql/08-normalization.md |
| Guide | Path |
|---|---|
| Installation | redis/install.md |
| Python client | redis/python-redis.md |
| Example scripts | redis/codes/ |