Download PDF
of this course

MS55069 - PowerShell for SQL Server Administrators (MS55069)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration : 2 Days

This two-day instructor-led course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks. The main focus will be administration of the database engine, but material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.

Who Should Attend

  • This course is intended for SQL Server administrators who work in a Windows network environment. At least one year of experience administering SQL Servers and using PowerShell is recommended.

Course Certifications

This course is part of the following Certifications:


Before attending this course, students must have:

  • Experience working on Windows desktops or servers

  • Experience working in a Windows domain environment

  • Experience Administering SQL Server Servers

  • Fundamental experience with PowerShell or Course 10961B – Automating Administration with Windows PowerShell


Course Objectives

After completing this course, students will be able to:

  • Install and Configure SQL Server and all its components using PowerShell

  • Manage day-to-day SQL Server Administration with PowerShell

  • Maintain the SQL Server environment using PowerShell scripting and programming options


Course Content

Module 1 : Install and Configure SQL Server with PowerShell

This module explains how to setup SQL Server components using PowerShell 


  • Module oBjectives
  • Lessons 1 : Install SQL Server
  • Lessons 2 : Configure Database Settings
  • Lessons 3 Configure SQL Server Settings
  • Lessson 4 : Configure SQL Service Policy-Based Management
  • Review

Lab : Configuring SQL Server with PowerShell

After completing this module , students will be able to :

  • Install SQL Server 
  • Add/Remove compoennts to an existing instance ( SSRS , SSIS  , SSAS , etc )
  • Configure SQL Serber and Database Settings
  • Configure SQL Server Policy-Based Management 


Module 2 : Administering SQL Server with PowerShell

This module explains how to perform day-to-day administrative tasks on SQL Server using PoweShell.


  • Module Objectives 
  • Lesson 1 : Managing Users and Roles
  • Lesson 2 :Managing Database Performance
  • Lesson 3 : Managing Database Availability
  • Lesson 4 : Managing SQL Server Features
  • Review

Lab : Administering SQL Servers with PowerShell

After completing this module , students will be abe to :

  • Managing Users and Roles 
  • Manage Database Performance
  • Manage Database Availability with Clustering and AlwaysOn Availbability Groups
  • Manage integration Services with Analysis Services


Module 3 : Maintaining SQL Server with Powershell

This module explains how to perform maintenance tasks on SQL using

  • Module Objectives
  • Managing Backups and Restores
  • Maintaining Database Integrity and Performance
  • Monitoring and Auditing 
  • Task Automation
  • Generating Reports
  • Reviews

Lab : Maintaining SQL Servers with PowerShell

After completing this module , students will be able to :

  • Managing SQL Server Backups and Restores
  • Maintain Database Integrity and Performance
  • Monitor and Audit Changes to a SQL Server
  • Task Automation on SQL Server
  • Generate SQL Server Reports

Additional Reading

To help you prepare for this class , review the following resources

  • Classroom Training : Course 10775A - Administering Microsoft SQL Server 2012 Databases

Course ID: MS55069

Show Schedule for 1 Month  3 Months  All 
Date Country Location Register