Description

NOTE: This course is only available by customer request. If you are interested in taking this course, please call 651-905-3729 or submit a request for a date.

This 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.

Who Should Attend

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.

Course Overview

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 1: Configuring SQL Server with PowerShell

2 - ADMINISTERING SQL SERVERS WITH POWERSHELL

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

3 - MAINTAINING SQL SERVER WITH POWERSHELL

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

Prerequisites

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

PowerShell for SQL Server Administrators (55069) Classroom Live Eagan, MN September 09, 2021

Price: $950

Enroll today to reserve your spot!

Description

Who Should Attend

Course Overview

Prerequisites

Find a Course

Corporate Services

Contact us