How to turn off notification noise on apple

How to turn off notification noise on apple pictures 5