Ramtin - it will take some time and lots of exploring, to develop a good level of knowledge of the capabilities and limitations of Sonar, and of audio processing in general on a computer.
It is a good thing that you are looking into all of this, however I would suggest you take a look at starting with getting a good awareness of the functional capabilities that are already present, because this will advance your ability to USE all of the functionality already built into the product.
There are lots of free videos, as well as ones for purchase, and there are also some TRULY well-written books on getting the most out of a given version of Sonar, as well as some basic tutorials, all to get you up to speed.
So, grab some coffee, arm some tracks, and dive in. ALL of us have had to, and are still going through, a learning curve with Sonar. The trick is to learn how to learn - learn how to find help in the documentation, where to go to find books and videos, take a few hours or a whole day, and read through the Sonar documentation. Make notes, or create hundreds of little 'snippet' notes in Notepad, so you can look things up later, as needed.
I hope you have a lot of fun getting to know Sonar, and that you learn to express yourself musically with it. It's a great product, and a great forum from which you can draw help when you need it.
Bob Bone