PowerShell for SQL Server Administrators

MS55069
2 nap
149 000 Ft + ÁFA
tanfolyamkezdési időpontok:
Jelentkezem!
oktatók:

A tanfolyam célja

This two-day instructor-led course provides candidates with the knowledge and skills needed to use 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. The main focus will be administration of the database engine, but optional material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.

If all the optional lab exercises are included, the class may need to be taught in three days instead of two.
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.

Level: Intermediate
This Revision: A
First published: 16 June 2014

Tematika

  • Module 1: Install and Configure SQL Server with PowerShell
    • Install SQL Server
    • Configure Database Settings
    • Configure SQL Server Settings
    • Configure SQL Server Policy-Based Management
  • Module 2: Administering SQL Servers with PowerShell
    • Managing Users and Roles
    • Managing Database Performance
    • Managing Database Availability
    • Managing SQL Server Features
  • Module 3: Maintaining SQL Server with PowerShell
    • Managing Backups and Restores
    • Maintaining Database Integrity and Performance
    • Monitoring and Auditing
    • Task Automation
    • Generating Reports

Kinek ajánljuk

Előfeltételek

Before attending this course, students must have:

  • 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

Kapcsolódó tanfolyamok



Ajánlja másoknak is!