Curs 55069 PowerShell for SQL Server Administrators

Curs PowerShell for SQL Server Administrators – Curs 55069

Inregistrati-va

Module 1: Install and Configure SQL Server with PowerShell

This module explains how to setup 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/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

Module 2: Administering SQL Servers with PowerShell

This module explains how to perform day-to-day administrative tasks on SQL Server Instances using PowerShell.

Lessons

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 1: Administering SQL Servers with PowerShell
  • Exercise 1: Managing Users and Roles
  • Exercise 2: Managing Database Performance
  • Exercise 3: Managing Database Availability
  • Exercise 4: 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)

Module 3: Maintaining SQL Server with PowerShell

This module explains how to perform maintenance tasks on SQL Server Instances using PowerShell.

Lessons
Module Objectives

  • Managing Backups and Restores
  • Maintaining Database Integrity and Performance
  • Monitoring and Auditing
  • Task Automation
  • Generating Reports

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: 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

 

Inregistrati-va

Locatia de desfasurare a cursului:

Sediul Learning Solution: Str. Transilvaniei nr. 24, Sector 1, Bucuresti
Cine susține cursul?
Florin Florea

Durata Curs
2 zile: 9:00 – 17:00

Cunostinte prealabile

Experience working on Windows desktops or servers
Experience working in a Windows domain environment
Experience Administering SQL Server Servers
Fundamental experience with PowerShell

Cursuri Conexe

Curs Updating Your Skills to SQL Server 2016 – Curs 10986
Curs 10990 Analyzing Data with SQL Server Reporting Services
Curs 20761 Querying Data with Transact-SQL
Curs 20762 Developing SQL Databases
Curs 20764 Administering a SQL Database Infrastructure
Curs 20765 Provisioning SQL Databases
Curs 20767 Implementing a SQL Data Warehouse
Curs 20768 Developing SQL Data Models
Curs 55170 Writing Reports with Report Designer and SSRS 2016 Level 2

Abonați-vă la newsletter

Ne găsiți la
Telefon/Fax: 021 367 0092
Telefon: 0748.11.23.23
Str. Transilavaniei, nr. 24, Sector 1, Bucuresti,
Cod Postal 010798, ROMANIA