Holomorphic Foliations with Singularities: Key Concepts and Modern Results