PowerShell for SQL Server Administrators

Learn how to use PowerShell and SMO components for SQL Server administration

Course Code : 5066

Overview

This two-day course equips participants with the required knowledge and skills essential for successfully using PowerShell and SMO components for SQL Server administration on SQL Server 2016, 2014 or 2012. The course also helps participants understand how to manage the daily and the scheduled maintenance tasks. The course chiefly focuses on the administration of the database engine, including optional exercises on Analysis Services (SSAS) and Integration Services (SSIS). Participants of this course would need to have experience administering SQL Servers and using PowerShell.

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

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

Outline

  • Module Objectives
  • Install SQL Server
  • Configure Database Settings
  • Configure SQL Server Settings
  • Configure SQL Server Policy-Based Management
  • Review
  • Lab: Configuring SQL Server with PowerShell
  • Module Objectives
  • Managing Users and Roles
  • Managing Database Performance
  • Managing Database Availability
  • Managing SQL Server Features
  • Review
  • Lab: Administering SQL Servers with PowerShell
  • Module Objectives
  • Managing Backups and Restores
  • Maintaining Database Integrity and Performance
  • Monitoring and Auditing
  • Task Automation
  • Generating Reports
  • Review
  • Lab: Maintaining SQL Servers with PowerShell
View More

Prerequisites

There are no mandatory prerequisites for this course, however, completing the Foundations of Agile course prior to taking up this course 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 –

  • Current and aspiring business agility leaders
  • Business change agents
  • Business leaders
  • Business managers
  • Value managers
  • Product owners
  • Product managers
  • Anyone wanting a certification in ICAgile Business Agility Foundation (ICP-BAF)
  • Anyone wanting to be an ICAgile Certified Expert in Business Agility

Interested in this course? Let’s connect!

Customer Reviews

Name
Email
Rating
Comments

No reviews yet