What a web-developer should know about databases and how deep?

Only main things like SQL, transactions, about ACID (Atomicity, Consistency, Isolation, Durability) or deeper knowledge like how Postgres works inside. About b-tree, relational algebra PostgreSQL etc. ?