PowerShell For SQL Server Administrators (2 days)

Note: For additional questions and clarification, you may reach Bill Ramirez at bill@dynamicsedge.com or on his following contact details: Office- (510) 804-3600 & Cell- (415) 200-6969

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
• Experience working in a 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

• Install SQL Server
• Configure Database Settings
• Configure SQL Server Settings
• Configure SQL Server Policy-Based Management

Administering SQL Servers with PowerShell

• Managing Users and Roles
• Managing Database Performance
• Managing Database Availability
• 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