Description
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.
Outline
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
Prerequisites
There is no prerequisite