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

1 pointsby sashashabout 6 years ago

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. ?

1 comment

dpodsabout 6 years ago

SQL joins, SQL aggregates, Table schema modifications and which ones lock tables, Transactions, Indexing, Replication