I am a non IT background, my recent projects uses PowerShell for a lot of SQL Server administration. I would like to start from absolute zero, and learn to use and code the Windows PowerShell as it was meant to be used. I am looking for a good book for beginners or other materials? Thoughts?
Agree with @HandyD for SQL Powershell.
Above that I will like to point one more source for Powershell learning Tutorials Point. This source coveres basics of Windows Powershell.
Now, first let's make one thing clear that Windows Powershell and SQL Powershell both are different.
SQLNeeds SQLPS installed as component. Similarly windows needs newer version of Powershell tools installed.
Note: Powershell have some version specific commands which may not be supported on older version in same way in current version. So check version of PS installed each time before starting on new machine. Latest is version 6 of Powershell source: How to install Powershell
I hope this helps.