MS55069 PowerShell for SQL Server Administrators

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.

Šta dobijate?

  • Video snimak predavanja u periodu od 180 dana posle kraja Vaše obuke
  • Jednostavan pristup laboratorijama dostupne putem Interneta
  • Pristup laboratorijama u periodu od 180 dana od početka Vaše obuke
  • Materijal u elektronskom obliku koji se automatski ažurira
  • Zvaničan Microsoft sertifikat o pohađanju kursa
  • Besplatno pohađanje iste obuke na potvrđenim terminima u sledećih 365 dana
  • Vaučer za ispit po povoljnoj ceni

Trajanje: 2 dana/ 16 časova

Cena: 190 €

Ovaj kurs možete pohađati online(?)    

Poželjno predznanje: 
  • 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 MS10961 – Automating Administration with Windows PowerShell

Sledeći polasci:

Beograd
03.05.2017
Virtuelna učionica
03.05.2017
Plan obuke : 

Module 1: Install and Configure SQL Server with PowerShell

This module explains how to setup SQL Server components using PowerShell.

  • 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.

  • 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.

  • Module Objectives
  • Managing Backups and Restores
  • Maintaining Database Integrity and Performance
  • Monitoring and Auditing
  • Task Automation
  • Generating Reports
  • Review