Microsoft/55069-A: PowerShell for SQL Server Administrators

55069-A: PowerShell for SQL Server Administrators Certification Training Course Overview

Enroll for 2-day 55069-A: PowerShell for SQL Server Administrators training course from Koenig Solutions accredited by Microsoft.  In this course you will learn about PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012. Students will learn how to manage day-to-day and scheduled maintenance tasks.

Through a blend of hands-on labs and interactive lectures you will learn administration of the database engine, but optional material & exercises on Analysis Services (SSAS) and Integration Services (SSIS).

Target Audience:

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.

Learning Objectives:

After completing this course, you 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

 

 

55069-A: PowerShell for SQL Server Administrators (16 Hours) Download Course Contents

Live Virtual Classroom Fee For Both Group Training & 1-on-1 Training On Request
Group Training
08 - 09 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 07 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: 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
  • Review
  • Configuring SQL Server with PowerShell
Module 2: Administering SQL Servers with PowerShell
  • Module Objectives
  • Managing Users and Roles
  • Managing Database Performance
  • Managing Database Availability
  • Managing SQL Server Features
  • Review
  • Administering SQL Servers with PowerShell
Module 3: Maintaining SQL Server with PowerShell
  • Module Objectives
  • Managing Backups and Restores
  • Maintaining Database Integrity and Performance
  • Monitoring and Auditing
  • Task Automation
  • Generating Reports
  • Review
  • Maintaining SQL Servers with PowerShell
Download Course Contents

Request More Information

Course 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 10961C- Automating Administration with Windows PowerShell