Skip to content
ictcLogo
  • About
  • Training
  • Learning Paths
  • Training Center
  • News
  • Contact
Menu
  • About
  • Training
  • Learning Paths
  • Training Center
  • News
  • Contact
Microsoft

Course 55207-A: PowerShell for SQL Administration

  • Duration: 1 days
  • Job Role: Developer

Course 55207-A: PowerShell for SQL Administration

Share This Learning Path

Need more info? Contact us

This course is intended for SQL administrators with little or basic knowledge of PowerShell. The course centers on SQL administrative tasks that are commonly used, and provides the basic understanding needed for administrators to utilize the expanding PowerShell SQL interoperations. The course concludes with a copy of course 752552 PowerShell 5.0 Basics.

Audience Profile

This course is intended for SQL Administrators and SQL Developers.

Prerequisites

  • Basic or little knowledge of PowerShell.

Course outline

Module 1: Course Overview

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

Course Overview

Lab Lessons

Lab lessons not available

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

Module Overview

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 Sessions

PowerShell and SQL

Lab Lessons

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

Module Overview

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 Sessions

SQL Administration with PowerShell

Lab Lessons

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

Module Overview

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 Sessions

Monitoring and Automation

Lab Lessons

Lab lessons not available

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

Module Overview

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 Sessions

SSAS, SSIS, AND SSRS

Lab Lessons

SSAS
SSIS
SSRS

After completing this module, students will be able to:

Understand and utilize SSAS.
Understand and utilize SSIS.
Understand and utilize SSRS.

Book Your Seat​

Find Learning Paths​

  • Search Paths

  • Vendors

Latest Learning Paths​

Microsoft

Course MB-920T00-A: Microsoft Dynamics 365 Fundamentals (ERP)

  • Dynamics-365
  • Beginner

Microsoft

Course PL-600T00-A: Power Platform Solution Architect

  • Power-Platform
  • Advanced

Microsoft

Course 20703-1-B: Administering System Center Configuration Manager

  • Windows
  • Advanced

Join our community of certified professionals

Sign Up to our newsletter, and stay always up to date with latest IT certifications

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Facebook Linkedin

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Explore

Contact Us

  • +30 211 500 29 00
  • info@ictc.gr
  • Lagoumitzi 24, Kallithea
ictcLogo

International Computer Training Center

  • Copyright reserved to ICTC
  • Proudly Crafted by GTP Works

Copyright reserved to ICTC. Proudly Crafted by GTP Works

Choose how to get more info...

Give as a call

211 500 2 900

Let us, call you

Send us an email