NEED HELP? TALK TO AN EXPERT (904) 638-5743

Introduction to Powershell

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • 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

Outline

 

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

Instructor

JOSHUA CORRICK

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.

REVIEWS

Great job Josh, thank you!

Anonymous

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