This is indeed an imperfect medium for knowledge acquisition - I would strongly recommend picking up a copy of Designing Data-Intensive Applications
It isn’t a 1-1 mapping of any kind, but this book gets recommended a lot for a reason - it’s just very good and covers it all in an accessible way.