Home / All Courses / Microsoft / Microsoft PowerShell / 55069: PowerShell for SQL Server Administrators

55069: PowerShell for SQL Server Administrators Training & Certification Course

FAQ's

Overview

This two-day Microsoft PowerShell course provides candidates with the knowledge and skills needed to use PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012. Students will learn how to manage day-to-day and scheduled maintenance tasks. The main focus will be the administration of the database engine, but optional material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.

Audience Profile

This Microsoft PowerShell course is intended for SQL Server administrators who work in a Windows network environment. At least one year of experience administering SQL Servers and using PowerShell is recommended.

At Course Completion

Install and Configure SQL Server and all its components using PowerShell
Manage day-to-day SQL Server Administration with PowerShell
Maintain the SQL Server environment using PowerShell scripting and programming options

Prerequisite

Experience working on Windows desktops or servers, Experience working in a Windows domain environment

Recommended Course

10962: Advanced Automated Administration With Windows PowerShell

Full Description

55069: PowerShell for SQL Server Administrators

Module 1: Install and Configure SQL Server with PowerShell

This module explains how to setup SQL Server components using PowerShell.

Lessons: Module Objectives

Install SQL Server
Configure Database Settings
Configure SQL Server Settings
Configure SQL Server Policy-Based Management

Lab 1: Install and Configure SQL Server with PowerShell

Exercise 1: Install SQL Server
Exercise 2: Configure Database Settings
Exercise 3: Configure SQL Server Settings
Exercise 4: Configure SQL Server Policy-Based Management

After completing this module, students will be able to:

Use PowerShell to Install SQL Server Instances
Use PowerShell to Add/Remove components to an existing instance (SSRS, SSIS, SSAS, Tools, etc.)
Use PowerShell to configure SQL Server and Database Settings
Use PowerShell to configure SQL Server Policy-Based Management

Module 2: Administering SQL Servers with PowerShell

This module explains how to perform day-to-day administrative tasks on SQL Server Instances using PowerShell.

Lessons: Module Objectives

Managing Users and Roles
Managing Database Performance
Managing Database Availability
Managing SQL Server Features

Lab 1: Administering SQL Servers with PowerShell

Exercise 1: Managing Users and Roles
Exercise 2: Managing Database Performance
Exercise 3: Managing Database Availability
Exercise 4: Managing SQL Server Features

After completing this module, students will be able to:

Use PowerShell to Manage Users and Roles
Use PowerShell to Manage Database Performance
Use PowerShell to Manage Database Availability (Using Clustering and AlwaysOn Availability Features)
Use PowerShell to Manage Integration Services (SSIS) and Analysis Services (SSAS)

Module 3: Maintaining SQL Server with PowerShell

This module explains how to perform maintenance tasks on SQL Server Instances using PowerShell.

Lessons: Module Objectives

Managing Backups and Restores
Maintaining Database Integrity and Performance
Monitoring and Auditing
Task Automation
Generating Reports
Review

Lab 1: Maintaining SQL Server with PowerShell

Exercise 1: Managing Backups and Restores
Exercise 2: Maintaining Database Integrity and Performance
Exercise 3: Monitoring and Auditing
Exercise 4: Task Automation
Exercise 5: Generating Reports

After completing this module, students will be able to:

Use PowerShell to Manage SQL Server Backups and Restores
Use PowerShell to Maintain Database Integrity and Performance (Using DBCC and other tools)
Use PowerShell to Monitor and Audit changes to a SQL Server Instance

Fees & Schedule

Delivery Mode	Course Duration	Fees
Live Virtual Training	2 Days	Ask for Quote
Onsite Classroom Training	2 Days	Ask for Quote
Customized Training	2 Days	Ask for Quote

FAQ's

I. Who we are?

SpireTec solutions is the latest technology enabled I.Tmanagement training company specialized in offering 1500+ courses with the state of art training facilities backed by a team of industry experts in various domains with assuring best quality services.

Drop us a query

Our Clients Testimonial

The method of instructing and the way to explain is excellent and easy to remember. I think he is very good instructor and he is very flexible to take any questions..

Chevron
Instructor was very knowledgeable and very well spoken. For me, the best part of this training course was having a knowledgeable instructor who could answer any of my questions.

US Army
Thank you so much for your time and especially your expertise with us. We really appreciate this discussion session.We gained a lot of technical knowledge today.

SWHealth
Thanks Abhishek for all your help and guidence on this training. Excellent Work is done. I checked with team and they are extremly pleased.

