PowerShell is an awesome tool, and as an IT pro or a Developer you probably want to use its powerful automation potential to automate your own tasks. SQL Server is the database software of choice for organizations running in the Microsoft ecosystem. Instead of storing information from your PowerShell scripts in CSV or text files, you can store this information into a SQL Database and then use SQL Server’s powerful reporting tools to create beautiful looking reports and historical data. In this course, Accessing SQL Server Databases from Windows PowerShell, you’ll learn how to use PowerShell to read and write data from/to a SQL Server database. First, you’ll discover how to get the required PowerShell Module and how to connect to both a local and a remote SQL Server. Next, you’ll explore how to use PowerShell to read data from a SQL Table. Finally, you’ll learn how to use PowerShell to write information to an existing, or a brand-new SQL database. When you’re finished with this course, you’ll have the skills and knowledge of PowerShell needed to access SQL Server databases from PowerShell.
Author Name: Vlad Catrinescu
Author Description:
Vlad is an Office 365 consultant helping organizations get the most out their Microsoft 365 Digital Workplace. IT Professional at heart, Vlad focuses on helping administrators deploy, manage, automate, and configure governance across services such as SharePoint, OneDrive for Business, and Microsoft Teams. As an author, Microsoft Certified Trainer and recognized international speaker, Vlad has helped over a million IT Professionals and end-users across the globe to better understand and to ge… more

Table of Contents

• Course Overview
  1min
• Course Introduction
  4mins
• Connecting to SQL Server
  19mins
• Reading Data from a SQL Database
  11mins
• Writing Information into a SQL Database
  13mins
• Course Conclusion
  4mins