HomeOn-Demand LearningSQL ServerIntroduction to PowerShell

Introduction to PowerShell


What Will You Learn?

  • Understand what PowerShell is and how it can be used
  • To understand and work with cmdlets
  • How to navigate the PSProvider and work with the pipeline
  • To write your own scripts for managing SQL Server


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.




Joshua is a Systems Engineer at the University of North Florida, and has been in this role for 2 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 (3 and 1) and has lived in Jacksonville FL since 2014.


What to Know Before the Class

This course assumes you have no prior knowledge of Azure SQL Database.

Curriculum For This Course

System Requirements

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

You may also like…