Microtek Learning Logo

55069: PowerShell for SQL Server Administrators Training

4.8
(4.8)

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.

  • Accredited By : Microsoft Partner Logo
  • Category : PowerShell

Course Price : $1150 Per Participant

Course Description

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.

 

Training Exclusives

  • Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
  • Access to Microsoft Official Courseware (MOC).
  • Real-time Virtual Lab Environment.
  • Experience 24*7 Learner Support.
  • Self-paced learning and flexible schedules.
Microsoft Course Microsoft Course
500+

Courses

experience experience
20+

Years of Experience

learners learners
95K+

Global Learners

What you will learn

  • green-tick Using PowerShell to Install and Configure components of SQL Server.
  • green-tick Manage the administration of SQL Server with PowerShell
  • green-tick 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.

Microsoft Learning Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

  • Dec 14, 2023
  • 9:00 am - 5:00 pm EST
  • online

Can’t Find The Batch You’re Looking For?

Request a Batch

Curriculum

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
  • Course Details

    • enroll enroll-green
      Enrolled: 1231
    • duration duration green
      Duration: 2 Days

    Talk to Learning Advisor