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. This course may earn a Credly Badge.

starstarstarstarstar_outline

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning 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

1
  • 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


2
  • 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


3
  • 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


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.

Language

English

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; Fundamental experience with PowerShell

$1,190

Length: 2.0 days (16 hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...