Someone wanted to learn this too, so Grasp built them a personal learning path.
You can keep exploring this one or create a path like this one shaped around you.
Recommended resources
Module 4
Query Optimization
Module 5
Concurrency Control
Module 6
Logging and Recovery with ARIES
Module 7
Columnar Storage and Execution
Module 10