Introduction to Powershell

Part Of The On-Demand Courses


  • Understand what PowerShell is and how it can be used
  • Understand and work with cmdlets
  • Navigate the PSProvider and work with the pipeline
  • Write your own scripts for managing SQL Server
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course Description

This class is designed to overview and equip you with the basics of Windows PowerShell, Microsoft’s designated tool for automation within the Windows Environment. This course will introduce you to the tools necessary for using PowerShell, the foundations of Commands (called cmdlets), the PSProvider, and the Pipeline. After this we will cover more domain specific topics for Data Professionals. Including cmdlets for traditional DBA workloads (DML, DDL, DCL), cmdlets for Reporting Services, community-built cmdlets, and the SMO provider. Finally, we will introduce PowerShell DSC, a Declarative framework for configuring systems, which may be used for Installing and Configuring SQL Server. By the end of this course you should feel comfortable with the command line in Windows and will be able to write your own scripts for managing SQL Server.


Click here for a downloadable PDF



Module 00 | Class Introduction
07m 16s total


Module 00A | Class Introduction
07m 16s


Module 01 | Introduction to PowerShell
25m 61s total


Module 01A | What is PowerShell
09m 47s


Module 01B | How Can It Be Used
16m 14s


Module 02 | Understanding Cmdlets
33m 75s total


Module 02A | Getting Help
14m 17s


Module 02B | Other Get Cmdlets
19m 58s


Module 03 | Working with Cmdlets
34m 25s total


Module 03A | Parameter Sets
12m 17s


Module 03B | Cmdlets that Change Things
22m 08s


Module 04 | Navigating the PSProvider
14m 45s total


Module 04A | Navigating the PSProvider
14m 45s


Module 05 | The Pipeline and Objects
34m 89s total


Module 05A | Redirecting Output
09m 11s


Module 05B | Objects in PowerShell
14m 45s


Module 05C | Creating Variables
11m 33s


Module 06 | Filtering, Selecting, Sorting
20m 63s total


Module 06A | Filtering
10m 05s


Module 06B | Selecting and Ordering
10m 58s


Module 07 | Loops and Comparisions in PowerShell
44m 34s total


Module 07A | ForEach and While Loops
17m 16s


Module 07B | Comparison Operators
27m 18s


Module 08 | Running cmdlets on a Remote System
20m 14s total


Module 08A | Running cmdlets on a Remote System
20m 14s


Module 09 | Starting to Write Scripts
34m 68s total


Module 09A | Overview
06m 47s


Module 09B | Writing and Executing a Script
28m 21s


Module 10 | Extending your Scripts
31m 21s total


Module 10A | Overview
03m 08s


Module 10B | Parameters and Functions
28m 13s



IT Systems Engineer
Joshua is a Systems Engineer at the University of North Florida, and has been in this role for 2.5 years. Josh has many different hats on his team, but tends to be given the DBA responsibilities. He is also a passionate advocate for PowerShell and automation of any fashion. He is a husband and father of two boys. They have lived in Jacksonville FL since 2014.

System Requirements

  • Windows 7, Windows 8, or Window 10
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space

What to Know Before Class

No prior knowledge is required to take this course.


Great job Josh, thank you!


Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required