For example for Google messages app, you can tap and hold on messages app icon and then in the pop-up tap on the "i" mark. Then go to notifications and then tap on notification categories. In there tap on incoming messages wording. This will take you to another page, where you need to tap Sound and select what you want.
