- Lab
-
Libraries: If you want this lab, consider one of these libraries.
- Core Tech
Work with Data in Windows PowerShell
In this lab, you'll practice working with various data formats in Windows PowerShell. You'll gain hands-on experience manipulating CSVs, JSON, XML, and other structured data. When you're finished, you'll have developed skills in data cleaning, conversion between different formats, creating interactive HTML reports, and interacting with REST APIs to send and retrieve data.
Lab Info
Table of Contents
-
Challenge
Get Started in the Lab Environment
Here are the initial instructions and explanation of the lab environment. Read this while your environment is busy creating itself from nothing. Yes, this violates physics; we know. How fun!
-
Challenge
Import and Clean CSV Data
In this hands-on lab, you'll use PowerShell to clean and prepare complex CSV data for migration to a new CRM system. You'll learn to handle encoding issues, identify non-standard characters, and manage null values to ensure seamless data integration.
-
Challenge
Import and Export CliXML Data
Dive into PowerShell's data manipulation capabilities! Learn to handle complex data structures, use CliXML for serialization and deserialization, and ensure data integrity across sessions and systems.
-
Challenge
Convert PS Objects to JSON
Explore complex employee data structures, convert PowerShell objects to JSON for API integration, and transform JSON back to objects for analysis. Master data manipulation essential for modern IT professionals.
-
Challenge
Convert XML to Objects
Master converting PowerShell objects to XML strings and XML to objects. Essential for working with REST APIs, you'll transform employee data for payroll submission and convert API responses for reporting.
-
Challenge
Build an HTML Report
Transform CSV data into captivating web reports using PowerShell! Learn to convert objects to HTML, enhance reports with titles, headers, and CSS styling, and to add interactive charts for data visualization.
-
Challenge
Redirect Objects to a File
Master PowerShell's Out-File cmdlet by generating comprehensive server reports. Capture running processes, append system details, and avoid overwriting data. Gain essential skills for system documentation and analysis.
-
Challenge
Create Files with Set and Add-Content
Master PowerShell's Set-Content and Add-Content cmdlets to create and append data to files. Learn to import, manipulate, and combine data from multiple sources, automating report generation and streamlining data management.
-
Challenge
Query REST APIs with Invoke-RestMethod
Master PowerShell's web interaction capabilities. Learn to send and update data via APIs, handle errors, extract information from web pages, and create reusable functions for seamless integration with web services.
Real skill practice before real-world application
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Learn by doing
Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.
Follow your guide
All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.
Turn time into mastery
On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.