Introduction to Database Systems (CMU) [0] should be useful to anyone who wants to learn about how relational databases work.

[0] https://www.youtube.com/playlist?list=PLSE8ODhjZXjbohkNBWQs_...