651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

PowerShell for SQL Server Administrators (55069)

2 Days

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.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a PowerShell for SQL Server Administrators (55069) class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

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

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a PowerShell for SQL Server Administrators (55069) class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

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

 

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a PowerShell for SQL Server Administrators (55069) class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date