Search Training
X

55069 PowerShell for SQL Server Administrators

Course Overview

This 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.

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.

Suggested Prerequisites

Course Outline

1 - Install and Configure SQL Server with PowerShell

  • Install SQL Server
  • Configure Database Settings
  • Configure SQL Server Settings
  • Configure SQL Server Policy-Based Management
  • Lab 1: Configuring SQL Server with PowerShell

2 - Administering SQL Servers with PowerShell

  • Managing Users and Roles
  • Managing Database Performance
  • Managing Database Availability
  • Managing SQL Server Features
  • Lab 1: Administering SQL Servers with PowerShell

3 - Maintaining SQL Server with PowerShell

  • Managing Backups and Restores
  • Maintaining Database Integrity and Performance
  • Monitoring and Auditing
  • Task Automation
  • Generating Reports
  • Lab 1: Maintaining SQL Servers with PowerShell

Enroll Today

This is a 2-day class

Price: $1,190.00
Payment Options

ILT Instructor‑Led Training

OLL Online LIVE

GTR  Guaranteed to Run

Class times are listed Eastern time. This class is available for Private Group Training

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Cart When Time   Where How
03/11/2019 9:00AM - 5:00PM GTR Online LIVE OLL
05/28/2019 9:00AM - 5:00PM GTR Online LIVE OLL

Class times are listed Eastern time
This class is available for Private Group Training