Databases & Data
Databases tend to outlast many of the technologies around them. Frameworks, tools and interfaces may change quickly, but data structures often remain in place for years.
That is why this page is less about products and more about structure, querying, interpretation and the durability of models.
Relational systems
MySQL is often the practical entry point in web environments. PostgreSQL stays closer to classical database thinking while offering flexibility. Oracle usually appears in larger and longer-lived environments where structure, stability and maintainability matter at least as much as raw capability.
Structure & querying
Regardless of the system, the central question remains the same: how do you structure data so that it stays understandable and useful later on?
That includes relationships, names and queries that remain readable rather than merely working.
NoSQL & other approaches
Alongside relational systems there are other approaches, such as document-oriented databases like MongoDB. These emphasise different trade-offs, not simply a more modern answer to every question.
Tools
Practical work involves different tools depending on the system and the task. That can include DBeaver, Oracle SQL Developer, Toad and more traditional command-line tools.
Notes & entry points
- Keep SQL readable
- Use indexes deliberately
- Design models that remain understandable
- Understand trade-offs between relational and document models