Advanced PowerShell: PowerShell Data Mastery by Pearson

Course details

This advanced course is designed to help you harness the power of PowerShell to work with complex data sets, create interactive visualizations, and build robust applications. Start by learning how to extend PowerShell capabilities using C#, Python, and .NET integration. Then dive into working with dates, databases, and SQL applications. Review practical examples and real-world scenarios and gain hands-on experience in building custom classes, modules, and database-driven applications. Learn advanced techniques for data visualization, including chart controls, sorting, and customization. Explore how to work with multiple data sources, handle errors, and optimize script performance.
The course culminates in a capstone project where you'll build a comprehensive IT ticketing system, leveraging all the skills and knowledge you've acquired throughout the course. By the end of this course, you'll be more equipped to interact with complex data sets, create visualizations, and build robust applications that drive business value. Whether you're a seasoned PowerShell user or an IT professional looking to expand your skillset, this course can help you unlock the full potential of your data and take your career to the next level.

Learning objectives
Build PowerShell scripts that leverage SQL Server.
Visualize data with charts and graphs.
Combine multiple data sources.
Harness the power of the .NET framework.

Concepts

Introduction

Advanced PowerShell - Introduction

PowerShell Extensibility

Learning objectives
Running C# inline
Running Python inline
REST APIs
.NET integration
Creating and using PowerShell modules
Dot sourcing

Working with Dates

Learning objectives
Formatting and calculating dates
Working with dates in string format
Working with picker objects

Database Integration

Learning objectives
Deploying and configuring SQL Server
The database connection string
Database queries and responses
Preventing SQL injection attacks
Cleaning your data

Building a PC Inventory Application

Learning objectives
Creating and linking to the database
Preparing the Active Directory
Creating the user interface tabs
Building the device inventory tab
Adding a new device
Editing a device
Viewing a device
Deleting a device and refreshing the list
Building the software inventory tab
Adding and deleting software licenses
Assigning a software license
Revoking a software license
Editing a software license
Viewing a software license
Deleting a software license, revisited
Building a search engine

Advanced Application Concepts

Learning objectives
Writing to the Windows Event Logs
Accessing the event logs from PowerShell
Building a database
Building a sample GUI
Storing settings in a database
Creating database backups
Logging your database backups
Dynamically extending the data
Printing
Generating PDF files
Version control
Signing your code
Packaging scripts as executables

Data Visualization

Learning objectives
Overview of chart controls
Basic chart types
Advanced chart types
Sorting and customizing your charts
Calling out high and low values
Saving a chart to a file
Project - Build a system resource usage dashboard
Scheduling the collection of system resource data

Working with Multiple Data Sources

Learning objectives
Handling multiple data series on a single chart
Working with PSCustomObject
Combining multiple data sources into a single data series

Testing and Debugging

Learning objectives
Basic debugging techniques
Measuring and optimizing script performance
Testing PowerShell scripts with Pester

Capstone Project - Building an IT Ticketing System

Learning objectives
Planning the functionality
Preparing the database
Building the end-user front end
Creating the menus and dialog boxes
Building the main IT interface
Creating the Details tab
Building the Resolution dialog box
Configuring the View filter
Saving the resolved ticket to a PDF file
Building the search interface
Creating the History tab
Adding the View History Item dialog box
Creating a System Specs tab
Creating the Resource Usage tab
Creating the Events tab
Adding database backup capabilities

Summary

Advanced PowerShell - Summary