The terminal is like the cmd window in Windows- the black window with the DOS like commands.
It's useful for running diagnostic tools, making changes to configuration files, installing software sometimes. 99.9% of the time though you'll be using the GUI.
Installing software is easy using Add/Remove or Synaptic. Debian packages are pretty easy via the terminal. I've never needed to install anything else- what applications do you need?