55069: PowerShell for SQL Server Administrators Training

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.

📘 PowerShell 👥 1231 Enrolled ⏱️ 2 Days 💼 Level ⭐ 4.8 | 113 Reviews

Why Microtek Learning?

500+

Courses

10+ Years

Experience

95K+

Global Learners

Virtual Instructor-Led Training

$1322

📄 Download PDF

Course Overview

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.

This training is designed based on the objectives of the course variant 55069A.

Mode of Training

🏫 Classroom 💻 Live Online 🧪 Blended 👨‍👩‍👧‍👦 Private Group

Upcoming Schedules

Start Date	Time	Duration	Mode	Price
Nov 13, 2025	9:00 am - 5:00 pm EST	2 Days	online	$1322	GTR
Nov 24, 2025	9:00 am - 5:00 pm EST	2 Days	online	$1322	GTR
Dec 11, 2025	9:00 am - 5:00 pm EST	2 Days	online	$1322	GTR

+ View more schedules

What you will learn

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 This Course?

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.

📞 Talk to a Learning Advisor

📘 55069: PowerShell for SQL Server Administrators Outline

This module explains how to setup SQL Server components using PowerShell.

Install SQL Server
Configure Database Settings
Configure SQL Server Settings
Configure SQL Server Policy-Based Management
Review

Lab: Install and Configure SQL Server with PowerShell

Install SQL Server
Configure Database Settings
Configure SQL Server Settings
Configure SQL Server Policy-Based Management

After completing this module, students will be able to:

Use PowerShell to Install SQL Server Instances
Use PowerShell to Add/Remove components to an existing instance (SSRS, SSIS, SSAS, Tools, etc.)
Use PowerShell to configure SQL Server and Database Settings
Use PowerShell to configure SQL Server Policy-Based Management

This module explains how to perform day-to-day administrative tasks on SQL Server Instances using PowerShell.

Managing Users and Roles
Managing Database Performance
Managing Database Availability
Managing SQL Server Features
Review

Lab: Administering SQL Servers with PowerShell

Managing Users and Roles
Managing Database Performance
Managing Database Availability
Managing SQL Server Features

After completing this module, students will be able to:

Use PowerShell to Manage Users and Roles
Use PowerShell to Manage Database Performance
Use PowerShell to Manage Database Availability (Using Clustering and AlwaysOn Availability Features)
Use PowerShell to Manage Integration Services (SSIS) and Analysis Services (SSAS)

This module explains how to perform maintenance tasks on SQL Server Instances using PowerShell.

Managing Backups and Restores
Maintaining Database Integrity and Performance
Monitoring and Auditing
Task Automation
Generating Reports
Review

Lab: Maintaining SQL Server with PowerShell

Managing Backups and Restores
Maintaining Database Integrity and Performance
Monitoring and Auditing
Task Automation
Generating Reports

After completing this module, students will be able to:

Use PowerShell to Manage SQL Server Backups and Restores
Use PowerShell to Maintain Database Integrity and Performance (Using DBCC and other tools)
Use PowerShell to Monitor and Audit changes to a SQL Server Instance
Use PowerShell for Task Automation on SQL Server
Use PowerShell to Generate SQL Server Reports