• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

55069 PowerShell for SQL Server Administrators

55069 PowerShell for SQL Server Administrators

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • Delivered Online

  • Two days

  • All levels

Description

Duration

2 Days

12 CPD hours

This course is intended for

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.

Overview

After completing this course, students will be able to:
•Install and Configure SQL Server and all its components using PowerShell
•Manage day-to-day SQL Server Administration with PowerShell
•Maintain the SQL Server environment using PowerShell scripting and programming options

This course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks.

Install and Configure SQL Server with PowerShell

  • Install SQL Server

  • Configure Database Settings

  • Configure SQL Server Settings

  • Configure SQL Server Policy-Based Management

  • Lab 1: Configuring SQL Server with PowerShell

Administering SQL Servers with PowerShell

  • Managing Users and Roles

  • Managing Database Performance

  • Managing Database Availability

  • Managing SQL Server Features

  • Lab 1: Administering SQL Servers with PowerShell

Maintaining SQL Server with PowerShell

  • Managing Backups and Restores

  • Maintaining Database Integrity and Performance

  • Monitoring and Auditing

  • Task Automation

  • Generating Reports

  • Lab 1: Maintaining SQL Servers with PowerShell

About The Provider

Nexus Human, established over 20 years ago, stands as a pillar of excellence in the realm of IT and Business Skills Training and education in Ireland and the UK....

Read more about Nexus Human

Tags

Reviews