Need Some Academic Advice

I recently completed my graduation and was planning to pursue a master's in Counselling Psychology. Unfortunately, I didn't get admission to that program and was offered a seat in School Psychology instead.

I'm unsure about this because I don't think I want to become a school counsellor. However, I'm considering giving it a chance and completing the two-year School Psychology program.

My main goal is to practice counselling and provide therapy in the future. Would a master's in School Psychology allow me to do that, or would I need to pursue a PG Diploma (PGDM/PG Diploma) in Guidance and Counselling afterward?

I'm feeling quite confused about which path would be be better in the long run, and I'd really appreciate any advice or insights from people with experience in this field.