Winter Savings - Save on IT Training Using Promo Code FROSTBYTE

closeClose

PowerShell for SQL Administration

  • Tuition USD $266 Save $30
  • Reviews star_rate star_rate star_rate star_rate star_half 1926 Ratings
  • Course Code 55207
  • Duration 1 day
  • Available Formats Classroom

This one day lab-intensive course is targeted to Database Professionals who want to explore using PowerShell to administrate SQL Server. Here you will learn the power of PowerShell for writing reusable code, database tasks, customizing the environment, database development, monitoring and automation and much more.

Skills Gained

  • Examine and install modules.
  • Examine and understand SQL Server Cmdlets.
  • Understand SQL Server Management Objects (SMO).
  • Understand recent updates.
  • 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.
  • Explore available cmdlets.
  • Understand scheduling options.
  • Understand options for tracking performance metrics.
  • Understand and utilize SSAS.
  • Understand and utilize SSIS.
  • Understand and utilize SSRS.
  • Understand the evolution of PowerShell.
  • Understand and utilize the PowerShell environment.
  • Understand and utilize the all-important Help System.
  • Understand and utilize PowerShell.
  • Understand and utilize working with the file system.
  • Understand and utilize parameters.
  • Understand and utilize user-defined variables.
  • Understand and utilize arrays.
  • Understand and utilize hash tables.
  • Understand and execute cmdlets.
  • Understand and utilize the pipeline.
  • Understand how to control the output with formatting.
  • Understand background jobs.
  • Understand aliases.
  • Understand and utilize loops.
  • Understand and utilize While loops.
  • Understand and utilize Do While loops.
  • Understand and utilize Do Until loops.
  • Understand and utilize For loops.
  • Understand and utilize ForEach loops.
  • Understand altering loop execution.
  • Understand and utilize scripting.
  • Understand functions and filters.
  • Understand the basics of script design.
  • Understand scripting pitfalls.

Who Can Benefit

This course is intended for SQL Administrators and SQL Developers.

Prerequisites

  • Six months experience using Powershell

Course Details

Outline


Module 1: Course Overview
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons

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

Lab 1: Course Overview
  • None
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.

Module 2: PowerShell and SQL
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.
Lessons
  • Examining Modules and Installing the SQLPS Module
  • Examining SQL Server Cmdlets
  • Discussing SQL Server Management Objects (SMO)
  • Recent Updates July 2016

Lab 1: 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.

Module 3: SQL Administration with PowerShell
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.
Lessons
  • Examining SQL Information Retrieval
  • Exploring Logins
  • Adding Files and Filegroups
  • Detach and Attach Databases
  • Understanding Backup and Restore
  • Examining Indexes

Lab 1: 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.

Module 4: Monitoring and Automation
In this module, we will examine a handful of helpful cmdlets, discuss options for scheduling, and explore ways to track performance metrics.
Lessons
  • Exploring Cmdlets
  • Discussing Scheduling
  • Understanding Performance Metrics

Lab 1: Monitoring and Automation
  • None
After completing this module, students will be able to:
  • Explore available cmdlets.
  • Understand scheduling options.
  • Understand options for tracking performance metrics.

Module 5: SSAS, SSIS, AND SSRS Optional Module
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.
Lessons
  • Examining SQL Server Analysis Services (SSAS)
  • Exploring SQL Server Integration Services (SSIS)
  • Utilizing SQL Server Reporting Services (SSRS)

Lab 1: 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.

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Great training platform, signing up for courses is made easy and a great customer support team is there to answer any question and provide assistance during application. The course was great overall, instructor explained everything throughly and quickly answer any incoming questions.

The format of the course was nicely structured, it was interactive and the labs really helped me understand the material on a deeper level.

I am overall very impressed with ExitCertified/Tech Data regarding the Spring Core class outline and iMVP delivery format.

Michael Stapleton held my attention to the course content even though is was a remote/virtual class.

The lady at the front really nice. Everthing was always stocked up: Helpful

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward