in my opinion
this is not something you can learn with an article or video.
- this experience.
- trial and error.
- Spending time with SW.
- reading articles in forums.
- Navigating the SW help menu.
- most important is curiosity.
this list extends.
in short, in time.
I agree with ömür tokman but I have two little tips to get you started
The first is to use the What's Wrong dialog.
The second is to use Flat Tree view (CTRL-T)
I agree it takes a bit of experience.
Just to add to Rob's comment, I would recommend starting at the top of your tree and working your way down as errors at the top can cause errors further down. Using Ctrl+T as Rob suggested can really help with this. I also think a good technique is to use your rollback bar and take it one error at a time.