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

Course : 70014

70014 PowerShell For SQL Server Administrators (2 days)

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.

[printfriendly]

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

SQL Server Administrators Powershell (2 days) 70014

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 and 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

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

Administering SQL Servers with PowerShell

  • Managing Users and Roles
  • Database Performance
  • Database Availability
  • and 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

Need help picking the right course?

Give us a call!

408-684-5250 or
800-453-596 (Toll Free)

Train Your Team

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!

Register Now

Duration: 2 days

This product is currently out of stock and unavailable.