Any video or a guide on how to not miss quests that you can be locked out of

A friend of mine told me some stuff you can straight up miss forever and I hate that in games. Any guide detailing all the missable stuff so I don't miss it would be neat