The book should probably cover the query engine parts (sql parsing, query plans etc) and the persistence part.
Recommendations will be appreciated.
The author also made it available for free at https://howqueryengineswork.com/00-introduction.html
On implementation, my favourite is "Database Design and Implementation" by Ed Sciore, you write a relational DB in Java, including the parser.
- did not do any research
- want someone to link to the book "database internals"
But, in the spirit of the most charitable interpretation and, as it is a good book:
https://www.goodreads.com/book/show/44647144-database-intern...