Resources
- DB Indexing - Kai Sassnowski Video
- CMU Intro to Database Systems Course
- Let’s Build a Simple Database
Topics
- Transactional vs Analytical systems
- Indexing strategy
- Partitioning - Partition stuff based on date or by a list of some particular column
- Retention and purge strategy - Common sense ig
- Audit design
- Capacity planning