PowerShell for SQL Server Administrators

Course Number: 55069

Length: 2 days

Certification: Included

Price: $850.00

Course Overview

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.

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

•To help you prepare for this class, review the following resources: Classroom Training: Course 10775A – Administering Microsoft SQL Server 2012 Databases

At Course Completion:

•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

Back