Great pictures come from seeing well more than from an expensive camera. Photography books teach light, composition and patience. See visual portfolios in art and photography and art, music and photography.
Learn the basics of exposure and framing, then practise daily with whatever camera you have. Even a phone can teach you to see light well.
The arts train both the eye and the ear. Whether you are a student or just an admirer, regular practice and careful attention will teach you more than any single theory, though good books certainly guide the way.
Many arts students build a personal library slowly over the years. Begin with a good general history, add books on your own special interest, and visit performances and galleries as often as you can.