So what is a good school for AUDIO PROD? Is it better to go to school or is it better to learn on your own?
Learn something right. True low level knowledge (in the sense of "down to the atoms"). Go for electrical engineering, software engineering, acoustics maybe (hearing aids are a huge market full of cash) or even psychology or media/communication sciences. There are many options available.
Music production, for the most part, consists of so called "high level" information (in the sense of "very low complexity and high accessibility"). You just need to learn to use a dozen tools, but none of these schools will never (be able to) explain how they work and why. This is worthless knowledge, you just learn to use the tool X and the program Y. This isn't much better than another house-wife excel training.
Also what are the main programs the industry is using lately?
It doesn't matter. Every kid can use such programs after a little try and error. Again, every true engineer (and employer) just giggles about such "skillz".
I have been using pro tools for some time now and I want to further my knowledge in a studio like atmosphere.
What is a "studio like atmosphere"? Chris mention already that such things only exist in 80's and 90's music videos. These times are gone! Forget the whole studio atmosphere thing. It's an illusion.
Or just get some sort of background innfo to take my education a little further.
Ok, here it is. Seriously, that should be your primary goal. Solid education and hard, hard work is what makes you successful, this is not secondary!
Lookup every question via Wikipedia, start to read true scientific books, articles and papers. Get an AES membership (not SAE!!

), it a bit costly, but you can then access an amazing information pool created by some of the most regarded communication engineers. Same here, you have a whole world of possibilities right beside your mouse cursor - use them!
Over the years, I strongly specialized into enterprise software development and earn so much that I can now basically spend 3/4 of my time running cool projects like a record label, development of several plugins and audio apps as well tons of other things without financial drawbacks. Not to mention several companies more related to "making money". I'm now 32. And happy to spend most time of my life with the things I love. Many things are possible, but you need to take the initiative, you need to learn more than everybody else and word harder and better than anyone else. Then, you'll have a small chance to actually reach your goal and end up with something very similar to the "studio atmo" you mentioned above. It's possible, but you'll need to seriously fight for it. The competition in all these "cool" jobs is insane. Absolutely insane. Nobody pays for average or "good enough" services.