55069 PowerShell for SQL Server Administrators

Displaying courses for United States [Change]

Overview

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

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.

Syllabus

Install and Configure SQL Server with PowerShell

  • Install SQL Server
  • Configure Database Settings
  • Configure SQL Server Settings
  • Configure SQL Server Policy-Based Management
  • Lab 1: Configuring SQL Server with PowerShell

Administering SQL Servers with PowerShell

  • Managing Users and Roles
  • Managing Database Performance
  • Managing Database Availability
  • Managing SQL Server Features
  • Lab 1: Administering SQL Servers with PowerShell

Maintaining SQL Server with PowerShell

  • Managing Backups and Restores
  • Maintaining Database Integrity and Performance
  • Monitoring and Auditing
  • Task Automation
  • Generating Reports
  • Lab 1: Maintaining SQL Servers with PowerShell

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 2 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Windows PowerShell
United States
This skill has an average salary of
US$99,138
and is mentioned in
0.76%
of job ads in this area.
Microsoft SQL Server
United States
This skill has an average salary of
US$96,551
and is mentioned in
2.01%
of job ads in this area.
Database
United States
This skill has an average salary of
US$76,746
and is mentioned in
14.10%
of job ads in this area.
SQL
United States
This skill has an average salary of
US$93,476
and is mentioned in
7.30%
of job ads in this area.