Databases & SQL
- ByteScout SQL Trainer
- Introduction to SQL
- Use the Index, Luke! A Guide to Database Performance for Developers
- The Querynomicon
- Things You Should Know About Databases
- Database Normalization Basics
- Database Indexes Explained
- Optimistic vs. Pessimistic Locking
- Table Compression and Partitioning
- Things I Wished More Developers Knew About Databases
- Comparing database types: how database types evolved to meet different needs
- Database design basics
- Database Internals:
- How databases work: FE & BE
- How to learn about database systems
- Petrov, Database Internals: A Deep Dive Into How Distributed Data Systems Work
- Common Relational DBs:
- Oracle Database
- MySQL
- Microsoft SQL Server
- PostgreSQL
- IBM Db2
- SQLite
- MariaDB
- Non-Relational DBs (NoSQL) by Type:
- Wide column: Apache Cassandra
- Document: ElasticSearch), MongoDB
- Key-value: Redis
- Graph: Neo4J
- What is a Vector Database?
- Version control tools:
- Paradigms for managing data:
- Entity Relationship Diagrams with draw.io