55069 PowerShell for SQL Server Administrators
CLASS DATE(s):
6/4/2020 - 6/5/2020
8/6/2020 - 8/7/2020

COURSE LENGTH: 2 Days

COURSE COST: $995.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

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.

AUDIENCE AND PREREQUISITES

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.

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

 

vendor course description

*Course Cost listed does not include the cost of courseware or lunch, required in your registration. Please refer to your Enrollment Sales Order or Invoice for the additional cost. If you have any questions, please contact us (learn@vtec.org or 207-775-0244). Course subject to minimum enrollment.

COURSE TOPICS:


Module 1: Install and Configure SQL Server with PowerShell
Install SQL Server
Configure Database Settings
Configure SQL Server Settings
Configure SQL Server Policy-Based Management
Lab : Configuring SQL Server with PowerShell

Module 2: Administering SQL Servers with PowerShell
Managing Users and Roles
Managing Database Performance
Managing Database Availability
Managing SQL Server Features
Lab : Administering SQL Servers with PowerShell

Module 3: Maintaining SQL Server with PowerShell
Managing Backups and Restores
Maintaining Database Integrity and Performance
Monitoring and Auditing
Task Automation
Generating Reports
Lab : Maintaining SQL Servers with PowerShell