PowerShell for SQL Server Administrators

This two-day PowerShell for SQL Server Administrators training class provides students 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.

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.

Delegates will learn how 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.


Install and Configure SQL Server with PowerShell 

·       Module Objectives

·       Install SQL Server

·       Configure Database Settings

·       Configure SQL Server Settings

·       Configure SQL Server Policy-Based Management


Administering SQL Servers with PowerShell 

·       Module Objectives

·       Managing Users and Roles

·       Managing Database Performance

·       Managing Database Availability

·       Managing SQL Server Features


Maintaining SQL Server with PowerShell 

·       Module Objectives

·       Managing Backups and Restores

·       Maintaining Database Integrity and Performance

·       Monitoring and Auditing

·       Task Automation


·       Generating Reports



Program Details
Duration 2 Days
Capacity Max 12 Persons
Training Type Classroom / Virtual Classroom


Can't find what you're looking for? Let us know if you have a query or cannot find what you are looking for.

Contact