C
C#3mo ago
hadeedji

✅ 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
sibber
sibber3mo ago
theyre not really related to math relations ive heard good things about sqlbolt
hadeedji
hadeedjiOP3mo ago
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
sibber
sibber3mo ago
literally different things
hadeedji
hadeedjiOP3mo ago
Got it, I'll be studying up more on these things
Want results from more Discord servers?
Add your server