Dear Milan

There are only a few colleges in Germany which offer a course in Petroleum Engineering. One of it is Clausthal University of Technology. The tuition fee for the course in this university is 110,00 EUR per semester. Besides this one, you can find many public technical universities in Germany which offer engineering education at very nominal prices, however, you might have to check their individual websites to see if the course in Petroleum Engineering is offered there. The link to top universities in Germany is given below. You can explore your options for Petroleum Engineering and other sister-disciplines there. 

Check Top Universities in Germany 2018

Regarding the scope for Petroleum Engineers in Germany, there's a good chance for these specialists to get into R&D sector of big car manufacturers, etc. in Germany, contributing to their search for new energy usage methods for any kind of vehicles. But the field is nonetheless competitive. 

Hope it helps. 

All the best!