PowerShell for SQL Administration

Course Code: 5065

Overview
Schedule classes
What you'll learn
Outline
Prerequisites
Who should attend

Overview

Targeted towards SQL administrators and SQL developers, with little to no understanding of PowerShell, this three day course discusses the common SQL administrative tasks, and helps participants understand how they can get the most out of the expanding PowerShell SQL inter-operations.

Schedule Classes

Looking for more sessions of this class?

Course Delivery

This course is available in the following formats:

Live Classroom
Duration: 5 days

Live Virtual Classroom
Duration: 5 days

What You'll learn

Examine and install modules
Examine and understand SQL Server Cmdlets and SQL Server Management Objects
Explore available cmdlets, understand and execute them
Understand scheduling options
Understand options for tracking performance metrics
Understand and utilize SSAS, SSIS and SSRS
Understand and utilize PowerShell and the PowerShell environment
Understand how to control the output with formatting
Understand and utilize loops – While, Do While, Do Until, For, ForEach
Understand and utilize scripting, and discover the scripting pitfalls
Understand the basics of script design

Outline

Module 1: Course overview

Introduction
Course Materials
Facilities
Prerequisites
What We’ll Be Discussing
Lab: Course Overview
- Successfully log into their virtual machine
- Have a full understanding of what the course intends to cover

Module 2: PowerShell and SQL

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

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

Exploring Cmdlets
Discussing Scheduling
Understanding Performance Metrics
Lab: Monitoring and Automation
- Explore available cmdlets
- Understand scheduling options
- Understand options for tracking performance metrics

Module 5: SSAS, SSIS and SSRS

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
- Understand and utilize SSAS
- Understand and utilize SSIS
- Understand and utilize SSRS

Module 6: PowerShell 5.0 basics

Utilizing PowerShell
The Pipeline
Processing Data with Loops
Scripting and Functions
Lab: PowerShell 5.0 Basics

Prerequisites

Participants need to have experience as SQL administrators or developers. Some understanding of PowerShell would be beneficial.

Who Should Attend

Anyone interested in the paradigm shifts necessary to enable organizational agility in today’s innovative business climate will find the Business Agility Foundations course compelling. The course is highly recommended for –