PowerShell for SysAdmins: Reading and Parsing Data (v7+) - Automate Data-Related Tasks

Join our course, "PowerShell for SysAdmins: Reading and Parsing Data (v7+)." For people who already know PowerShell, to some extent, there is the Reading and Parsing Data (v7+) tool. To follow along perfectly, you must be on Windows 10 or later and PowerShell 7 or new, preferably the latest. Furthermore, having another Windows computer is handy for rehearsing the usage of the available remote commands. These activities will become easier for you, and you can do them faster after taking this course.

"PowerShell is designed to help you be more productive, solve problems more efficiently, and create powerful tools that can automate many aspects of your work."

During the course, you will get acquainted with working with such data as CSV files, Excel spreadsheets, JSON, and REST APIs. We will help you automate data-oriented tasks and generate monitoring/reporting tools here. All these will be taught with practical aspects accompanied by real applications created from a computer inventory report, a Windows service monitoring tool, and querying data from a REST API.

By the end of this course, "PowerShell for SysAdmins: Reading and Parsing Data (v7+)”, you will have the necessary k know-how to work with structured data seamlessly with PowerShell. Whether you are a system administrator, an Information Technology worker, a DevOps engineer, or someone simply interested in improving PowerShell usage, this course will give you practical experience in becoming more effective and productive in your job position.

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

1. Introduction - 04:14
2. Reading CSV Files - 04:51
3. Filtering CSV Data - 03:15
4. Creating CSV Files - 03:27
5. Section Quiz - 5 questions
6. One at a Time… - 05:09
7. Querying CIM - 03:43
8. Refactoring using the Pipeline - 06:29
9. Saving Output to CSV - 02:19
10. Adding Error Handling - 02:32
11. Section Quiz - 5 questions
12. Introducing the ImportExcel Module - 02:06
13. Exporting a Process List to Excel - 02:13
14. Managing Worksheets in Excel - 02:46
15. Section Quiz - 5 questions
16. Brainstorming and Creating a Rough Script - 04:54
17. Adding Parameters: Querying Services - 04:52
18. Adding Parameters: Exporting - 02:11
19. Section Quiz - 5 questions
20. Working with JSON - 02:09
21. Working with Nested JSON Objects - 03:10
22. Handling Errors in JSON with PowerShell - 02:25
23. Section Quiz - 5 questions
24. Brainstorming and Creating a Rough Script - 02:56
25. Refactoring and Making a Reusable Tool - 05:25
26. Section Quiz - 4 questions
27. Key Takeaways - 03:57

Who is this course for?

1. That is why system administrators are trying to automate as many processes related to data management as possible and optimize the work with PowerShell.
2. IT staff who want to enhance worked capacity with CSV, Excel, JSON, and REST API through PowerShell.
3. To sum up, DevOps engineers need accurate and well-organized data integration and proper connection of PowerShell with the most popular data types.
4. The intent of users of IT automation attempting to establish enhanced, extensive, and flexible monitoring, and reporting instrumentation employs PowerShell and structured data.

Click on the links below to Download PowerShell for SysAdmins: Reading and Parsing Data (v7+)!