You’ve recently been hired by RetroToy, an online retailer that sells replacement parts to hobbyists who restore out-of-production toys and games. RetroToy’s business is steadily growing, and so is its collection of product images. Your task is to ease the process of finding images by standardizing the naming convention. As an IT professional, you know PowerShell is a powerful language for automating repetitive IT tasks, and you decide it’s the perfect tool for this project. You’ll set up your development environment by installing Visual Studio Code, an IDE with a PowerShell extension. You’ll make this hefty project more manageable by breaking it into smaller tasks. To automate the process of renaming the large inventory of product images, you’ll write PowerShell code that takes advantage of the pattern-matching ability of regular expressions.

This project is for Windows only.

You’re an IT professional who’s been hired by RetroToy, an online retailer that sells replacement parts to hobbyists who restore out-of-production toys and games. To help support RetroToy’s growing success, you’ve been tasked with reducing the company’s IT workload by eliminating manual tasks using automation. Using PowerShell’s Common Information Model (CIM) commands, you’ll capture information from different PCs. Then, you’ll format the data you’ve gathered into a user-friendly CSV format and output these values into a single source. With the CIM commands you’ll learn in this project, you’ll be automating tasks—like adding and removing Windows features, updating software, and setting up network drives—with ease.

This project is for Windows only.

Your manager at RetroToy, an online retailer that sells replacement parts to toy and game hobbyists, needs product data downloaded from a vendor’s API. As an IT professional for the company, this task falls to you. You’ll connect to the data using Invoke-RestMethod, which will automatically parse the JSON result as PSCustomObjects. You’ll handle errors with PowerShell’s Try/Catch/Finally statement, ensuring your code behaves as expected. You’ll also save yourself time and effort by taking advantage of PowerShell Gallery, a central repository for PowerShell content, to find and install a third-party script for logging errors. With Task Scheduler, you’ll automate your daily tasks, giving yourself the freedom to focus on more productive endeavors.

This project is for Windows only.

As the star IT professional at RetroToy, an online retailer that sells replacement parts to toy and game hobbyists, you’ve been tapped by the IT director to resume work on a previously started project for generating reports from RetroToy’s e-commerce website and emailing them to the management team. Using PowerShell and existing SQL Code, you’ll connect to the site’s SQL Express Database and query data from it, and you’ll protect sensitive information using the SecretManagement and SecretStore modules. You’ll export data to a visually appealing, email-friendly format using CSS and HTML, then send the report in an email using SendGrid, a popular tool among PowerShell users.

This project is for Windows only.