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

• 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

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.

• 1. Install and Configure SQL Server with PowerShell

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
View Less    View More   
2. Administering SQL Servers with PowerShell
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)
3. Maintaining SQL Server with PowerShell
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