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