PowerShell for SysAdmins: Reading and Parsing Data (v7+)

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 tools
• Work with CSV files, Excel spreadsheets, JSON, and REST APIs
• Gain hands-on experience through real-world projects and practical examples

You’ll learn how to:

• Read, filter, create, and update CSV files using cmdlets like Import-Csv, Where-Object, and Export-Csv
• Install and leverage the ImportExcel module to create, read, and update Excel workbooks and worksheets seamlessly
• Query and parse JSON data, handle nested objects, and manage JSON syntax errors
• Interact with REST APIs using Invoke-WebRequest and Invoke-RestMethod cmdlets to retrieve and process data efficiently

Real-world projects:

• Build a computer inventory report
• Create a Windows service monitoring tool
• Query and parse data from a REST API

These 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.

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.

Last Updated 5/2024

Download Links