- RDBMS
- PostgreSQL
- NoSQL
- Redis
- MongoDB
- Elasticsearch
- Neo4j
- Normalization and Denormalization
- Design for read and Design for write
- Manage tables
- Create table
- Alter table
- Truncate table
- Keys
- Primary key
- Foreign key
- Constraints
- CRUD operation
- Create
- Read
- Update
- Delete
- Tuning
- Explain query
- Index
- Slow query
- Sharding
- Replicate
- Database architecture
- Master-slave
- Multi-master
- PostgreSQL database
- Setup and config
- Essential configuration and tuning
- Max connection
- Shared buffers
- Max memory
- Effective cache size
- Checkpoint timeout
- WAL buffers
- Setup Streaming Replication (Log Shipping/Mirror)
- Monitoring Replication
- Check replication status
- Failover (Manual)
- Replication lag
- Monitoring
- Metric
- Slow log
- Logging