PowerShell for SysAdmins (v7+)

Reading and Parsing Data
What you'll learn:
Install and use the ImportExcel module to create, read, and update Excel workbooks and worksheets using PowerShell.
Read, filter, create, and update CSV files using PowerShell cmdlets like Import-Csv, Where-Object, and Export-Csv.
Query and parse JSON data, handle nested objects, and gracefully manage JSON syntax errors using PowerShell.
Interact with REST APIs using Invoke-WebRequest and Invoke-RestMethod cmdlets to retrieve and process data in PowerShell.
Requirements:
Be an intermediate PowerShell scripter. Beginners are encouraged to take the first course in the series called "Getting Started" first.
Use Windows 10 or a later version of Windows. Most tasks don't require Windows but not everything is guaranteed to work the same if not using Windows 10+.
Have PowerShell 7 or later installed to have the exact same experience as what's shown in the course.
Have access to at least one other Windows computer for running PowerShell commands remotely, since a few tools involve interacting with remote machines.
Description:
In this comprehensive course, "PowerShell for Sysadmins: Reading and Parsing Data," you'll dive into the world of structured data management using PowerShell. Building upon an intermediate level of PowerShell scripting knowledge, this course will empower you to efficiently handle and process data from various sources.Key highlights:Automate data-related tasks and build robust monitoring and reporting toolsWork with CSV files, Excel spreadsheets, JSON, and REST APIsGain hands-on experience through real-world projects and practical examplesYou'll learn how to:Read, filter, create, and update CSV files using cmdlets like Import-Csv, Where-Object, and Export-CsvInstall and leverage the ImportExcel module to create, read, and update Excel workbooks and worksheets seamlesslyQuery and parse JSON data, handle nested objects, and manage JSON syntax errorsInteract with REST APIs using Invoke-WebRequest and Invoke-RestMethod cmdlets to retrieve and process data efficientlyReal-world projects:Build a computer inventory reportCreate a Windows service monitoring toolQuery and parse data from a REST APIThese projects will challenge you to apply your newfound skills and provide you with the confidence to tackle your own data-related challenges in your professional environment.Whether you're a system administrator, IT professional, DevOps engineer, or an enthusiast looking to enhance your PowerShell skills, this course will provide you with the knowledge and practical experience needed to streamline your data management processes and take your automation capabilities to the next level.By the end of this course, you'll be equipped with a powerful toolset to efficiently handle structured data using PowerShell, making you a valuable asset in any IT organization.
Who this course is for:
System administrators who want to automate data management tasks and streamline their workflows using PowerShell.
IT professionals looking to enhance their skills in working with CSV, Excel, JSON, and REST APIs using PowerShell.
DevOps engineers who need to process structured data efficiently and integrate PowerShell with various data sources.
DevOps engineers who need to process structured data efficiently and integrate PowerShell with various data sources.
IT automation enthusiasts seeking to build robust monitoring and reporting tools using PowerShell and structured data.
Homepage

https://www.udemy.com/course/powershell-for-sysadmins-parsing-data/

PowerShell for SysAdmins (v7+) Fast Download
PowerShell for SysAdmins (v7+) Full Download