PowerShell for SQL Server Administrators (MS-55069)

Rating:
91% of 100
This two-day instructor-led course provides candidates with the knowledge and skills needed to use PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012.
Purchase Options
TypePriceDiscountsQty
Master Subscription
7-Day FREE Trial
Now Only $1,999.00 Regular Price $3,499.00
/ Year
Team Pricing
  • Buy 5-9 Enrollments And Save 5% ($1,899.00 ea.)
  • Buy 10-19 Enrollments And Save 10% ($1,799.00 ea.)
  • Buy 20-above Enrollments And Save 15% ($1,699.00 ea.)
Individual Course
On Sale!
Now Only $595.00 Regular Price $1,525.00
/ Seat
Team Pricing
  • Buy 5-9 Enrollments And Save 10% ($536.00 each.)
  • Buy 10-19 Enrollments And Save 15% ($506.00 each.)
  • Buy 20-above Enrollments And Save 20% ($476.00 each.)
This two-day instructor-led course provides candidates with the knowledge and skills needed to use PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012.

About this course:

This two-day instructor-led course provides candidates with the knowledge and skills needed to use PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012. Students will learn how to manage day-to-day and scheduled maintenance tasks. The main focus will be administration of the database engine, but optional material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.

The average salary for a SQL Server Database Administrator is $85,460 per year.

Course Objectives:

After completing this course, students will be able to:

  • Install and Configure SQL Server and all its components using PowerShell
  • Manage day-to-day SQL Server Administration with PowerShell
  • Maintain the SQL Server environment using PowerShell scripting and programming options

Audience:

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.

Prerequisites:

Before attending this course, students must have:

  • Experience working on Windows desktops or servers
  • Experience working in a Windows domain environment
  • Experience Administering SQL Server Servers

Suggested prerequisites courses:

More Information
BrandMicrosoft
Lab AccessYes
TechnologyMicrosoft
Learning StyleVirtual Classroom
DifficultyIntermediate
Course Duration2 Days
LanguageEnglish
SATV Value2 Days
VPA EligibleVPA Eligible
Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account
Sales Support

Sales (866) 991-3924

Mon-Fri. 8am-6pm CST

Have Questions? Ask Us.

Why QuickStart

Turn Training Into A Personalized Learning Experience


  • Problem Solving through ExpertConnect & Peer-To-Peer Learning
  • Find The Quickest Path To Learn With Career Paths
  • Access All Courses With Master Subscription
  • Manage Your Team With Learning Analytics
  • Virtual Classroom Training & Self-Paced Learning
  • Integrate With Your LMS Through API's