Microsoft PowerShell and SQL Server E-Learning Training 

Bestel deze geweldige, bekroonde Microsoft PowerShell and SQL Server E-Learning cursus online, 1 jaar 24/7 toegang tot uitgebreide interactieve video's, toespraken, praktische taken en voortgangsbewaking. Na de cursus ontvang je een certificaat van deelname.

Microsoft PowerShell is een krachtige en volledig uitgeruste, op de opdrachtregel gebaseerde, scriptbare configuratieomgeving voor Microsoft-serverproducten. PowerShell voor SQL Server stelt de beheerder het volledige scala aan configuratieopties beschikbaar. Deze serie behandelt een reeks onderwerpen voor SQL Server-beheer met PowerShell, van het beheren van services tot het implementeren van beleid en het werken met afzonderlijke databases.

Cursusinhoud

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