I took a class on Databases back during my undergrad in the early 2000s, and it covered pretty much all of this stuff. I thought this was standard stuff people learned as part of a CS degree.