The course focuses on commonly used SQL administrative tasks and provides core understanding required for admins to utilize the ever-growing PowerShell SQL interoperations.
Course Price : $575 Per Participant
The course provided by Microtek Learning is meant for SQL admin's basic PowerShell knowledge.
The course focuses on commonly used SQL administrative tasks and provides the core understanding required for admins to utilize the ever-growing PowerShell SQL interoperations.
This training is designed based on the objectives of the course variant 55207A.
Microsoft Courses
Years of Experience
Global Learners
This course is intended for SQL Administrators and SQL Developers.
Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lab: Course Overview
After completing this module, students will be able to:
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
After completing this module, students will be able to:
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
After completing this module, students will be able to:
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
After completing this module, students will be able to:
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.