PowerShell for SQL Server Administrators

Learn via : Virtual Classroom / Online
Duration : 2 Days
  1. Home
  2. PowerShell for SQL Server Administrators

Description

    This two-day PowerShell for SQL Server Administrators training class provides students 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.

     

    Delegates will learn how 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.

Outline

Install and Configure SQL Server with PowerShell

  • Module Objectives
  • Install SQL Server
  • Configure Database Settings
  • Configure SQL Server Settings
  • Configure SQL Server Policy-Based Management

Administering SQL Servers with PowerShell

  • Module Objectives
  • Managing Users and Roles
  • Managing Database Performance
  • Managing Database Availability
  • Managing SQL Server Features

Maintaining SQL Server with PowerShell

  • Module Objectives
  • Managing Backups and Restores
  • Maintaining Database Integrity and Performance
  • Monitoring and Auditing
  • Task Automation
  • Generating Reports

Prerequisites

There is no prerequisite