VTEC Training
Course Code: 1312
55069 PowerShell for SQL Server Administrators
VTEC Training
Portland,
ME
Class Dates:
8/24/2023
Length:
2 Days
Cost:
$1090.00
Class Time:
Technology:
Database
Delivery:
Instructor-Led Training, Virtual Instructor-Led Training
Overview
- Course Overview
- This two-day instructor-led 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. The main focus will be administration of the database engine, but material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.
- Audience
- 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.
Prerequisites
- Before attending this course, students must have:
- Experience working on Windows desktops or servers
- Experience working in a Windows domain environment
- Experience Administering SQL Server Servers
- Fundamental experience with PowerShell or Course 10961B – Automating Administration with Windows PowerShell
Course Details
- Module 1: Install and Configure SQL Server with PowerShell
- Install SQL Server
- Configure Database Settings
- Configure SQL Server Settings
- Configure SQL Server Policy-Based Management
- Lab : Configuring SQL Server with PowerShell
- Module 2: Administering SQL Servers with PowerShell
- Managing Users and Roles
- Managing Database Performance
- Managing Database Availability
- Managing SQL Server Features
- Lab : Administering SQL Servers with PowerShell
- Module 3: Maintaining SQL Server with PowerShell
- Managing Backups and Restores
- Maintaining Database Integrity and Performance
- Monitoring and Auditing
- Task Automation
- Generating Reports
- Lab : Maintaining SQL Servers with PowerShell