a somewhat beginner's guide around building a DB

After working on many databases both in my hobby projects and also working professionally as a developer , I have realised that I have spent a inordinate amount of time hacking around various DB's which are incoherent or which differ from each other vastly.