Pro SQL Server Internals
by Dmitri Korotkevitch · first published 2014
2mentions
2recommended by
2HN commenters
2018–2019first – last mentioned
100% recommend
Affiliate links. As an Amazon Associate I earn from qualifying purchases.
Pro SQL Server Internals by Dmitri Korotkevitch https://www.apress.com/gb/book/9781484219638 It's specific to MS SQL Server but I found the chapters on log file management, indexes & isolation levels to be accessible and enjoyable.
on “LearnDB: Learn how to build a database” ↗…RDBMS work under the hood, "Designing Data Intensive Applications", would be a good conceptual start. This could be followed by database internals books like "Expert Oracle Database Architecture" and "Pro SQL Server Internals", irrespective of whether you use these databases or not, you will learn a ton of stuff about database internals and system design. If you are interested in database schema design etc, then look up "The…
on “Ask HN: How did you learn DBMS?” ↗