Item number: 98848848

Microsoft PowerShell and SQL Server Training

Item number: 98848848

Microsoft PowerShell and SQL Server Training

159,00 192,39 Incl. tax

Order this unique E-Learning Training Microsoft PowerShell and SQL Server course online, 1 year 24/7 access to rich interactive videos, progress through reporting and testing.

Brand:: Microsoft

Discounts:

Buy 2 for €155,82 each and save 2%
Buy 3 for €154,23 each and save 3%
Buy 4 for €152,64 each and save 4%
Buy 5 for €151,05 each and save 5%
Buy 10 for €143,10 each and save 10%
Buy 25 for €135,15 each and save 15%
Buy 50 for €127,20 each and save 20%

Availability:: In stock

Delivery time:: Ordered before 5 p.m.! Start today.

Startdate:

Student name (Multiple students, we will contact you):

Student email address:

Certificaat:

Award Winning E-learning
Lowest price guarantee
Personalized service by our expert team
Pay safely online or by invoice
Order and start within 24 hours

Microsoft PowerShell and SQL Server E-Learning

Enroll in the award-winning Microsoft PowerShell and SQL Server E-Learning course and get 1-year, 24/7 access to comprehensive training through interactive videos, voice-guided lessons, hands-on tasks, and progress tracking. This course uniquely combines the automation power of PowerShell with the robust functionality of SQL Server management.

Microsoft PowerShell is a feature-rich, command-line based scripting environment for automating Microsoft server tasks. When used with SQL Server, PowerShell gives administrators full access to manage services, enforce policies, and handle database operations—all through powerful scripts.

This course is ideal for those looking to streamline SQL Server management with automation. After completing the training, you will receive a certificate of participation.

Why Choose This Training?

1-year access to award-winning e-learning, available 24/7
Focused on combining PowerShell scripting with SQL Server administration
Learn to automate tasks, manage services, enforce policies, and handle databases
Interactive videos, hands-on assignments, and real progress tracking
Improve accuracy and efficiency in SQL Server operations
Certificate of participation included

Who Should Attend?

SQL Server administrators wanting to automate daily tasks
IT professionals working with PowerShell and databases
Sysadmins responsible for managing Microsoft SQL Server environments
Those seeking more consistent and reliable SQL operations via scripting
Anyone interested in mastering PowerShell for database management

Course content

Getting Started with SQL and PowerShell

Course: 20 Minutes

Course Introduction
Introduction to PowerShell and SQL Server
Working with Services
PowerShell and the SQLConnection .NET Class

SQL Server Management Objects

Course: 34 Minutes

Loading the SMO Assemblies into PowerShell
Working with SQL Server Using SMO
Working with Databases Using SMO
Working with Tables Using SMO
Backing up and Restoring with SM

Management and WMI

Course: 25 Minutes

Managing SQL Server Services
Managing Client Network Protocols with WMI
Managing SQL Server Client Aliases with WMI
Changing FILESTREAM Settings with WMI

Errors and Instances

Course: 25 Minutes

Monitoring Errors from the SQL Server Error Log
Advanced Monitoring Errors from the SQL Error Log
Obtaining Instance Information on Multiple Instances
Enabling PS Remoting on SQL Instance
Error Handling

Working with SQL PowerShell

Course: 38 Minutes

Restoring All Databases from Most Recent Backup
Finding Disk Space for SQL Files
Displaying Results in Grid View
sqlps Utility
Creating SQL Audits
SQLSERVER Drive and Invoke Sqlcmd cmdlets

Policies

Course: 15 Minutes

Course Introduction
Policies
Evaluate the SQL Policy

Jobs

Course: 36 Minutes

PowerShell Job Step
PowerShell from SSMS
Execute SQL Scripts from File
Create SQL Agent Job
Execute SQL Agent Job
Retrieve SQL Agent Job History

PowerShell Features

Course: 23 Minutes

PowerShell Variables
Piping
Use PowerShell Utility to Create Stored Procedure

Working with Databases

Course: 42 Minutes

Create Database
Create Login
Change Database User
Create Schema
Create Stored Procedure
DBCC Using PowerShell
Create XML Schema Collection
Configure Database Mail

Authentication and Alerts

Course: 33 Minutes

Connect to SQL Using SQL Authentication
Change Server to Mixed Mode Authentication
Drop Objects
Send Query Results E-mail
Create Operator
Create Alert

Delivery time	Within 1 working day
Online access	365 days
Lesson duration	4:50 hours
Study load	Variable because of practical assignments.
Learning methods	Instruction video, Demonstration video, Knowledge Base
Operating systems	Microsoft Windows, Google Chrome OS, Apple MacOS
Included services	Contact with teacher by e-mail and chat, Progress report, 24/7 online access
Supported browsers	Internet Explorer, Edge, Firefox, Safari en Chrome
MOS Exam	Possible for corresponding exam number
Access to teacher	By e-mail and chat
Extra options	Virtual Labs (if available)
Purchase	One-time fee

There are no reviews written yet about this product.

OEM Office Elearning Menu Top 2 in ICT-trainingen 2024!

OEM Office Elearning Menu is trots op de tweede plaats in de categorie ICT-trainingen 2024 bij Beste Opleider van Nederland (Springest/Archipel). Dank aan al onze cursisten voor hun vertrouwen!