A very nice overview. Now knowing all this isn't necessarily a prerequisite for getting a lot of stuff done, but I think it's very useful indeed. In my experience in the industry so far I find that most people don't know any of this and just implicitly rely on the magic going on underneath and just interact with higher level interfaces, but when things go wrong then they're stuck and rely on Google or Stack Overflow for answers, copy and pasting solutions without really knowing why it works. This is fine of course, some people might not be too interested in this aspect, and just want to solve that blocker and move on with their task, but for me it's essential.