YoVDO

PowerShell for SQL Server Administration

Offered By: LinkedIn Learning

Tags

Microsoft SQL Server Courses PowerShell Courses Data Manipulation Courses Server Management Courses SQL Server Administration Courses

Course Description

Overview

Manage multiple machines at once using PowerShell. Learn how to use PowerShell to create objects, populate and delete data from tables, remote to other servers, and more.

Syllabus

Introduction
  • Manage SQL servers with PowerShell
  • What you should know
  • Download tools
1. PowerShell in SQL Server
  • PowerShell won't solve all problems
  • When PowerShell is useful
  • Differences between the two modules
  • Open-source solutions
2. Connecting to SQL Server from PowerShell
  • Declaring objects
  • Connecting to SQL Server
  • Parameters in PowerShell
  • Closing connections
  • Disposing connections
  • Object reuse
3. Creating Objects in PowerShell
  • Creating databases
  • Creating tables
  • Creating views
  • Creating procedures
4. Querying Data in PowerShell
  • Inserting data into tables
  • Returning data from SQL Server
  • Running stored procedures in PowerShell
5. Looping Through Servers in PowerShell
  • Loops in PowerShell
  • Storing servers for PowerShell
  • Concepts of threading
  • PowerShell threading commandlets
  • Authentication and threading
  • Piping between objects
  • Exporting CSV files
  • Importing CSV files
  • Exporting XML data
  • Importing XML data
6. PowerShell Remoting
  • What is remoting?
  • Removing over HTTP ports
  • Enabling remoting via PowerShell
  • Enabling remoting via GPO
  • Starting a remote session
  • Ending a remote session
  • Using alternate credentials for remoting
  • Invoking a remote command
Conclusion
  • Next steps

Taught by

Denny Cherry

Related Courses

Implementing In-Memory SQL Database Objects
Microsoft via edX
Database Design with SQL Server Management Studio (SSMS)
Coursera Project Network via Coursera
Learn React JS and Web API by creating a Full Stack Web App
Udemy
Intermediate SQL Server
DataCamp
Cleaning Data in SQL Server Databases
DataCamp