Can’t say enough good things about Database Design for Mere Mortals. I keep a physical copy on my desk to give to other developers to read.

I'm a big fan of persisting almost everything in the primary database. With one exception: I'd immediately use object storage (S3) for files which are large in number or size. Files which are few and small (e.g. templates) are fine in the db.