I recommend the book 'The Highest Mage' to you. The main character transmigrated to a country of magic, became an apprentice, and eventually became the highest mage. He studied all kinds of magic and even invented new spells himself. I hope you will like my recommendation.😗