16 Corporate Woods Boulevard | Albany, New York 12211 | Tel: 518.437.1600

#55069: PowerShell for SQL Server Administrators

Available Dates: Call for Availability
Class Length: 2 day
Cost: $1,195

Class Outline:

Description:
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.

Course Outline:

Module 1: Install and Configure SQL Server with PowerShell
This module explains how to setup SQL Server components using PowerShell.

Lessons
• Module Objectives
• Lesson 1: Install SQL Server
• Lesson 2: Configure Database Settings
• Lesson 3: Configure SQL Server Settings
• Lesson 4: Configure SQL Server Policy-Based Management
• Review

Module 2: Administering SQL Servers with PowerShell
This module explains how to perform day-to-day administrative tasks on SQL Server Servers using PowerShell.

Lessons
• Module Objectives
• Lesson 1: Managing Users and Roles
• Lesson 2: Managing Database Performance
• Lesson 3: Managing Database Availability
• Lesson 4: Managing SQL Server Features
• Review

Module 3: Maintaining SQL Server with PowerShell
This module explains how to perform maintenance tasks on SQL Servers using PowerShell.

Lessons
• Module Objectives
• Managing Backups and Restores
• Maintaining Database Integrity and Performance
• Monitoring and Auditing
• Task Automation
• Generating Reports
• Review