For further actions, you may consider blocking this person and/or reporting abuse
Read next
Java GUI Frameworks: Some go for these fine tools
Zoltan Fehervari -
11 Essential Tips for Optimizing Windows Performance
John -
Learn React Flow and how to add real-time sync between participants
Vitor Norton -
Ultimate Guide to AWS S3 Buckets in 2024: New Features, Storage Smarts, and Beyond
Kemal Cholovich -
Top comments (2)
One of the reasons why relational databases are quite clear to me is because I paid attention during the "DB fundamentals" university course many years ago and because the book we had was gold. I think I still have it somewhere in the attic at my parents home.
I just googled and the book apparently still exists and has been kept up to date: Fundamentals of Database Systems, 7th Edition
It's a university course book and goes pretty into depth of DB design, so don't be fooled by the title, it's not a "tutorial" book.
If you want something a little bit less "theoretical" I've heard good things from this: Relational Database Design Clearly Explained
I have said in another thread that I don't buy tech books that much lately but DB design is one of those topics that are not a fad or tied to a specific language and for which a book is definitely worth it. Even if you use a multi database application (or based on a non relational DB) it's worth to have strong fundamentals on how to structure and relate data.
There are a few different aspects of working with databases: architecture and design, analysis and query construction, and of course there's the entire operational side. You'll be doing some of each no matter what and there's obviously a lot of common ground, but it'll help if you know which way you want to lean. If you have the opportunity to take a discrete math course, do so. Some resources:
Database design
Usage
Operations and tuning
Overall there's no substitute for hands-on exploration, even though databases tend to be much slower-moving than other areas (it can take a while for structural problems to become apparent, changes need to be made deliberately). In addition to being the best RDBMS available, Postgres' documentation is an excellent resource if you want to dive in yourself.