Course code Title Language Price # Unit Startdate Hour Enddate Location Signup
MS55069 PowerShell for SQL Server Administrators English €850.00 2 Day(s) 04-09-2017 09u00 05-09-2017 Kontich Subscribe
MS55069 PowerShell for SQL Server Administrators on your request on your request Contact Us

PowerShell for SQL Server Administrators

PowerShell for SQL Server Administrators

Overview

Course code: 
MS55069
Duration: 
2
Time Unit: 
Day(s)
Overview: 

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.

Topics

Topics: 

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

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

After completing this module, students will be able to:
• Install SQL Server
• Add/Remove components to an existing instance (SSRS, SSIS, SSAS, etc.)
• Configure SQL Server and Database Settings
• Configure SQL Server Policy-Based Management

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

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

After completing this module, students will be able to:
• Manage Users and Roles
• Manage Database Performance
• Manage Database Availability with Clustering & AlwaysOn Availability Groups
• Manage Integration Services and Analysis Services

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

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

After completing this module, students will be able to:
• Manage SQL Server Backups and Restores
• Maintain Database Integrity and Performance
• Monitor and Audit changes to a SQL Server
• Task Automation on SQL Server
• Generate SQL Server Reports

Prerequisites

Prerequisites: 

• 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