Booking options
Price on Enquiry
Price on Enquiry
Delivered Online
Two days
All levels
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
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....