Course Date | Start Time | End Time | Time Zone | Location | Days | Price | |
---|---|---|---|---|---|---|---|
Call for In Class or Live Virtual Dates | 2 | $1,495 USD | Purchase |
PowerShell for SQL Server Administrators
This instructor-led course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. You will learn how to manage day-to-day and scheduled maintenance tasks. The focus will be administration of the database engine, but optional material and exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included. The course may need to be taught in three days instead of two to include all the optional labs.
Duration: 2 Days
Prerequisites
- Experience working on Windows desktops or servers
- Experience working in a Windows domain environment
- Experience administering SQL Server Servers (1 year recommended)
- Fundamental experience with PowerShell (1 year recommended)
Audience
- SQL Server Administrators who work in a Windows network environment
Learning Objectives
- Install and configure SQL Server and all its components using PowerShell
- Configure SQL Server policy-based management review
- Manage day-to-day SQL Server administration with PowerShell
- Use PowerShell to Manage Database Availability (Using Clustering and AlwaysOn Availability Features)
- Maintain the SQL Server environment using PowerShell scripting and programming options
Topics
- Install and Configure SQL Server with PowerShell
- Administering SQL Servers with PowerShell
- Maintaining SQL Server with PowerShell