Workshop Database

• RDBMS
  • PostgreSQL
• NoSQL
  • Redis
  • MongoDB
  • Elasticsearch
  • Neo4j

Software requirements

• PostgreSQL server
• pgAdmin

Workshop

• Go to workshop

List of topics

• 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