55069: PowerShell for SQL Server Administrators

55069: PowerShell for SQL Server Administrators

Audience

This 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.

Prerequisites

Before attending this course, students must have:

  • Experience working on Windows desktops or servers
  • Experience working in a Windows domain environment
  • Experience Administering SQL Server Servers
  • Fundamental experience with PowerShell or Course 10961 – Automating Administration with Windows PowerShell

Duration

2 days.

Course Objectives

This two-day instructor-led 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 administration of the database engine, but optional material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.

After completing this course, students will be able to:

  • 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

Course Content

Module 1: Install and Configure SQL Server with PowerShell
Module Objectives
Lesson 1: Install SQL Server
Lesson 2: Configure Database Settings
Lesson 3: Configure SQL Server Settings
Lesson 4: Configure SQL Server Policy-Based Management
Review
Lab : Configuring SQL Server with PowerShell
After completing this module, students will be able to:
• Install SQL Server
• Add/Remove components to an existing instance (SSRS, SSIS, SSAS, etc.)
• Configure SQL Server and Database Settings
• Configure SQL Server Policy-Based Management

Module 2: Administering SQL Servers with PowerShell
Module Objectives
Lesson 1: Managing Users and Roles
Lesson 2: Managing Database Performance
Lesson 3: Managing Database Availability
Lesson 4: Managing SQL Server Features
Review
Lab : Administering SQL Servers with PowerShell
After completing this module, students will be able to:
• Manage Users and Roles
• Manage Database Performance
• Manage Database Availability with Clustering & AlwaysOn Availability Groups
• Manage Integration Services and Analysis Services

Module 3: Maintaining SQL Server 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
After completing this module, students will be able to:
• Manage SQL Server Backups and Restores
• Maintain Database Integrity and Performance
• Monitor and Audit changes to a SQL Server
• Task Automation on SQL Server
• Generate SQL Server Reports

Virtual Courses

ALL of our courses can be delivered virtually. And our Bath public schedule of courses are now available as live virtual sessions, using the popular Zoom Virtual Classroom and remote labs. Delegates can test their access at: www.zoom.us/test

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...