PowerShell for SQL Server Administrators

This two-day PowerShell for SQL Server Administrators training class 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. The main focus will be administration of the database engine, but material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.

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.

Goals
  1. Learn to install and Configure SQL Server and all its components using PowerShell.
  2. Learn to manage day-to-day SQL Server Administration with PowerShell.
  3. Learn to maintain the SQL Server environment using PowerShell scripting and programming options.
Outline
  1. Install and Configure SQL Server with PowerShell
    1. Module Objectives
    2. Install SQL Server
    3. Configure Database Settings
    4. Configure SQL Server Settings
    5. Configure SQL Server Policy-Based Management
    6. Review
    7. Lab: Configuring SQL Server with PowerShell
  2. Administering SQL Servers with PowerShell
    1. Module Objectives
    2. Managing Users and Roles
    3. Managing Database Performance
    4. Managing Database Availability
    5. Managing SQL Server Features
    6. Review
    7. Lab: Administering SQL Servers with PowerShell
  3. Maintaining SQL Server with PowerShell
    1. Module Objectives
    2. Managing Backups and Restores
    3. Maintaining Database Integrity and Performance
    4. Monitoring and Auditing
    5. Task Automation
    6. Generating Reports
    7. Review
    8. Lab: Maintaining SQL Servers with PowerShell
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this SQL Server class:

  • 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.
Prerequisite Courses

Courses that can help you meet these prerequisites:

Preparing for Class

Training for your Team

Length: 2 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

This was easy to follow. Our instructor was super knowledgeable and, most importantly, very patient!
Annie Baker
Lube-Tech
I liked the instructor. I liked the book. I liked the way the instructor and the facilitator ensured that my PC and I were both 100% ready to take an online class far in advance of it starting. I liked the many reminders to check in on the website to do all the software and hardware prep work. It was all managed very well!
Jessica Short
City of San Jose
The virtual classroom, materials, instruction and information provided by Webucator were all delivered in an excellent, professional manner. I would highly recommend Webucator for anyone needing this type of training.
Paul Larson
Eaton Corp
At the end of the course I felt as if I could immediately use the knowledge gained in a real world application and be successful.
Roseann Tracy
RJT Advantage, LLC

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

60,501

Students who have taken Instructor-led Training

11,679

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.28

Students rated our trainers 9.28 out of 10 based on 28,422 reviews

Contact Us or call 1-877-932-8228