Databases
Fundamentals
- Database Concepts - ACID/BASE, concurrency, MVCC, isolation levels, database types
- Database Indexing - B-tree, inverted index, heap storage, MySQL indexing
- Data Modeling - ER diagrams, normalization, modeling tools
Database Categories
- SQL Databases - Relational databases (PostgreSQL, MySQL, Oracle, SQL Server)
- NoSQL Databases - Document, key-value, columnar, graph databases
- Data Warehouses - OLAP systems (Snowflake, BigQuery, Databricks)
Cloud Databases
- Amazon Aurora - MySQL/PostgreSQL-compatible cloud DB
- Amazon DynamoDB - Managed NoSQL key-value store
- Amazon Redshift - Cloud data warehouse
Additional Resources
- Database Tools & Courses - Migration tools, monitoring, courses
Links
- GitHub - mgramin/awesome-db-tools: Everything that makes working with databases easier ⭐ 5.1k
- GitHub - shlomi-noach/awesome-mysql: A curated list of awesome MySQL software, libraries, tools and resources ⭐ 2.6k
- GitHub - Releem/awesome-mysql-performance: 🔥 A curated list of awesome links related to MySQL / MariaDB / Percona performance tuning ⭐ 542
- GitHub - agarcialeon/awesome-database: A curated list of amazingly awesome database libraries, resources. ⭐ 235