Accessing SQL Server Databases from Windows PowerShell

SQL Server is the Database engine used for all the enterprise tool parts of the Microsoft ecosystem, and PowerShell is the most popular scripting language. This course will teach you how to use PowerShell to read and write data from/to SQL Databases.
Course info
Rating
(44)
Level
Beginner
Updated
Oct 4, 2017
Duration
55m
Table of contents
Description
Course info
Rating
(44)
Level
Beginner
Updated
Oct 4, 2017
Duration
55m
Description

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.

About the author
About the author

Vlad is a SharePoint and Office 365 Consultant specializing in SharePoint and SharePoint Online deployments as well as hybrid scenarios. As a Pluralsight Author, Microsoft Certified Trainer, and recognized international speaker, Vlad has helped thousands of users and IT Pros across the globe to better understand and to get the most out of SharePoint. Vlad is also a Microsoft Most Valuable Professional (MVP) in SharePoint since 2013 and has his own blog at www.absolute-sharepoint.com and he often shares his knowledge by speaking at local conferences and community events. Vlad also blogs at CMSWire as well as Computerworld and is often featured in other Microsoft sites such as Redmond Channel Partner. In Addition, Vlad is the recipient of the "Top 25 Office 365 Influencers" award, showcasing him as one of the most influential Office 365 specialists in 2015 demonstrating his expertise and passion for Microsoft's shift towards the cloud in the past years.

More from the author
Core Components of Power Platform
Beginner
1h 23m
May 8, 2020
More courses by Vlad Catrinescu
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone, My name's latte, Caffe UNESCO and welcome to my course accessing sequel server databases from Power Show I'm a Microsoft M V P and independent consultant from Montreal, Canada. Whatever you're looking to store data or to create important historical and trend reports in Power Shell sequel is probably one of the best locations to save your information. In this course, you will learn how to use partial to read and write data from work to a sequel server database. Some of the major topics double cover include connecting Toe, a local or remote sequel server, reading data from a sequel database and writing data to a sequel server database. By the end of this course, you'll be able to use Power Shell to read or write information to a sequel server database Before beginning this course. You should be familiar with the basics of Power Shell as well as the basics of sequel server. From here, you should feel comfortable diving in tow. Other partial topics with courses such as working with CS video Impartial, working with XML, ____ impartial and reporting with partial X demo and enhanced extremo. I hope you'll join me on this journey to learn power shell with the accessing sequel Server databases from poorer Shell course at thrill site