To customize this class, call 800-453-5961 or click here to contact us

Course : 70016

70016 PowerShell For SQL Server Administrators (3 days)

This course is intended for SQL administrators and managers who have very limited PowerShell information. The training offers instruction on the management of essential features of SQL together with fundamental skills and expertise required to handle and improve PowerShell SQL interoperations.

[printfriendly]

Note: For additional questions and clarification about PowerShell Class, you may reach Bill Ramirez at bill@dynamicsedge.com or on his following contact details: Office- (510) 804-3600 & Cell- (415) 200-6969

PowerShell For SQL Server Administrators 70016COURSE OVERVIEW:

This course is intended for SQL administrators and managers who have very limited PowerShell information. The training offers instruction on the management of essential features of SQL together with fundamental skills and expertise required to handle and improve PowerShell SQL interoperations.

PREREQUISITES:

  • The basic understanding and knowledge of PowerShell
  • Or Completion of course MS-10961 or MS-55039

AGENDA TOPICS:

Course Overview

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

  • Successfully log into their virtual machine.
  • Have a full understanding of what the course intends to cover.

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.

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

LAB:

  • Installing the PowerShell SQL Module
  • Examine and install modules.
  • Examine and understand SQL Server Cmdlets.
  • Understand SQL Server Management Objects (SMO).
  • Understand recent updates.

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.

  • 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.
  • Learn how to add files and filegroups.
  • Understand how to detach and attach databases.
  • Learn how to backup and restore databases.
  • Understand how to reorganize/rebuild indexes.

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.

  • Exploring Cmdlets
  • Discussing Scheduling
  • Understanding Performance Metrics

LAB: Monitoring and Automation

  • Explore available cmdlets.
  • Understand scheduling options.
  • Understand options for tracking performance metrics.

SSAS, SSIS, AND SSRS

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

Appendix: 752552 PowerShell 5.0 Basics

PowerShell is a scripting language, and an automation platform for Windows and Windows Server, which allows you to simplify and streamline the management of your systems. It utilizes the power of the .NET Framework, which provides rich objects and an extensive set of built-in functionality for taking control of your Windows environments.

  • Introduction to PowerShell
  • Utilizing PowerShell
  • The Pipeline
  • Processing Data with Loops
  • Scripting and Functions

LAB : Appendix: 752552 PowerShell 5.0 Basics

  • The Console
  • The PowerShell Integrated Scripting Environment (ISE)
  • Understand and execute cmdlets.
  • Learn how to control the output with formatting.
  • Understand background jobs.
  • Learn aliases.
  • Utilizing PowerShell
  • Updating Help
  • Utilizing Help
  • Understand the evolution of PowerShell.
  • Working with the File System
  • Parameters
  • User-Defined Variables
  • Arrays
  • Hash Tables
  • Creating a Pipeline
  • Passing Data Through the Pipeline
  • While Loops
  • Do While Loops
  • Do Until Loops
  • For Loops
  • ForEach Loop
  • Scripting
  • Understand altering loop execution.
  • Learn functions and filters.
  • Understand the basics of script design.
  • Learn scripting pitfalls.
  • Understand and utilize the following;  PowerShell environment.
  • The all-important Help System.
  • PowerShell.
  • Working with the file system.
  • Parameters.
  • User-defined variables.
  • Arrays.
  • Hash tables.
  • The pipeline
  • Loops.
  • While Loops.
  • Do While loops.
  • Do Until loops.
  • For loops.
  • And, ForEach loops.

Need help picking the right course?

Give us a call!

408-684-5250 or
800-453-596 (Toll Free)

Train Your Team

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!

Register Now

Duration: 3 days

This product is currently out of stock and unavailable.