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

Order this amazing, award-winning Microsoft PowerShell and SQL Server E-Learning course online, 1 year 24/7 access to extensive interactive videos, speeches, hands-on tasks and progress monitoring. After the course you will receive a certificate of attendance.

Microsoft PowerShell is a powerful and fully featured command-line based, scriptable configuration environment for Microsoft server products. PowerShell for SQL Server exposes the full range of configuration options to the administrator. This series covers a range of topics for SQL Server management with PowerShell, from managing services to implementing policies and working with individual databases.

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!