Those don’t sound like the “fundamentals” of databases at all. They sound like pretty high level concepts.
When I studied databases in college, we started with how pages are stored on disk. That is fundamental to both data and indexes, and everything that uses them. Query optimizers depend on almost every other part of the database. In the databases we wrote, I don’t think we got to that.
When I studied databases in college, we started with how pages are stored on disk. That is fundamental to both data and indexes, and everything that uses them. Query optimizers depend on almost every other part of the database. In the databases we wrote, I don’t think we got to that.