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

Objectivos
_ 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


Duração: 2 dias


Conteúdo Programático
Module 1: Install and Configure SQL Server with PowerShell
_ This module explains how to setup SQL Server components using PowerShell.
_ Lessons
_ Module Objectives
_ Lesson 1: Install SQL Server
_ Lesson 2: Configure Database Settings
_ Lesson 3: Configure SQL Server Settings
_ Lesson 4: Configure SQL Server Policy-Based Management
_ Review

Module 2: Administering SQL Servers with PowerShell
_ This module explains how to perform day-to-day administrative tasks on SQL Server Servers using PowerShell.
_ Lessons
_ Module Objectives
_ Lesson 1: Managing Users and Roles
_ Lesson 2: Managing Database Performance
_ Lesson 3: Managing Database Availability
_ Lesson 4: Managing SQL Server Features
_ Review


Module 3: Maintaining SQL Server with PowerShell
_ This module explains how to perform maintenance tasks on SQL Servers using PowerShell.
_ Lessons
_ Module Objectives
_ Managing Backups and Restores
_ Maintaining Database Integrity and Performance
_ Monitoring and Auditing
_ Task Automation
_ Generating Reports
_ Review

Requisitos
_ 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

Solicite mais informação

Inscreva-se neste curso