Phononic and Electronic Excitations in Complex Oxides Studied with Advanced Infrared and Raman Spectroscopy Techniques