Providing Technology Training and Mentoring For Modern Technology Adoption
This course is intended for SQL administrators with little or basic knowledge of PowerShell. The course centers on SQL administrative tasks that are commonly used, and provides the basic understanding needed for administrators to utilize the expanding PowerShell SQL interoperations. The course concludes with a copy of course 752552 PowerShell 5.0 Basics.
After completing this course, students will be able to: Insert the course objectives in a bulleted list with periods. For example:
This course is intended for SQL Administrators and SQL Developers.
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lab : Course Overview
In this module, we will be discussing SQL Server Cmdlets and SQL Server Management Objects. In addition, we will look at modules and the process to install the SQLPS Module.
Lab : PowerShell and SQL
In this module, we will examine ways of retrieving information pertaining to the SQL Server instance installed, and look at ways of accomplishing many other management and administrative tasks that can be quickly and efficiently tackled with PowerShell.
Lab : SQL Administration with PowerShell
In this module, we will examine a handful of helpful cmdlets, discuss options for scheduling, and explore ways to track performance metrics.
Lab : Monitoring and Automation
In this module, we will examine ways of working with SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS). This module is not meant to be an exhaustive reference but instead is intended to give you a brief look at the capabilities built into the system and encourage you to further explore ways of managing your SQL Server environment using PowerShell.
Lab : SSAS, SSIS, AND SSRS
PowerShell is a scripting language, and an automation platform for Windows and Windows Server, which allows you to simplify and streamline the management of your systems. PowerShell utilizes the power of the .NET Framework, which provides rich objects and an extensive set of built-in functionality for taking control of your Windows environments.
Lab : Appendix: 752552 PowerShell 5.0 Basics