Creating customized sounds that are triggered in Salesforce... this is not something typically done. At least not in my experience.
There are some cool ways to trigger sounds using managed packages. One particular option is found via Trailhead here: https://trailhead.salesforce.com/en/content/learn/projects/add-sound-effects-to-your-sf-org.
This goes without saying, but make sure you are doing this in a developer org...
Add sound as a static resource
First find an audio file you want to play. There are some really great free resources here: https://freemusicarchive.org.
Go to Salesforce/Setup/Static Resources. Click New.
Add a Name. For this example, call it your_sound.
Click Choose File and find your audio file. Select it.
For Cache Control, select Public. Cache Control is important for determining who has access to the sound. For instance, if you are going to use it for a public community, you'll need to set it to Public.
Create your Lightning Component
Go to your Developer Console. Salesforce/Gear Icon/Developer Console.
Click File/New/Lightning Component.
Name it test_sound.
Check the Lightning Record Page checkbox only.
Create your Controller js
On right-hand side, click CONTROLLER. This will load test_soundController.js in your Developer Console.
Change myAction to playSound.
Within playSound we need to get the your_sound static resource and assign it to an audio variable and then run the play function on that audio variable. Your controller js code should look something like this:
Add the lightning component to your record page
Create a new Account record (this can be any record really).
Click the Gear Icon and click Edit Page. This will take you to the Account Lightning Page. You can also get to the Lightning Page through Setup.
On your left-hand side you will see a list of Components. Scroll down until you see the Custom components. Find test_sound and drag it onto your canvas. It doesn't matter where.
Now, refresh the record page and you should hear your sound/song play! Pretty cool, right? Now, you don't have to call the playSound function on init. You could call the playSound function when there is an event.
Back to init. Like most things programming, there are multiple ways to do this...
We could play the audio without using init, but instead using HTML. That would be nifty and more simple, wouldn't it?
We'll accomplish this by removing our <aura:handler> tag and replacing it with the <audio> tag. Your code should look something like this:
Save it and refresh your Account record. You should hear your sound/music again, and we did it with one line of code using just HTML!
To get started with Cloud Pacific, go here to complete a simple form. A Cloud Pacific Account Manager will collaborate with you to clarify your needs and goals, and customize a service package and roadmap that will help your business grow and thrive on Salesforce. Reach out to us here!