- 1. Install and Configure SQL Server with PowerShell
This module explains how to setup SQL Server components using PowerShell.
- Install SQL Server
- Configure Database Settings
- Configure SQL Server Settings
- Configure SQL Server Policy-Based Management
- Review
Lab: Install and Configure SQL Server with PowerShell
- Install SQL Server
- Configure Database Settings
- Configure SQL Server Settings
- Configure SQL Server Policy-Based Management
After completing this module, students will be able to:
- Use PowerShell to Install SQL Server Instances
- Use PowerShell to Add/Remove components to an existing instance (SSRS, SSIS, SSAS, Tools, etc.)
- Use PowerShell to configure SQL Server and Database Settings
- Use PowerShell to configure SQL Server Policy-Based Management
- 2. Administering SQL Servers with PowerShell
This module explains how to perform day-to-day administrative tasks on SQL Server Instances using PowerShell.
- Managing Users and Roles
- Managing Database Performance
- Managing Database Availability
- Managing SQL Server Features
- Review
Lab: Administering SQL Servers with PowerShell
- Managing Users and Roles
- Managing Database Performance
- Managing Database Availability
- Managing SQL Server Features
After completing this module, students will be able to:
- Use PowerShell to Manage Users and Roles
- Use PowerShell to Manage Database Performance
- Use PowerShell to Manage Database Availability (Using Clustering and AlwaysOn Availability Features)
- Use PowerShell to Manage Integration Services (SSIS) and Analysis Services (SSAS)
- 3. Maintaining SQL Server with PowerShell
This module explains how to perform maintenance tasks on SQL Server Instances using PowerShell.
- Managing Backups and Restores
- Maintaining Database Integrity and Performance
- Monitoring and Auditing
- Task Automation
- Generating Reports
- Review
Lab: Maintaining SQL Server with PowerShell
- Managing Backups and Restores
- Maintaining Database Integrity and Performance
- Monitoring and Auditing
- Task Automation
- Generating Reports
After completing this module, students will be able to:
- Use PowerShell to Manage SQL Server Backups and Restores
- Use PowerShell to Maintain Database Integrity and Performance (Using DBCC and other tools)
- Use PowerShell to Monitor and Audit changes to a SQL Server Instance
- Use PowerShell for Task Automation on SQL Server
- Use PowerShell to Generate SQL Server Reports
United States 
Share With Your Friends!
Twitter
LinkedIn