Course Length: 2 Days
Delivered: Virtually
OVERVIEW:
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. This course may earn a Credly Badge.
COURSE PREREQUISITES:
- 10961 Automating Administration with Windows PowerShell
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.
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.
TARGET 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.
COURSE OBJECTIVES:
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
COURSE CONTENT:
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 1: Configuring SQL Server with PowerShell
2 - 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
3 - 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
