This class is designed to show you how to use Windows PowerShell to automate and manage SQL Serve. Throughout this course we will look at 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. We will also introduce PowerShell DSC, a Declarative framework for configuring systems, which may be used for Installing and Configuring SQL Server. This course will include Labs and Projects that will help you practice what you learn. By the end of this course you should feel comfortable writing your own scripts for managing SQL Server.
We recommend first taking the Introduction to PowerShell course first but this is not mandatory.