Go to your phone settings and scroll to your ringtones+sounds or notifications+actions. There, you will be able to set different sounds for different events, alerts or notifications using the default tones in your phone.
To add new sounds, simply connect your phone to a PC and save .mp3 or .wav files in the Phone/Ringtones folder - these new sound files should appear in your settings as soon as they are copied to your phone.