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.
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.
Course 55069A: 2 Days; Instructor led classes via virtual delivery.
Duration: 2 Day
Price: $1,118.00
Course 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 |
Prerequisites
Before attending this course, students must have:
Course Outline
Module 1: Install and Configure SQL Server with PowerShell
This module explains how to setup SQL Server components using PowerShell.
Lessons
Lab : Configuring SQL Server with PowerShell
After completing this module, students will be able to:
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
Lab : Administering SQL Servers with PowerShell
After completing this module, students will be able to:
Module 3: Maintaining SQL Server with PowerShell
This module explains how to perform maintenance tasks on SQL Servers using PowerShell.
Lessons
Lab : Maintaining SQL Servers with PowerShell
After completing this module, students will be able to:
or
The Vancouver Island Works Project acknowledges that our members, live, play and do business on the Traditional Territory of the Lək̓ʷəŋən speaking peoples. It recognizes the First Nations governments across this region — Lək̓ʷəŋən (Songhees) and Xwsepsum (Esquimalt) Nations in the core area, the W̱SÁNEĆ Nations {W̱JOȽEȽP (Tsartlip), BOḰEĆEN (Pauquachin), SȾÁUTW̱,(Tsawout) W̱SIKEM (Tseycum)} out on the Saanich Peninsula and Gulf Islands, to the west Sc’ianew (Beecher Bay), T’Sou-ke, and Pacheedaht, and MÁLEXEȽ (Malahat) and Pune’laxutth’ (Penelekut) Nations.
As the world continues to shift towards remote work, more and more Canadians are finding themselves working from home or other remote locations. While
