Home / Collections / Microsoft SQL Server / 55069AC PowerShell for SQL Server Administrators

55069AC PowerShell for SQL Server Administrators

Course Description

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

Audience profile

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

At the end of the course

  • Install and configure SQL Server and all its components using PowerShell
  • Manage daily SQL Server administration with PowerShell
  • Maintain your SQL Server environment using PowerShell programming and scripting options

Course outline

Module 1: Install and configure SQL Server with PowerShell

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

Lessons

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 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 or remove components from 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: Managing SQL Servers with PowerShell

This module explains how to perform daily administrative tasks on SQL Server instances using PowerShell.

Lessons

Module objectives

Lesson 1: User and role management

Lesson 2: Database Performance Management

Lesson 3: Managing Database Availability

Lesson 4: Managing SQL Server Roles

Review

Lab 1: Managing SQL Servers with PowerShell

  • Exercise 1: User and Role Management
  • Exercise 2: Database Performance Management
  • Exercise 3: Managing Database Availability
  • Exercise 4: Managing SQL Server Roles
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 cluster availability and AlwaysOn 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

Backup and restore management

Maintaining database integrity and performance

Monitoring and Auditing

Task automation

Report generation

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: Report generation
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 to automate tasks in SQL Server
  • Use PowerShell to generate SQL Server reports


Previous requirements

  • Experience working on Windows desktops or servers
  • Experience working in a Windows domain environment
  • Experience in administering SQL Server servers
  • Essential experience with PowerShell


Language

  • English course

  • Labs: English

€695.00
| /

Information related to training

Soporte siempre a tu lado

Training support: Always by your side

Formación presencial y telepresencial

Do you need another training modality?

bonificaciones

Bonuses for companies

Register here to receive invitations to events and other Nanfor activities