Advanced Photonics with Second-Order Optically Nonlinear Processes