videos.md

Videos

AsliEngineering’s Database Engineering Primer

1. Why do databases store data in B+ trees?
2. How do indexes make databases read faster?
3. How databases store and transmit integers efficiently using varint encoding
4. Picking the right string column datatype - CHAR vs VARCHAR vs TEXT
5. Datetime vs Timestamp datatype in databases - Which one is better and when?
6. How nested loop, hash, and merge joins work
7. What happens when ID column reaches its max value - Dissecting GitHub Outage
8. Database Sharding and Partitioning
9. PostgreSQL connection management and per-client process model explained
10. How PostgreSQL parses the query and constructs the Parse Tree?
11. How PostgreSQL generates all possible query execution plans before choosing the best one?

CI/CD

• Do NOT Learn Kubernetes Without Knowing These Concepts...