The CSC course is a requirement to work in the banking sector in Canada. Once you pass the exam, you are eligible to be registered as a Mutual Fund Representative in a bank. This course has two parts. You must pass Part 1 and Part 2. Then you can get registered with MFDA or IIROC as a mutual fund representative.
If you pass the CPH (Conduct Practices Handbook), then you can advise clients on how to invest their money by recommending suitable stocks, bond, mutual funds and many other investments. Some banks hire candidates without the CSC and you must pass it within 3-6 months. Others hire only qualified employees.
If you plan on only working in the retail bank in Canada, the IFIC exam is sufficient, you don't need to do the CSC. But if you want more job opportunities in the future, the CSC is best.