Digi Academy

PowerShell for SQL Server Administrators

Digi Academy
A Milano

Chiedi il prezzo
Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Luogo Milano
Inizio Scegli data
  • Corso
  • Milano
  • Inizio:
    Scegli data
Descrizione

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 Exercise 1: Install SQL Server

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa
Inizio Scegli data
Luogo
Milano
Via Valtellina, 63, 20124, Milano, Italia
Visualizza mappa

Cosa impari in questo corso?

Server
Management
SQL

Programma

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:


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


This module explains how to perform day-to-day administrative tasks on SQL Server Servers using 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


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:


Manage Users and Roles


Manage Database Performance


Manage Database Availability with Clustering & AlwaysOn Availability Groups


Manage Integration Services and Analysis Services


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


Module Objectives


Managing Backups and Restores


Maintaining Database Integrity and Performance


Monitoring and Auditing


Task Automation


Generating Reports


Review


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:


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



Gli utenti che erano interessati a questo corso si sono informati anche su...
Leggi tutto