70014 PowerShell For SQL Server Administrators (2 days) - Dynamics Edge
Course 70014

70014 PowerShell For SQL Server Administrators (2 days)


To customize this class, call 800-453-5961 or click here to contact us

Note: For additional questions and clarification, you may reach Bill Ramirez at bill@dynamicsedge.com or on his following contact details: Office- (510) 804-3600 & Cell- (415) 200-6969

COURSE OVERVIEW:

This Microsoft course, PowerShell for SQL Server Administrators, teaches students to use PowerShell for SQL Server administration and how to manage day-to-day and scheduled maintenance tasks. You will learn to: Install and Configure SQL Server and all its components using PowerShell; Manage day-to-day SQL Server Administration with PowerShell; and Maintain the SQL Server environment using PowerShell scripting and programming options.

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 MOC Course 10961B – Automating Administration with Windows PowerShell

AGENDA TOPICS:

Install and Configure SQL Server with PowerShell

  • Install SQL Server
  • Configure Database Settings
  • Configure SQL Server Settings
  • Configure SQL Server Policy-Based Management

Administering SQL Servers with PowerShell

  • Managing Users and Roles
  • Managing Database Performance
  • Managing Database Availability
  • Managing SQL Server Features

Maintaining SQL Server with PowerShell

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

We look forward to your great success!!!

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!

Request Group Quote

Register


Price: $1275   Duration: 2 days

- EST