A sigma bond is the end-to-end overlap of the bonding orbitals, usually hybrid orbitals. The sigma bond is a single bond.
A pi bond is the side-to-side overlap of unhybridized p-orbitals. A pi bond, along with a sigma bond form a double bond.
sigma bond is used in hybridization but pi bond when dealing with saturated molecules is not used,that is double bonds.