PowerShell for SQL Server Administrators

Mail ons Training PowerShell for SQL Server Administrators

Info Support Cursuscode
MS55069
Leverancier (code)
Microsoft (55069)
Duur
2 dagen

Dagelijkse en periodieke beheertaken beheren met PowerShell

Cursusbeschrijving

Als beheerder leert u hoe u PowerShell kunt gebruiken om SQL Server beheer uit te voeren. De cursus richt zich met name op het beheer van de database engine, maar bevat ook beheer van Analysis Services (SSAS) en Integration Services (SSIS)

Cursusdata, locaties en tarief

Deze training kan in maatwerk- of incompany worden verzorgd. Neem contact met ons op voor meer informatie.

Cursusinhoud

  • Installeren en Configureren van SQL Server met PowerShell:
  • Installeren SQL Server
  • Configureren Database Settings
  • Configureren SQL Server Settings
  • Configureren SQL Server Policy-Based Management
  • Dagelijkse beheertaken met PowerShell:
  • Beheer Gebruikers en Rollen
  • Beheer Database Performance
  • Beheer Beschikbaarheid Database
  • Beheer SQL Server Features
  • Beheer van de SQL Server omgeving met hulp van PowerShell scripting en programmeer opties:
  • Managing Backups and Restores
  • Maintaining Database Integrity and Performance
  • Monitoring and Auditing
  • Task Automation
  • Generating Reports

Benodigde voorkennis

Ervaring met Windows desktops of servers. Ervaring met een Windows domein. Ervaring met het beheer van SQL Server Servers. Basis kennis PowerShell.

Cursusmateriaal

  • Microsoft Community Course

Doelgroep

  • Infrastructuur Specialist
  • Beheerder

Heeft u vragen?

U kunt ons telefonisch bereiken via de volgende nummers:
Nederland: +31 318 501 119
België: +32 15 286 370

Stuurt u liever een mail?
Nederland: training.nl@infosupport.com
België: training.be@infosupport.com

Mail us Training PowerShell for SQL Server Administrators

Info Support Course code
MS55069
Supplier (code)
Microsoft (55069)
Length
2 days

Manage day-to-day and scheduled maintenance tasks

Course outline

As an administrator you get the knowledge and skills needed to use PowerShell for SQL Server administration. You will learn how to manage day-to-day and scheduled maintenance tasks. The main focus will be administration of the database engine, but material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.

Course dates, locations and price

This course can be conducted as a tailormade- or an incompany training. Please contact us for more information.

Course Contents

  • Install and Configure SQL Server and all its components using PowerShell:
  • Install SQL Server
  • Configure Database Settings
  • Configure SQL Server Settings
  • Configure SQL Server Policy-Based Management
  • Manage day-to-day SQL Server Administration with PowerShell:
  • Managing Users and Roles
  • Managing Database Performance
  • Managing Database Availability
  • Managing SQL Server Features
  • Maintain the SQL Server environment using PowerShell scripting and programming options:
  • Managing Backups and Restores
  • Maintaining Database Integrity and Performance
  • Monitoring and Auditing
  • Task Automation
  • Generating Reports

Course prerequisites

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

Course material

  • Microsoft Community Course Materials

Target Audience

  • Infrastructure Expert
  • Administrator

Do you have any questions?

You can reach us through the following numbers:
Netherlands: +31 318 501 119
Belgium: +32 15 286 370

Rather send an email?
Netherlands: training.nl@infosupport.com
Belgium: training.be@infosupport.com