Microtek Learning Logo

55207: PowerShell for SQL Administration Training

4.7
(4.7)

The course focuses on commonly used SQL administrative tasks and provides core understanding required for admins to utilize the ever-growing PowerShell SQL interoperations.

  • Accredited By : Microsoft Partner Logo
  • Category : PowerShell

Course Price : $575 Per Participant

Course Description

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.

 

Training Exclusives

  • Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
  • Access to Microsoft Official Courseware (MOC).
  • Real-time Virtual Lab Environment.
  • Experience 24*7 Learner Support.
  • Self-paced learning and flexible schedules.
Microsoft Course Microsoft Course
500+

Courses

experience experience
20+

Years of Experience

learners learners
95K+

Global Learners

What you will learn

  • green-tick Examining and installing modules.
  • green-tick Understanding SQL SMO.
  • green-tick Understanding recent updates.
  • green-tick Understanding and creating logins.
  • green-tick Retrieving instance information on SQL Server.
  • green-tick Examining and understanding of SQL Server Cmdlets.
  • green-tick Understanding addition of files and filegroups.
  • green-tick Understanding the process of detaching and attaching databases.
  • green-tick Understanding the process of backup and restore databases.
  • green-tick Understanding the process to reorganize/rebuild indexes.
  • green-tick Exploring available cmdlets.
  • green-tick Understanding scheduling options.
  • green-tick Understanding performance metrics tracking options.
  • green-tick Understanding and utilizing SSAS.
  • green-tick Understanding and utilizing SSIS.
  • green-tick Understanding and utilizing SSRS.
  • green-tick Understanding PowerShell's evolution.
  • green-tick Understanding and utilizing PowerShell environment.
  • green-tick Understanding and utilizing the important Help System.
  • green-tick Understanding and utilizing PowerShell.
  • green-tick Understanding and utilizing the file system to work.
  • green-tick Understanding and utilizing parameters.
  • green-tick Understanding and utilizing user-defined variables.
  • green-tick Understanding and utilizing arrays.
  • green-tick Understanding and utilizing hash tables.
  • green-tick Understanding and executing cmdlets.
  • green-tick Understanding and utilizing the pipeline.
  • green-tick Understanding output control with formatting.
  • green-tick Understanding background jobs.
  • green-tick Understanding aliases.
  • green-tick Understanding and utilizing loops.
  • green-tick Understanding and utilizing While loops.
  • green-tick Understanding and utilizing Do While loops.
  • green-tick Understanding and utilizing Do Until loops.
  • green-tick Understanding and utilizing For loops.
  • green-tick Understanding and utilizing For Each loop.
  • green-tick Understanding altering loop execution.
  • green-tick Understanding and utilizing scripting.
  • green-tick Understanding functions and filters.
  • green-tick Understanding script design basics.
  • green-tick Understanding scripting pitfalls.

Who should attend this course?

This course is intended for SQL Administrators and SQL Developers.

Microsoft Learning PartnerMicrosoft Learning Partner

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).

Schedules

  • calendar May 03, 2024
  • time 9:00 am - 5:00 pm EST
  • location online
GTR
  • calendar May 17, 2024
  • time 9:00 am - 5:00 pm EST
  • location online
  • calendar May 31, 2024
  • time 9:00 am - 5:00 pm EST
  • location online

Can’t Find The Batch You’re Looking For?

Request a Batch

Curriculum

This module explains how the class will be structured and introduces course materials and additional administrative information.

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing
  • Lab: Course Overview

    After completing this module, students will be able to:

  • Successfully log into their virtual machine.
  • Have a full understanding of what the course intends to cover.
  • 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.

  • Examining Modules and Installing the SQLPS Module
  • Examining SQL Server Cmdlets
  • Discussing SQL Server Management Objects (SMO)
  • Recent Updates – July 2016
  • Lab: PowerShell and SQL

  • Installing the PowerShell SQL Module
  • After completing this module, students will be able to:

  • Examine and install modules.
  • Examine and understand SQL Server Cmdlets.
  • Understand SQL Server Management Objects (SMO).
  • Understand recent updates.
  • 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.

  • Examining SQL Information Retrieval
  • Exploring Logins
  • Adding Files and Filegroups
  • Detach and Attach Databases
  • Understanding Backup and Restore
  • Examining Indexes
  • Lab: SQL Administration with PowerShell

  • SQL Server Instances
  • Databases
  • Tables
  • Processes
  • Features
  • Jobs
  • Logins
  • Files and FileGroups
  • Detach and Attach Databases
  • Backup and Restore
  • Indexes
  • After completing this module, students will be able to:

  • Retrieve SQL Server instance information.
  • Understand and create logins.
  • Understand how to add files and filegroups.
  • Understand how to detach and attach databases.
  • Understand how to backup and restore databases.
  • Understand how to reorganize/rebuild indexes.
  • In this module, we will examine a handful of helpful cmdlets, discuss options for scheduling, and explore ways to track performance metrics.

  • Exploring Cmdlets
  • Discussing Scheduling
  • Understanding Performance Metrics
  • Lab: Monitoring and Automation

  • After completing this module, students will be able to:
  • Explore available cmdlets.
  • Understand scheduling options.
  • Understand options for tracking performance metrics.
  • 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.

  • Examining SQL Server Analysis Services (SSAS)
  • Exploring SQL Server Integration Services (SSIS)
  • Utilizing SQL Server Reporting Services (SSRS)
  • Lab: SSAS, SSIS, AND SSRS

  • SSAS
  • SSIS
  • SSRS
  • After completing this module, students will be able to:

  • Understand and utilize SSAS.
  • Understand and utilize SSIS.
  • Understand and utilize SSRS.
  • Course Details

    • enroll enroll-green
      Enrolled: 1331
    • duration duration green
      Duration: 1 Day

    Talk to Learning Advisor