MOC 55069 A PowerShell for SQL Server Administrators

Summary

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.

Prerequisites

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

Duration

2 Days/Lecture & Lab

Audience

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

Topics

• Install and Configure SQL Server with PowerShell
• Administering SQL Servers with PowerShell
• Maintaining SQL Server with PowerShell

Related Scheduled Courses