What books to read on database design best practices?

Question

MySQL

There are many great books on programming that not only describe the programming language and principles of working with libraries and frameworks, but also give practical advice on how to work more efficiently with code, how to improve it, how to manage complexity. I mean Code Perfect, Clean Code, Refactoring, Extreme Programming, The Pragmatic Programmer, GoF, DDD (Evans) and many other great books.
What is in the same spirit, but on databases? (First of all on relational DB).
I don't just need a manual on SQL and a detailed description of the inner workings of a DBMS, I want to read about other people's experiences, about what problems they faced and how they solved them. Is there anything like that?

Answer 1

Bill Karwin SQL Antipatterns
In general, in the spirit of refactoring, just: how they often do it wrong, why it is bad (but when it is adequate for the task) and how to do it better.

Answer 2

An excellent abstract of lectures by Professor MAI Lukin V.N.
www.studmed.ru/lukin-vn-bazy-dannyh-konspekt-lekci...

Answer 3

DBMS for the programmer. Databases from within
Zryumov Ye.A. - Databases for database engineers
- application development - Rudikov
databases - Homonenko Tsygankov Maltsev

Answer 4

This book is very useful https://www.ozon.ru/context/detail/id/3261793/

Answer 5

Here is the info you need

Answer 6

From the western school of the founders of the DBMS, read the C books. Jay. Data. They are more in theory than in practice, but there is no better one.
Look for ours. Unfortunately, I have no idea who. If you find it, please share.