18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
100 Queen St W, Brampton, ON L6X 1A4, Canada
country flagUnited States
share button

55069: PowerShell for SQL Server Administrators Training

Category

PowerShell

Rating
4
(4)
Price

$1150

Course Description

This course guides learners on how to use PowerShell and SMO features to administer SQL Server. Students learn to maintain daily and scheduled maintenance works. The key focus is kept on Database Engine administration however, SSAS (Analysis Services) and SSIS (Integration Services) related exercises are also covered in the course.

This training is designed based on the objectives of the course variant 55069A.

Who should attend this course?

The course is meant for SQL server admins working with Windows Network. The ideal candidate must have some real-world experience with SQL server administration using PowerShell.

Schedules


Aug 05, 2021
9:00 am - 5:30 pm EST
Online

Aug 12, 2021
9:00 am - 5:30 pm EST
Online

Aug 19, 2021
9:00 am - 5:30 pm EST
Online

Aug 26, 2021
9:00 am - 5:30 pm EST
Online
question-markCan't find the batch you're looking for?

What you will learn

  • Using PowerShell to Install and Configure components of SQL Server.
  • Manage the administration of SQL Server with PowerShell
  • Using PowerShell programming and scripting options to maintain SQL Server environment

With Microtek Learning, you’ll receive:

  • Certified Instructor-led training
  • Industry Best Trainers
  • Official Training Course Student Handbook
  • Pre and Post assessments/evaluations
  • Collaboration with classmates (not available for a self-paced course)
  • Real-world knowledge activities and scenarios
  • Exam scheduling support*
  • Learn and earn program*
  • Practice Tests
  • Knowledge acquisition and exam-oriented
  • Interactive online course.
  • Support from an approved ITIL expert
  • For Government and Private pricing*
*For more details call: +1-800-961-0337 or email: info@microteklearning.com

Our Clients

For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.

  • 300+ enterprise clients
  • 100,000+ professionals trained
  • Service 70 of the Fortune 100
  • 96% of our clients would recommend us
our clients

Our Awards

our awards

Why Choose Us?

Best price

Best Price in the Industry

You give better value in the marketplace. We will beat it.

trusted-approved

Trusted & Approved

Our courses are accredited by the authorized vendor.

delivery-methods

Many Delivery Methods

Flexible delivery methods are available here.

high-quality-resources

High-Quality Resources

Resources are included for a comprehensive learning experience.

Curriculum

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

  • Install SQL Server
  • Configure Database Settings
  • Configure SQL Server Settings
  • Configure SQL Server Policy-Based Management
  • Review
  • Lab: Install and Configure SQL Server with PowerShell

  • Install SQL Server
  • Configure Database Settings
  • Configure SQL Server Settings
  • 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
  • This module explains how to perform day-to-day administrative tasks on SQL Server Instances using PowerShell.

  • Managing Users and Roles
  • Managing Database Performance
  • Managing Database Availability
  • Managing SQL Server Features
  • Review
  • Lab: Administering SQL Servers with PowerShell

  • Managing Users and Roles
  • Managing Database Performance
  • Managing Database Availability
  • 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)
  • This module explains how to perform maintenance tasks on SQL Server Instances using PowerShell.

  • Managing Backups and Restores
  • Maintaining Database Integrity and Performance
  • Monitoring and Auditing
  • Task Automation
  • Generating Reports
  • Review
  • Lab: Maintaining SQL Server with PowerShell

  • Managing Backups and Restores
  • Maintaining Database Integrity and Performance
  • Monitoring and Auditing
  • Task Automation
  • 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
  • Use PowerShell for Task Automation on SQL Server
  • Use PowerShell to Generate SQL Server Reports
  • REVIEWS ON OUR POPULAR COURSES

    male

    I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.

    MARTIN

    TORONTO, CANADA

    • (5)
    male

    I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.

    Prince N.

    Texas

    • (5)
    male

    I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.

    Marsh George

    Texas

    • (5)
    Accredited By

    Course Details

    • Start Date: Aug 05, 2021
    • Duration: 2 Days
    • Certification: NO
    • Enrolled: 1231
    • Price: $1150
    side post

    Talk to Learning Advisor

    Get In Touch

    * I authorize Microtek Learning to contact me via Phone/Email