7014 PowerShell For SQL Server Administrators (2 days)

Course: 7014

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.

Download PDF
  • Duration: 2 days
  • Price: $1,490.00
Get This Course $1,490.00
October 10 - 11

9:00 AM – 4:00 PM CST

November 14 - 15

9:00 AM – 4:00 PM CST

December 12 - 13

9:00 AM – 4:00 PM CST

Scroll to view additional course dates

Reserve Your Seat

  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • You can use your Purchase Card and checkout
  • The GSA Contract Number: 47QTCA20D000D
  • Call 800-453-5961 for details
  • Customize your class
  • Delivery Onsite or Online for your organization
  • Choice of Dates when and where you want
  • Guidance in choosing and customizing your class

Question About this Course?

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.

SQL Server Administrators Powershell (2 days) 70014

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

Question About this Course?

Need help picking the right course?

Contact Us

Call Now

Call Now800-453-5961