Dynamics 365
Power BI & Apps
Azure
Microsoft 365 (Office)
Cyber Security
Government Solutions
Solutions

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

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

Price:

Duration:
2 days

    Print

    202 S.E. Church Street, Suite 203 Leesburg, VA 20175
    800-453-5961 (Toll Free)
    202-410-6400
    https://www.dynamicsedge.com/
    sales@dynamicsedge.com
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram