Database Systems

My notes on different database systems, concepts, and best practices.

• Relational Databases

  SQL databases and relational concepts.

  • PostgreSQL Guide
  • MySQL Basics
  • SQL Best Practices

  View Notes

• NoSQL Databases

  Non-relational database systems.

  • MongoDB
  • Redis
  • Cassandra

  View Notes

• Database Design

  Database design patterns and practices.

  • Schema Design
  • Normalization
  • Indexing Strategies

  View Notes

• Database Administration

  Database administration and operations.

  • Backup & Recovery
  • Performance Tuning
  • Security Practices

  View Notes

Learning Resources

• Current Focus

  Database concepts I'm learning:

  • Advanced SQL
  • Database Optimization
  • Distributed Databases

• Useful Resources

  Helpful database resources:

  • PostgreSQL Documentation
  • MongoDB University
  • Redis Documentation