| name | database-management |
| description | Master relational and NoSQL databases. Learn PostgreSQL, MySQL, MongoDB, Redis, and other technologies for data persistence, optimization, and scaling. |
Database Management
This skill teaches data persistence, optimization, and scaling strategies.
Quick Start
Database selection depends on:
- Data structure (relational vs document)
- Consistency requirements (ACID vs eventual consistency)
- Scale needs (read/write patterns, volume)
- Query patterns (OLTP vs OLAP)
Database Categories
Relational Databases
PostgreSQL, MySQL, MariaDB, T-SQL
- Best for: Transactional data, structured data
- Features: ACID, joins, complex queries
NoSQL Databases
MongoDB, Redis, Cassandra, DynamoDB, Elasticsearch
- Best for: Document storage, key-value, time-series
- Features: Horizontal scaling, flexibility
Key Concepts
- ACID properties: Atomicity, Consistency, Isolation, Durability
- Indexes: B-tree, hash, full-text
- Query optimization: EXPLAIN plans, execution strategies
- Replication: Master-slave, master-master
- Sharding: Horizontal partitioning
- Backup & recovery: PITR, disaster recovery
Hands-On
- Design database schemas
- Write and optimize SQL queries
- Set up replication
- Implement backup strategies
- Tune performance
See Also
- Agent 2: Database Management (comprehensive guide)
- PostgreSQL and MongoDB official documentation
- DBeaver, pgAdmin tools