55069AC PowerShell for SQL Server Administrators

Name: 55069AC PowerShell for SQL Server Administrators
Availability: InStock
Rating: 5.0 (2 reviews)

More payment options

Modality:

Product Options

€695.00

| /

________________________________________________________________

Do you want to take this course remotely or in person?

Contact us by email: info@nanforiberica.com , phone: +34 91 031 66 78, WhatsApp: +34 685 60 05 91 , or contact Our Offices

________________________________________________________________

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

At the end of the course

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

Language

Audience profile

At the end of the course

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

Language

Customer Review

5.0/5.0

2 Testimonials

2

0

Write your review

Information related to training

Training support: Always by your side

Always by your side

Do you need another training modality?

Self Learning - Virtual - In-person - Telepresence

Bonuses for companies

For companies

55069AC PowerShell for SQL Server Administrators

Do you want to take this course remotely or in person?

Course Description

Module 1: Install and configure SQL Server with PowerShell

Lessons

Module 2: Managing SQL Servers with PowerShell

Lessons

Module 3: Maintaining SQL Server with PowerShell

Lessons

Module 1: Install and configure SQL Server with PowerShell

Lessons

Module 2: Managing SQL Servers with PowerShell

Lessons

Module 3: Maintaining SQL Server with PowerShell

Lessons

Write Your Experience

Information related to training

Training support: Always by your side

Do you need another training modality?

Bonuses for companies

Register here to receive invitations to events and other Nanfor activities

Quick links

55069AC PowerShell for SQL Server Administrators

Do you want to take this course remotely or in person?

Course Description

Write Your Experience

Information related to training

Training support: Always by your side

Do you need another training modality?

Bonuses for companies

Register here to receive invitations to events and other Nanfor activities