This post is going to be a summary of the ideas constructing the exceptional pullback functor π!:QCohY→QCohX (read "pi shriek") in the case π is a finite flat morphism following Vakil's Foundations of Algebraic Geometry. The general construction for π! quite heavily relies on derived categories and so we won't go over it here, but the reader can consult Sheaves on Manifolds by Kashiwara and Schapira.
The purpose is that π! naturally serves as a right adjoint to the pushforward π∗, which is strange since normally we think of π∗ as right adjoint to π∗. Let π:X→Y be a finite flat morphism of locally Noetherian schemes, and let G be a quasicoherent sheaf on Y. Then
HomY(π∗OX,G)
is also a quasicoherent sheaf on Y as π∗OX is locally finitely presented. To see this, take a local finite presentation on U⊂Y
Since QCohY is an abelian category, this shows HomY(π∗OX,G) is quasicoherent on Y. Further, HomY(π∗OX,G) has the structure of a π∗OX-module (by (r⋅φ)(s):=φ(rs)). We show this gives it the structure of a quasicoherent sheaf on X. More generally,
Lemma Suppose R is a quasicoherent sheaf of algebras on Y, and π:SpecYR⟶Y is an affine morphism. Then the category of quasicoherent sheaves on Y with the structure of R-modules is equivalent to the category of quasicoherent sheaves on SpecYR.
Let F be a quasicoherent sheaf on Y with the structure of a R-module. Since everything is affine-local on the target, it suffices to assume Y=SpecA and hence π:SpecYR=SpecR→SpecA for some A-algebra R. Then F≃M~ as OSpecA-modules for some A-module M by quasicoherence. By assumption, M has the structure of an R-module MR, and so we can define the quasicoherent sheaf MR~ on SpecR. It remains to show this is functorial in F, which we omit.
In the above, we take R=π∗OX and note that SpecYπ∗OX≃X since π is affine. Since HomY(π∗OX,G) is quasicoherent on Y with the structure of a π∗OX-module, we get a quasicoherent sheaf on X. This is the definition of our covariant exceptional pullback functor
π!:QCohY→QCohX
We have natural isomorphisms of functors QCohY→QCohY
π∗π!∼HomY(π∗OX,−)
Further, one can check that for F∈QCohX and G∈QCohY we have a natural isomorphism functorial in F,G
π∗HomX(F,π!G)⟶HomY(π∗F,G)
In particular, (π∗,π!) form an adjoint pair.
Application to Frobenius Splitting
One nice application appears in characteristic p>0 geometry. Let F:X→X be the absolute Frobenius morphism. A variety X is called Frobenius split if the map
OX→F∗OX
splits as OX-modules. Using the exceptional pullback, we can reformulate this condition. Consider
F!OX≃HomX(F∗OX,OX)
Then X is Frobenius split if and only if there exists a morphism F!OX→OX inducing the identity on OX via adjunction. When X is smooth, we can identify
F!OX≃ωX1−p
via an extended application of Grothendieck-Serre duality. This gives the classical criterion of X being Frobenius split if and only if there exists a section
σ∈H0(X,ωX1−p)
whose residue is 1. This perspective relevant to flag and toric varieties, where explicit Frobenius splittings can be constructed.