Let me make a few comments here starting with sheaf cohomology. It can be defined in several ways, but the definitions are less important the properties:
- $H^0$ of a sheaf coincides with its global sections.
- Short exact sequences of sheaves give rise to long exact sequences of sheaf cohomology.
- It can be computed by acyclic resolutions, such as fine resolutions on a paracompact Hausdorff space.
Using 3 plus the Poincaré lemma, we get a version of de Rham's theorem that sheaf cohomology of a manifold with coefficients in the constant sheaf $\mathbb{R}$ coincides with de Rham cohomology. A similar application of 3 shows that on a complex manifold, sheaf cohomology of the sheaf of holomorphic $p$-forms coincides with Dolbeault cohomology. Also, on a sufficiently nice space (e.g. a manifold) singular cohomology with coefficients in an abelian group $A$ coincides with sheaf cohomology with coefficients in $A$. This is also true if $A$ is replaced by a local system. A local system comes with a monodromy representation $\pi_1(X)\to Aut(A)$. There is map from group cohomology to singular cohomology $$H^i(\pi_1(X), A) \to H^i(X, A)$$ which is an isomorphism if $X$ is aspherical (Eilenberg-Maclane) but not in general (e.g. take $X=S^n, n>1$).
People have mentioned several good referencesPostscript A more genuine answer, which you would needbe even more unhelpful to consult for proofs of the above. Actually, I'm not sure any ofOP than the ones mentioned discuss Dolbeaultone I gave, so letis me add Griffithsthat I doubt there is a single coherent and Harriseasy treatment of all of these disparate topics. But there are plenty of good references (some of which have been mentioned) that cover algebraic topology, Voisingroup cohomology and its applications, sheaf cohomology and Wells books on algebraic geometry/complex manifoldsits applications, homological algebra. Although these may not satisfy the "not too hard core" requirement..