Advanced PowerShell: PowerShell Data Mastery (Video Course)

Description

Unlock the full potential of your data with PowerShell by learning how to build advanced PowerShell tools for leveraging and visualizing complex data from multiple sources.

Overview

Take your PowerShell skills to the next level with Advanced PowerShell: PowerShell Data Mastery. 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. Youll start by learning how to extend PowerShells capabilities using C#, Python, and .NET integration, and then dive into working with dates, databases, and SQL applications. With a focus on practical examples and real-world scenarios, youll gain hands-on experience in building custom classes, modules, and database-driven applications.

As you progress through the course, youll learn advanced techniques for data visualization, including chart controls, sorting, and customization. Youll also explore how to work with multiple data sources, handle errors, and optimize script performance. The course culminates in a capstone project where youll build a comprehensive IT ticketing system, leveraging all the skills and knowledge youve acquired throughout the course. By the end of this course, youll be equipped with the expertise to interact with complex data sets, create visualizations, and build robust applications that drive business value. Whether youre a seasoned PowerShell user or an IT professional looking to expand your skillset, Advanced PowerShell: PowerShell Data Mastery will help you unlock the full potential of your data and take your career to the next level.

Skill Level

Intermediate to advanced

Learn How To

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

Course Requirement

The Beginner course and the User Interface Design course should be considered prerequisites for taking this course.

Who Should Take This Course

These courses are designed for IT professionals, system administrators, and power users who want to move beyond basic scripting and learn how to build polished, interactive tools using PowerShell. Whether youre new to PowerShell or looking to deepen your skills, youll learn how to automate real-world administrative tasks, create intuitive user interfaces, and develop advanced applications that streamline everyday operations. The material is ideal for learners who enjoy problem-solving, value efficiency, and want to bridge the gap between command-line automation and professional-grade software design.

About Pearson Video Training

Pearson publishes expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. These professional and personal technology videos feature world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, Pearson IT Certification, and Que. Topics include IT Certification, Network Security, Cisco Technology, Programming, Web Development, Mobile Development, and more. Learn more about Pearson Video training at http://www.informit.com/video.

Video Lessons are available for download for offline viewing within the streaming format. Look for the green arrow in each lesson.

Sample Content

Table of Contents

Lesson 1: PowerShell Extensibility
1.1 Running C# inline
1.2 Running Python inline
1.3 REST APIs
1.4 .NET integration
1.5 Creating and using PowerShell modules
1.6 Dot sourcing
Lesson 2: Working with Dates
2.1 Formatting and calculating dates
2.2 Working with dates in string format
2.3 Working with picker objects
Lesson 3: Database Integration
3.1 Deploying and configuring SQL Server
3.2 The database connection string
3.3 Database queries and responses
3.4 Preventing SQL injection attacks
3.5 Cleaning your data
Lesson 4: Building a PC Inventory Application
4.1 Creating and linking to the database
4.2 Preparing the Active Directory
4.3 Creating the user interface tabs
4.4 Building the Device Inventory tab
4.5 Adding a new device
4.6 Editing a device
4.7 Viewing a device
4.8 Deleting a device and refreshing the list
4.9 Building the Software Inventory tab
4.10 Adding and deleting software licenses
4.11 Assigning a software license
4.12 Revoking a software license
4.13 Editing a software license
4.14 Viewing a software license
4.15 Deleting a software license, revisited
4.16 Building a search engine
Lesson 5: Advanced Application Concepts
5.1 Writing to the Windows Event Logs
5.2 Accessing the Event Logs from PowerShell
5.3 Building a database
5.4 Building a sample GUI
5.5 Storing settings in a database
5.6 Creating database backups
5.7 Logging your database backups
5.8 Dynamically extending the data
5.9 Printing
5.10 Generating PDF files
5.11 Version control
5.12 Signing your code
5.13 Packaging scripts as executables
Lesson 6: Data Visualization
6.1 Overview of chart controls
6.2 Basic chart types
6.3 Advanced chart types
6.4 Sorting and customizing your charts
6.5 Calling out high and low values
6.6 Saving a chart to a file
6.7 Project Build a System Resource Usage Dashboard
6.8 Scheduling the collection of system resource data
Lesson 7: Working with Multiple Data Sources
7.1 Handling multiple data series on a single chart
7.2 Working with PSCustomObject
7.3 Combining multiple data sources into a single data series
Lesson 8: Testing and Debugging
8.1 Basic debugging techniques
8.2 Measuring and optimizing script performance
8.3 Testing PowerShell scripts with Pester
Lesson 9: Capstone Project Building an IT Ticketing System
9.1 Planning the functionality
9.2 Preparing the database
9.3 Building the end-user front end
9.4 Creating the menus and dialog boxes
9.5 Building the main IT interface
9.6 Creating the Details tab
9.7 Building the Resolution dialog box
9.8 Configuring the View filter
9.9 Saving the resolved ticket to a PDF file
9.10 Building the search interface
9.11 Creating the History tab
9.12 Adding the View History Item dialog box
9.13 Creating a System Specs tab
9.14 Creating the Resource Usage tab
9.15 Creating the Events tab
9.16 Adding database backup capabilities

Updates

Submit Errata