Introduction to Powershell

Learn Windows PowerShell basics, explore tools, cmdlets, PSProvider, Pipeline. Dive into domain-specific topics for Data Professionals, including DBA workloads, Reporting Services, community-built cmdlets.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

This course includes:

5+ hours hours of training
Access on mobile and browser
Certificate of Completion

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.

This course includes:

5+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

Introduction to PowerShell - What you need to get started

This course includes:

5+ hours hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Industry Expert

Learn More

This course includes:

5+ hours hours of training
Access on mobile and browser
Certificate of Completion

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

This course includes:

5+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

This course includes:

5+ hours hours of training
Access on mobile and browser
Certificate of Completion