55069: PowerShell for SQL Server Administrators

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Call for In Class or Live Virtual Dates2$1,495 USDPurchase


PowerShell for SQL Server Administrators

This instructor-led course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. You will learn how to manage day-to-day and scheduled maintenance tasks. The focus will be administration of the database engine, but optional material and exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included. The course may need to be taught in three days instead of two to include all the optional labs.

Duration: 2 Days


  • Experience working on Windows desktops or servers
  • Experience working in a Windows domain environment
  • Experience administering SQL Server Servers (1 year recommended)
  • Fundamental experience with PowerShell (1 year recommended)


  • SQL Server Administrators who work in a Windows network environment

Learning Objectives

  • Install and configure SQL Server and all its components using PowerShell
  • Configure SQL Server policy-based management review
  • Manage day-to-day SQL Server administration with PowerShell
  • Use PowerShell to Manage Database Availability (Using Clustering and AlwaysOn Availability Features)
  • Maintain the SQL Server environment using PowerShell scripting and programming options


  • Install and Configure SQL Server with PowerShell
  • Administering SQL Servers with PowerShell
  • Maintaining SQL Server with PowerShell
Right Menu IconMENU