Swhealth
Mr. Abhishek Kumar displayed thorough knowledge of material. His enthusiasm and energy shined throughout the course.
Instructor was able to help me resolve an issue i was having as a real work problem in sharepoint.
The instructor was good especially because he has hands on experience on SharePoint.
Excellent training with proper support.
Instructor was very knowledgeable. Followed course outline in a clear manner and interjected non-course contained material at points in order to clarify.
Instructor was very knowledgeable about the information which was very helpful when it came to answering questions.
Instructor was excellent. He explained the concepts before showing how to do things which was so helpful. Can't say enough good about him.
Abhishek did a great job. Excellent Instructor for BI.
The classroom environment was fine. I did the class from my home. And, the connection speed was outstanding.Very good instructor.
I have completed the course 20778 Analyzing data with Power BI. The instructor Mr. Abhishek Kumar delivered interactive sessions which were impressively informative. He went through the content in detail which showcased that he has a thorough knowledge of the subject matter.
Learned a lot of things and more than I excepted to learn. Was a very nice experience to learn from Abhishek.

Banque des Mascareignes
Excellent and Very Knowledgeable. Highly Recommedded Mr Abhishek for Office 365 Training.

Banque des Mascareignes
The instructor was very welcoming and spent the me so that we could get to know each other. I could tell that the instructor was very knowledgeable on the subject and connuously kept me involved in the conversation.
Abhishek was a great instructor. Very knowledgeable, and very nice.
Mr. Abhishek was friendly and knows his subject. He helped in sharing every documents, we will need for further studies and exam for Power BI.

State Informatics Limited
The trainig was good and well organized. Very motivated and patience in understanding our questions.

State Informatics Limited
He set up a collaborative medium between instructor and students. You can ask questions and he will give you a presenter view where you can share what you have learnt. Instructor Abhishek Kumar is a terrific subject expert. I recommend it to everyone as well. A job well done!

Overview

Full Description

Fees & Schedule

FAQ's

The method of instructing and the way to explain is excellent and easy to remember. I think he is very good instructor and he is very flexible to take any questions..

Chevron

Instructor was very knowledgeable and very well spoken. For me, the best part of this training course was having a knowledgeable instructor who could answer any of my questions.

US Army

Thank you so much for your time and especially your expertise with us. We really appreciate this discussion session.We gained a lot of technical knowledge today.

SWHealth

Thanks Abhishek for all your help and guidence on this training. Excellent Work is done. I checked with team and they are extremly pleased.

Swhealth

Mr. Abhishek Kumar displayed thorough knowledge of material. His enthusiasm and energy shined throughout the course.

Instructor was able to help me resolve an issue i was having as a real work problem in sharepoint.

The instructor was good especially because he has hands on experience on SharePoint.

Excellent training with proper support.

Instructor was very knowledgeable. Followed course outline in a clear manner and interjected non-course contained material at points in order to clarify.

Instructor was very knowledgeable about the information which was very helpful when it came to answering questions.

Instructor was excellent. He explained the concepts before showing how to do things which was so helpful. Can't say enough good about him.

Abhishek did a great job. Excellent Instructor for BI.

The classroom environment was fine. I did the class from my home. And, the connection speed was outstanding.Very good instructor.

I have completed the course 20778 Analyzing data with Power BI. The instructor Mr. Abhishek Kumar delivered interactive sessions which were impressively informative. He went through the content in detail which showcased that he has a thorough knowledge of the subject matter.

Learned a lot of things and more than I excepted to learn. Was a very nice experience to learn from Abhishek.

Banque des Mascareignes

Excellent and Very Knowledgeable. Highly Recommedded Mr Abhishek for Office 365 Training.

Banque des Mascareignes

The instructor was very welcoming and spent the me so that we could get to know each other. I could tell that the instructor was very knowledgeable on the subject and connuously kept me involved in the conversation.

Abhishek was a great instructor. Very knowledgeable, and very nice.

Mr. Abhishek was friendly and knows his subject. He helped in sharing every documents, we will need for further studies and exam for Power BI.

State Informatics Limited

The trainig was good and well organized. Very motivated and patience in understanding our questions.

State Informatics Limited

He set up a collaborative medium between instructor and students. You can ask questions and he will give you a presenter view where you can share what you have learnt. Instructor Abhishek Kumar is a terrific subject expert. I recommend it to everyone as well. A job well done!