55069 PowerShell for SQL Server Administrators

Price
$1,190.00
SATV Eligible
Duration
 2 Days
Delivery Methods
 VILT    Private Group
Skip to Class Dates
Request More Information
Printable PDF / Omit Schedule

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.

 

Upcoming Class Dates and Times

Jan 28  - Jan 29, 2021
8:00AM - 4:00PM Central
2 Days
Virtual Instructor Led
 GTR
Enroll
May 13  - May 14, 2021
8:00AM - 4:00PM Central
2 Days
Virtual Instructor Led
 GTR
Enroll

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.

Agenda

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

Prerequisite Courses Recommended

  • 10961 Automating Administration with Windows PowerShell