✅ How to learn Relational Databases?
Hello, sorry this is somewhat off topic for this server, but I think people here will be able to reccomend something. I'm looking to learn a database software, I've settled on postgres and now I want to learn. But I want to go at it from a theory side, not just knowing what SQL commands are what they do, but more the "why" of things. When I studied discrete math in uni we did relations, and I have a vague idea that the relation in relational database comes from that, so I want to explore that side. I hope I'm making sense, if anyone has any suggestions it'll be great. When I look for tutorials etc on postgres, all I get is people teaching how to make tables and how to run queries etc. I did find some things on normal forms, which seemed to be more what I was looking for. Any ideas would be appreciated, thanks!
4 Replies
theyre not really related to math relations
ive heard good things about sqlbolt
Alright, thanks, I'll look it up
By this do you mean that in practice it's never useful to think of it the math way, or that they are literally different things
literally different things
Got it, I'll be studying up more on these things