Community Course

PowerShell for SQL Server Administrators

55069AC (Class Pack)
Based on student feedback via 'Metrics that Matter'
PowerShell for SQL Server Administrators
(Updated for SQL Server 2016) 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 optional material and exercises on Analysis Services(SSAS) and Integration Services (SSIS) are also included. To include all the optional labs, the course may need to be taught in three-days instead of two.
Please contact your Learning Partner in order to take this course
Author: Neil R. Tucker

Course Duration: 2 Days

SATV: Yes

About This Course

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

If all the optional lab exercises are included, the class may need to be taught in three days instead of two.

Audience Profile

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.

At Course Completion

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