Providing Technology Training and Mentoring For Modern Technology Adoption
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.
After completing this course, students will be able to:
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.
Before attending this course, students must have:
This module explains how to setup SQL Server components using PowerShell.
Lab : Configuring SQL Server with PowerShell
After completing this module, students will be able to:
This module explains how to perform day-to-day administrative tasks on SQL Server Servers using PowerShell.
Lab : Administering SQL Servers with PowerShell
This module explains how to perform maintenance tasks on SQL Servers using PowerShell.
Lab : Maintaining SQL Servers with PowerShell