How to switch to from core HR to HR Analytics or HRIS career path? Suggestions for training schools?

Hi everyone, i am a Human resource professional and recently relocated to toronto from the USA with my permanent residence. i am considering switching careers to move from a core HR path to one that has some form of HR Reporting and analytics. so along the lines of a Human Resource Information System Analyst, Workday specialist ,etc. I’ve done my research and typically they are seeking individuals with reporting background in SQL, ORACLE, etc. Does anyone know anyone or know of any schools where i can take an intense 3 month or 6 month course that can specialize in either of these? I know there were such schools in the US but will like to be introduced to some in the Toronto area and will like to be connected to anyone who can offers such services? Any online recommendations are welcome as well. Please help!!