[expert] How to install in KDE vs. Console?

[Sevatio Octavio]

Where can I go to find good information that would educate me on the different ways of 
installing software?  I am a bit confused as
to the installation differences between console, kde, rpm, & kpackage.  I thought kde 
allowed you to just click the install file.

Seve