Home » Trainings Shop » 55069 PowerShell for SQL Server Administrators
Course ID: #n. v.

55069 PowerShell for SQL Server Administrators

Dauer: 2 Tage Daten:

This course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks.

1 – Install and Configure SQL Server with PowerShell

  • Install SQL Server
  • Configure Database Settings
  • Configure SQL Server Settings
  • Configure SQL Server Policy-Based Management
  • Lab 1: Configuring SQL Server with PowerShell

2 – Administering SQL Servers with PowerShell

  • Managing Users and Roles
  • Managing Database Performance
  • Managing Database Availability
  • Managing SQL Server Features
  • Lab 1: Administering SQL Servers with PowerShell

3 – Maintaining SQL Server with PowerShell

  • Managing Backups and Restores
  • Maintaining Database Integrity and Performance
  • Monitoring and Auditing
  • Task Automation
  • Generating Reports
  • Lab 1: Maintaining SQL Servers with PowerShell
Lernlösung

Blended Learning, Firmenseminar, Individualcoaching, Klassenraumtraining, Online Live Webinar
Sprache

Deutsch, Englisch, Französisch, Italienisch
Daten

flexibel, auf Anfrage
Ort

Brüttisellen, Lausanne, flexibel, auf Anfrage

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

After completing this course, students will be able to:

  • Install and Configure SQL Server and all its components using PowerShell
  • Manage day-to-day SQL Server Administration with PowerShell
  • Maintain the SQL Server environment using PowerShell scripting and programming options

10961 Automating Administration with Windows PowerShell v5.0

Ähnliche Produkte

  • Course ID: #

    AZ-301T04 Designing an Infrastructure Strategy

    Learn how to Describe DNS and IP strategies for VNETs in Azure, compare connectivity options for ad-hoc and hybrid connectivity, distribute network traffic across multiple loads using load balancers, and design a hybrid connectivity scenario between cloud and on-premise.

    Dauer: 1 Tag
    Price:
    CHF770 zzgl. MwSt
    AZ-301T04 Designing an Infrastructure Strategy
  • Course ID: #10992

    10992 Integrating On-Premises Core Infrastructure with Microsoft Azure

    Dieses Seminar behandelt vielfältige Komponenten, einschliesslich Azure-Compute-, Azure-Storage- und -Netzwerkdienste, die Kunden bei der Bereitstellung hybrider Lösungen unterstützen. In diesem Zusammenhang bedeutet hybrid die Integration von Infrastrukturtechnologien, die in On-premises-Rechenzentren mit Azure-IaaS- und -PaaS-Diensten gehostet werden. Das Seminar bietet einen Überblick über diese Dienste und vermittelt das Wissen, um hybride Lösungen entwerfen zu können. In Übungen erwerben die Teilnehmer praktische Erfahrung mit der Implementierung solcher Lösungen.

    Dauer: 3 Tage
    Price:
    CHF2'200 – CHF8'100 zzgl. MwSt
    10992 Integrating On-Premises Core Infrastructure with Microsoft Azure
  • Course ID: #

    AZ-300T04 Creating and Deploying Apps

    This course teaches IT Professionals how to build Logic App solutions that integrate apps, data, systems, and services across enterprises or organizations by automating tasks and business processes as workflows.

    Dauer: 1 Tag
    Price:
    CHF770 zzgl. MwSt
    AZ-300T04 Creating and Deploying Apps
  • Course ID: #AZ-500

    AZ-500 / AZ-500T00 Microsoft Azure Security Technologies

    In this course students will gain the knowledge and skills needed to implement security controls, maintain the security posture, and identify and remediate vulnerabilities by using a variety of security tools. The course covers scripting and automation, virtualization, and cloud N-tier architecture.

    Dauer: 4 Tage
    Price:
    CHF3'300 – CHF12'000 zzgl. MwSt
    AZ-500 / AZ-500T00 Microsoft Azure Security Technologies

CHF1'550 – CHF5'800 zzgl. MwSt

Leeren

ANMELDEN

Newsletter

Erhalten Sie aktuelle Informationen zu neuen Schulungen, Angeboten und Aktionen per E-Mail.

Email Subscription
Microsoft Office
Alle anzeigen
Microsoft Tech
Alle anzeigen
Business & Soft Skills
Prozess- und Qualitätsmanagement
Projektmanagement
Adobe
CompTIA
Security
Linux
Oracle
Amazon
Google
Leadership and Professional Development
E-Learning und LMS