All single covalent bonds are sigma bonds -- these bonds are between the nuclei on the so called internuclear axis. If 2 parallel p orbitals on different atoms overlap, a pi bond will be formed. The top lobes of the p orbitals overlap, as do the bottom ones.
A sigma and a pi bond is a double bond. A sigma and 2 pi bonds is a triple bond.