2 x 2.26 ghx quad core

I am a videographer who needs to bring my Mac Pro back from the dead. Nerdy with video files but not computer parts. My reading thus far has prompted me to look into the following. I am looking for a better understanding of each of the following and which upgrades are beneficial and worth it...