Knowledge Transfer Microsoft Certified Training Partner CTEC
Knowledge Transfer is a Microsoft Certified Gold Partner
Microsoft Certified Gold Training Partner
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
 
 Main Menu
 
Home
View Courses
Site Index
 
 


PowerShell for SQL Server Administrators - Course 55069 Overview



  • 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: Install and Configure 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:

      • Use PowerShell to Install SQL Server Instances

      • Use PowerShell to Add/Remove components to an existing instance (SSRS, SSIS, SSAS, Tools, etc.)

      • Use PowerShell to configure SQL Server and Database Settings

      • Use PowerShell to 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 Instances 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:

      • Use PowerShell to Manage Users and Roles

      • Use PowerShell to Manage Database Performance

      • Use PowerShell to Manage Database Availability (Using Clustering and AlwaysOn Availability Features)

      • Use PowerShell to Manage Integration Services (SSIS) and Analysis Services (SSAS)





  • Module 3: Maintaining SQL Server with PowerShell

  • This module explains how to perform maintenance tasks on SQL Server Instances 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 Server 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:

      • Use PowerShell to Manage SQL Server Backups and Restores

      • Use PowerShell to Maintain Database Integrity and Performance (Using DBCC and other tools)

      • Use PowerShell to Monitor and Audit changes to a SQL Server Instance

      • Use PowerShell for Task Automation on SQL Server

      • Use PowerShell to Generate SQL Server Reports






 

View Printer Friendly Page

Course Schedule
  Start Date  City  Price  
 8/28/2017
 $950
Enroll
 8/28/2017
 $950
Enroll
 10/2/2017
 $950
Enroll
 10/2/2017
 $950
Enroll
 11/6/2017
 $950
Enroll
 12/11/2017
 $950
Enroll
 12/11/2017
 $950
Enroll

To Inquire About Future Classes

Request a class date

if one is not scheduled.