55069-A: PowerShell for SQL Server Administrators

4.5/5

This two-day instructor-led 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. The main focus will be administration of the database engine, but material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.

Training Options

Classroom Training

Online Instructor Led

Onsite Training

Course Information

Module 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: Configuring SQL Server with PowerShell

  • 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

Module 2: Administering SQL Servers with PowerShell

  • Managing Users and Roles
  • Managing Database Performance
  • Managing Database Availability
  • Managing SQL Server Features

Lab: Administering SQL Servers with PowerShell

  • Manage Users and Roles
  • Manage Database Performance
  • Manage Database Availability with Clustering and AlwaysOn Availability Groups
  • Manage Integration Services and Analysis Services

Module 3: Maintaining SQL Server with PowerShell

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

Lab: Maintaining SQL Servers with PowerShell

  • 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

Audience Profile

This PowerShell for SQL Server Administrators 55069A Training course is ideal for anyone who works with the Windows network environment. However, this training can be much more beneficial for SQL Server Administrators.

100% Business Fulfilment

Request more Information

    Corporate Training Options

    Online Instructor Led

    Live, Online Training by top Instructors and practitioners across the globe.

    Onsite
    Training

    Conduct training at the work location you desired.

    Classroom Training

    The Venue will be ideally located and easy to access with covid-19 SOP's.

    Overseas Training

    Travel to any desired location for your training.

    What People say?

    Mohammed Aljbreen Operation Specialist, SAMA

    The Clarity of the Content was very good. The explanation of the trainer with in-depth knowledge in a proper flow really impressed me to give 5 star rating.

    Arindam Chakraborty Systems Specialist, King Abdullah University of Sciences & Technology

    The Instructor was really impressive. Clear cut explanation of every topic he covered with real time scenarios.

    Sher Afzal Khan Cloud Engineer, Cloud 9 Networks

    The Trainer and the Course Material, both are good. Good flow of explanation with simple examples. The complete training was focused on current industry challenges.

    Jawed Ahmad Siddiqui Sr. System Administrator, Saudi Ceramics

    The Trainer’s presentation was impressed me to continue the course till end. Never feel bore till the entire sessions. She studied our mindset and follows.

      Not sure,
      which course to choose?

      Our Clients across the Globe!

      Our Corporate Clients