Hi everybody. First, I am sorry if I post in wrong section of Forum, but my question is pretty general so I don’t know where exactly to put it.
I have an idea to make a battle scene between may friend and me (so live action) but with some special effects. I assume that are effects are pretty complex so I know that one software should be not enough.
This is my idea of fighting scene:
I have power of geokinesis so I can move earth, dirt, rocks, mud and other earthly material. My friend for example have power of aquakinesis, so he can manipulate water. That is the basic idea.
So I want to make scene where he and I using that powers, for example I start to rise earth, rocks, stones in air around me, and trow at him. He generates water to make a shield, and block that. Earth shakes, big crater is made from my manipulation, explosions in air when water and earth meet in air, dust flowing, energy beam on all sides and etc. He rise a wave and shoot at me and etc. I believe you understand the point. So I am asking which software I should use for every effect, pretty much I want to know about earth, dust, stones manipulation and combining it in live action 
So any tutorial will be welcome. Thank you for understanding and future help