I am looking for this book. It was written by someone in the bard's college but I can't find it there. Does anyone know where it is located? It's the one that contains the full main theme in both dragonic and in english. It also has age of aggression, Ragnar the red and a few more.

Have a look around the Bard's College in Solitude? That's where the author lives.

I've looked pretty hard at the college. I couldn't find it there.

Does anyone know?

I'm on my phone right now so can't be bothered to do it for you but maybe check the wiki?

I believe that is on a table at the Bard's College, not actually on the bookshelf.