PowerShell

I want to migrate files from Microsoft SharePoint Server to Azure Blob Storage using PowerShell. It seems I got a lot of files not found problems and connection/permission issues. I tried to fetch files from SharePoint Server but turns out to be not working.

Since I don't have the knowledge to evaluate this choice correctly, and since it is fundamental to the success of the project, I wanted to know the community's opinion on the matter.

Thank you :)

Out of curiosity, when my coding instructor for Python did some commands on his computer, he told me learning any sort of terminal command interface (e.g. GNU Bash, PowerShell, Zsh ) will make me understand systems and how computers work and would make me know the basics of systems programming (although I am more into web development). I immediately went curious, out of my time, and looked up some command line interfaces to learn. It gave me bash, shell, zsh, powershell, etc. All these are really confusing, and they all seem the same. I want to be a terminal dweller, so which of the terminal related things should I learn? I think Bash, since it can replace Powershell on Windows, and has all the Linux/macOS systems.

I am technical support. I work daily with Windows Server / Exchange, Active directory. I would like to learn scripting and automation to make my life easier. I just started learning PowerShell but not really sure about the correct study path from where I can start. I am taking some courses on Udemy and YouTube. Is it enough?

Objective: I am trying to build a custom service that will create VMs in Azure, based on inputs taken from a web interface. I want the backend code that interacts with Azure to be PowerShell.

Ask: Hoping to find help with deciding the simplest architecture of tools to achieve this.

What I have so far with my Limited Knowledge: I am new to Azure and Jenkins. I arrived at Jenkins coz it can run PowerShell and has API that can be called to trigger a job. Although integrating with it over the web seems problematic since its on-prem network. I hear it is possible using the VPN. For the Web, I hope to use Azure Web App with Python/Node.js that I can manage to make API calls to Jenkins.

Is there a better way? I just need help getting the right directions; I will walk the way.

I currently work helpdesk and have been for about 6 years. I am looking to become more valuable, and I can't decide what route to take? Python is of interest, and so is PowerShell. What are some recommendations? Maybe something that would benefit a helpdesk position or even get into a network administrator.