18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
100 Queen St W, Brampton, ON L6X 1A4, Canada
United States
share button
Free Webinar: Database Recovery Models And Its Significance : July 29, 2020. 

55069: PowerShell for SQL Server Administrators Training


What 55069: PowerShell for SQL Server Administrators training is all about?

This course guides learners on how to use PowerShell and SMO features to administer SQL Server. Students learn to maintain daily and scheduled maintenance works. The key focus is kept on Database Engine administration however, SSAS (Analysis Services) and SSIS (Integration Services) related exercises are also covered in the course.

2 SATVs applicable


  • START DATE
  • CLASS TIMINGS
  • DELIVERY MODE
  • PRICE
  • ACTION
  • 08/17/2020
  • 9:00 am - 5:00 pm EST
  • $ 1150
  • 09/14/2020
  • 9:00 am - 5:00 pm EST
  • $ 1150
  • 10/15/2020
  • 9:00 am - 5:00 pm EST
  • $ 1150
  • 11/16/2020
  • 9:00 am - 5:00 pm EST
  • $ 1150
What are the course objectives for 55069: PowerShell for SQL Server Administrators training?
  • Using PowerShell to Install and Configure components of SQL Server.
  • Manage the administration of SQL Server with PowerShell
  • Using PowerShell programming and scripting options to maintain SQL Server environment
Who should attend 55069: PowerShell for SQL Server Administrators training?

The course is meant for SQL server admins working with Windows Network. The ideal candidate must have some real-world experience with SQL server administration using PowerShell.

What is the course outline for 55069: PowerShell for SQL Server Administrators training?
  • 1. Install and Configure SQL Server with PowerShell
  • a). Install SQL Server
  • b). Configure Database Settings
  • c). Configure SQL Server Settings
  • d). Configure SQL Server Policy-Based Management
  • e). Lab: Install and Configure SQL Server with PowerShell
  • 2. Administering SQL Servers with PowerShell
  • a). Managing Users and Roles
  • b). Managing Database Performance
  • c). Managing Database Availability
  • d). Managing SQL Server Features
  • e). Lab: Administering SQL Servers with PowerShell
  • 3. Maintaining SQL Server with PowerShell
  • a). Module Objectives
  • b). Managing Backups and Restores
  • c). Maintaining Database Integrity and Performance
  • d). Monitoring and Auditing
  • e). Task Automation
  • f). Generating Reports
  • g). Lab: Maintaining SQL Server with PowerShell