• Online, Self-Paced
Course Description

Write maintainable and production-quality scripts that save time and effort.

PowerShell is the de facto standard for scripting in Microsoft Windows environments. By knowing how to use PowerShell, system administrators can quickly automate complex, repetitive, and otherwise time-consuming tasks.

This video course will help you to master automation and finish the course by building a variety of PowerShell scripts to automate your environment and reduce the amount of code required. Through real-world examples, you will learn how to simplify managing your Windows environment and then effectively administer Windows-based systems and environments by using advanced functions.

You will gain a strong foundation to advance your existing PowerShell knowledge through real-world scenarios. By the end of this course, you will be able to quickly produce scripts that can be run in your existing environments, and perform and automate tasks by building scripts that involve systems and enterprise management.

You will finish the course by getting a thorough understanding of how to use advanced features to work with Active Directory and the file system, and will deploy tried and tested scripts for a variety of management tasks.

This course uses PowerShell 5, while not the latest version available, it provides relevant and informative content for legacy users of PowerShell.

About the Author

Heiko Horn started out as technician and worked his way into computing and programming as his focus, and life orientation shifted. He has experience with various operating systems and has been working with PowerShell for the past 10 years. He became interested in this scripting language as a means of minimizing workload by automating several steps and therefore saving time. His job involves several changes throughout the year; adding or changing only a couple of aspects within a PowerShell script frees up time for other tasks he faces as a System Administrator.

Learning Objectives

Explore the new features available in Windows PowerShell 5
Successfully handle error messages by using the try, catch, and finally block
Debug code, log messages to the Windows event viewer, and send information, warnings, and errors by email
Use robust PowerShell scripts in your datacenter to automate redundant tasks
Access a remote database server to import and use the cmdlets that are available for SQL
Query Microsoft SQL Server and MySQL Server and store the acquired information in memory in order to achieve tasks
Connect to an API with XML and JSON that do not allow direct access to the database
Automate group assignment and how to search by Organizational Units
Work with real-world examples, which are simplified by applying Po

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.