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

Course Syllabus
Who It’s for
FAQs

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.

Why CounselTrain is the best option for Corporate Trainings?

Customized Learning

Business Fulfilment

Industry Expert Trainers

100% ROI

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.