Starting from the Sites of Grace Lake-Facing Cliffs, come to Church of Irith.     Talk to Sorcerer Thops, choose Yes, you can Study sorcery.

Sorcerer Thops - Elden Ring Raiders

Continue to talk to Sorcerer Thops.