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
Intended 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
Other Trainings
SQL Server
22 Training Set
