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 :
  • 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
100+

Microsoft 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 Certified 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

  • Sep 22, 2023
  • 9:00 am - 5:00 pm EST
  • online
GTR
  • Oct 20, 2023
  • 9:00 am - 5:00 pm EST
  • online
  • Nov 17, 2023
  • 9:00 am - 5:00 pm EST
  • online
  • Dec 01, 2023
  • 9:00 am - 5:00 pm EST
  • 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.
  • With Microtek Learning, you’ll receive:

    svg Certified Instructor-led training
    svg Industry Best Trainers
    svg Official Training Course Student Handbook
    svg Pre and Post assessments/evaluations
    svg Collaboration with classmates (not available for a self-paced course)
    svg Real-world knowledge activities and scenarios
    svg Exam scheduling support*
    svg Learn and earn program*
    svg Practice Tests
    svg Knowledge acquisition and exam-oriented
    svg Interactive online course.
    svg Support from an approved expert
    svg For Government and Private pricing*

    Call Us For Professional, Flexible and Cost-Effective Courses

    Our Clients

    For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.

    • 300+ enterprise clients
    • 100,000+ professionals trained
    • Service 70 of the Fortune 100
    • 96% of our clients would recommend us
    our clients

    Our Awards

    our awards

    Why We Are Best To Choose?

    Best Price Guarantee Best Price Guarantee

    Best Price Guarantee

    We guarantee that you'll find the lowest price and better offers here than in the marketplace.

    Guaranteed to Run Guaranteed to Run

    Guaranteed to Run

    All our courses are assured to proceed on mentioned dates by the delivery methods, i.e., classroom, virtual and e-learning.

    Professional Team Support Professional Team Support

    Professional Team Support

    We have a program expert counselling team to give you round-the-clock prompt support with the best offers as we value your time and money.

    Experienced Trainers Experienced Trainers

    Experienced Trainers

    We have a team of Certified Expert Trainers with 5 to 15 years of Real Industry Experience.

    100% Satisfaction Guarantee 100% Satisfaction Guarantee

    100% Satisfaction Guarantee

    We believe in our courses and our instructor's skill; that's why we guarantee 100% Satisfaction to our customers.

    Real-World Experience Real-World Experience

    Real-World Experience

    Our training modules are based on current industry standards live industry projects, and we follow the authorized curriculum given to us by our training partner.

    Best Price Guarantee Best Price Guarantee

    Best Price Guarantee

    We guarantee that you'll find the lowest price and better offers here than in the marketplace.

    Guaranteed to Run Guaranteed to Run

    Guaranteed to Run

    All our courses are assured to proceed on mentioned dates by the delivery methods, i.e., classroom, virtual and e-learning.

    Professional Team Support Professional Team Support

    Professional Team Support

    We have a program expert counselling team to give you round-the-clock prompt support with the best offers as we value your time and money.

    Experienced Trainers Experienced Trainers

    Experienced Trainers

    We have a team of Certified Expert Trainers with 5 to 15 years of Real Industry Experience.

    Course Details

    • Enrolled: 1331
    • Duration: 1 Day

    Mode Of Training

    training

    Classroom

    training

    Online
    Instructor-led

    training

    Online
    Self-Paced

    training

    Onsite

    side post

    Talk to Learning Advisor