Switching from service to product based

I recently completed 1 year at a service based analytics firm and looking to switch to a product based firm. I have been working mostly on Excel and PowerBI.

Looking for sources to learn SQL and Python from and interview prep for case study and guesstimates rounds

Any other advice for the first switch from experienced folks also appreciated